Excel is one of Microsoft’s premier productivity apps. CEO Satya Nadella said in June 2016 – “there's one product that stands above the rest as the best consumer product that the company has ever made — and a symbol of what the company is all about. Think about a world without Excel. That's just impossible for me". With millions of customers worldwide, the Excel team is looking at unique and differentiated ways to connect with our customers. We know that Excel users are extremely engaged… they want to learn new skills, contribute content and knowledge back into the community and form a strong, thriving community. We have seen this since the launch of our Excel community which is now one of the biggest community on the MSFT Tech community site. We launched the Excel World Championship from October 2016 to March2017 for the first time and the reach was amazing - millions of impressions worldwide and 6000 participants from 60 countries! Excel skills are proudly displayed on resumes, and it’s one of the top 5 skills employers look for (only bested by such basic competencies as communication and organization).
For such a large and engaged user base, it’s very important that we continue to delight them and improve the product based on their desires. We are making deep investments both in the product and customer outreach activities to truly embrace “Customer Love” culture within the Excel team. UserVoice is a site we use to capture feature request from our users. Over the last 6 months in 2017, we have released many features as requested on users on Excel UserVoice across various platforms. Overall we are proud to announce that we have addressed more than 20% of the issues by votes! It is important to note that those updates or new features are released to production for our Office 365 subscribers.
We love hearing from our customers. So continue to provide your suggestions and ideas for the next version of Excel on UserVoice. We will do our best to respond to the top suggestions.
Excel User Voice Features Shipped in 2017:
Desktop (Windows)
- Personalize the default PivotTable layout
Set up a PivotTable the way you like, and start with that layout every time you create a new PivotTable. Link - Keep the copy
Copy your cells, and before you paste, you can still do other tasks like typing or inserting cells. Link - Quick access to Superscript and Subscript formatting in Excel
You can now add the Superscript and Subscript commands to your QAT or Ribbon. In Excel Options, select Customize Ribbon or Quick Access Toolbar, select the commands from the list of popular commands and add them. Link - Collaborative Editing
Work with others at the same time in your workbook. Link
Mac
- Pictures in Headers and Footers
Customize your printed workbooks by adding images to headers and footers. Link - Add Page Break Preview Buttons
Add buttons to the ribbon and status bar to enable customers to find the command. Link
Web
- Freeze Panes: Allow creation and modification
The ability to freeze the top row or first column or specific part of the view. Link - Select the entire grid/select all
Excel Online now supporting the ability to Select All cells in a range, a table, or sheet; by using Ctrl+A or by clicking the triangle at the top left corner. Link - Format Painter
Excel Online now supporting Format Painter. It has been added to the ribbon. Link - Find improvements and Replace
Improved Find and replace dialog. Includes replace/Replace all and stays open until dismissed. Link - Shapes: Roundtripable & light edit, Rotation
Workbooks containing shapes can now be edited. Link
Mobile
- Tap or draw?
Choose whether your Apple Pencil selects or inks by default. Link - Collaborative Editing
Work with others at the same time in your workbook. Link - More Functions
New logical functions IFS and SWITCH, will shorten the formulas you write. Link - Enter data with a snap
Easily enter numbers and formulas with the new Number panel. Link
Subscribe to the Excel Blog to get the latest product announcements and updates