Excel for Windows (Desktop Application)
Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more
To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
Please Allow Keyboard Shortcut Customizations In Excel.
Surprisingly Customizations In Keyboard Shortcuts Are Allowed For Excel In Mac And Not Windows Even When Both Excel And Windows Are Microsoft Trademark.
Please Add Feature To Allow Keyboard Customizations To Excel As In Work For Aiding Ease Of Access To Various Commands As Per User Preferences.
Thanks.440 votesThanks for all the votes and support of this suggestion.
We like this idea, but we don’t have customized keyboard shortcuts in our plans for Excel on Windows in the short term. We’ll keep monitoring the votes here so it can still be considered in the future.
Steve – Microsoft Excel
-
Pin worksheet tab
I would like a simple option to allow you to pin worksheets so they are always available in the workbook irrespective of the number of worksheets there are.
I.e. when you right click the worksheet tab there is an option to pin so you can quickly gain access when you have a large number of worksheets.
86 votesThis is a great suggestion – thank you for taking the time to give us feedback! Unfortunately, we will not be able to work on pinned worksheet tabs in the near future. We’ll keep tracking the votes on this one.
-Sharon -
Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)
In the good versions of Excel (prior to 2007) one could open multiple workbooks in the same window. Now, one has multiple instances of Excel (and every other Office app) whenever one opens more than one document / spreadsheet.
Again, here are the issues:
- Stability - I experience ~3X Excel crashes in 2016 (SDI) as compared to 2010 (MDI)
- Screen Space / Real Estate - Drastically reduced screen space when each workbook requires its own Ribbon, Quick Access Toolbar and Formula Bar
- Toolbar to Workbook Confusion - One Ribbon + Quick Access Toolbar + Formula Bar to control all workbooks…
1,310 votesThanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.
Some of the specific issues mentioned are addressed as follows:
– Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
- Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
- Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook. … -
Make the Go To box SCALABLE
Formulas / Trace Dependents / make the resulting list box SCALABLE.
It is 100% useless if the full name of the referenced cells cannot be seen in their entirety, which is usually the case.
I know others have been asking for this for YEARS.
22 votesThanks for the feedback! Unfortunately we will not be able to address this in the near future. We’ll keep tracking the votes on this.
-Sharon -
Display Status Bar of Inactive Window 2016 Excel
In Excel 2010 we were able to highlight numbers and have their sums displayed in the grey status bar towards the bottom of the sheet. Working with 2 monitors, this feature was very helpful.
After upgrading to Excel 2016 the status bar of the non active/selected workbook disappears instead of the sum being viewable of the non active workbook.
The feature was helpful for at least 2 open excel instances where we can view the sum of the non active workbook and it would be great to have back instead of being forced to click in out of each workbook…
93 votesThanks for the suggestion! We will not be able to address displaying the status bar in an inactive window in the near future, but we’ll continue to track the voting.
-Sharon -
Support multi-row worksheet tabs, or vertical tabs, or font size (some way to see more sheet tabs at a time)
(2015-11-05 Dan [MS] - recategorized and clarified idea title)
653 votesThank you for taking your time to suggest and vote for this. We do think that this suggestion has merit, but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it so we know how it ranks among the other suggestions.
-
Worksheet groupings
Workbooks with many worksheets can be difficult to navigate. One poster has suggested having multiple levels to the worksheet tabs.
As an extension to this, we could have worksheet groupings where several worksheets could be contained within a grouping. You could then select a particular grouping (which would look like worksheet tabs and be placed below the actual worksheet tabs) and then have access to all the worksheets in that particular grouping. There would also be an 'All' grouping that contained all the worksheets.
These grouping could be included in the workbook protection so that you could choose which worksheet…
115 votesThis is a great suggestion – thank you. Unfortunately we don’t think we will be able to address worksheet grouping in the near future. We’ll keep tracking the voting.
-Sharon -
Freeze pane for bottom row(s) of a range
It would be good to be able to freeze one or more bottom lines (as well as the headers) of a range or table to be able to keep things like totals in view at all times.
Similarly, freezing columns on the right hand side of the sheet would be useful sometimes.26 votesThank you for voting for “freeze pane for bottom row(s) of a range.” While this is a cool idea, we are not able to work on this soon.
We’ll keep tracking the votes on this.
-
Alphabetically sort sheets/worksheets in a workbook
When working with large data sets, I often ended up with 50+ sheets of data, and each sheet was named by a given convention. To my knowledge, there isn't a way to sort them alphanumerically without a macro. Giving the user the ability to sort so that a1 is first then a2,b1,b2,etc rather than having to sort by hand or use a macro would be seriously amazing.
23 votesThank you for suggesting this. We do think there is value in this idea, but we don’t think that we’ll be able to devote time to it in the near future. We’ll keep tracking the votes on this.
-Eric Patterson
Excel Program Manager
- Don't see your idea?