Excel for Windows (Desktop Application)
Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.
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.
-
Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems
It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.
This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.
It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.
335 votesHi all,
Thank you for taking your time to suggest and vote for adding Get Parameter button to Power Query. 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. When our plans are updated we will re-open voting and you will be notified.
Thanks,
Guy Hunkin
Excel Program Manager -
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)
471 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. When our plans are updated we will re-open voting and you will be notified.
-
VLookup and Inserting Columns: VLookup should increment the col_index_num when you insert a new column in the range.
When you insert a column and it affects the range referred to by a vlookup, the table range updates but the column index number does not. The column index number should increase with the table range so that the same column is pulled. I can't think of a scenario where inserting columns in a table but not updating the column index is a user's intended course of action.
44 votesSince the XLOOKUP function is now available in Excel to O365 subscribers, we recommend using it to accomplish what you need to do. With XLOOKUP, there’s no index number. You provide a range reference, so it will automatically adjust if you insert a column that causes the range to move.
-
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.
20 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. When our plans are updated we will re-open voting and you will be notified.
-Eric Patterson
Excel Program Manager -
Fiscal Year
In options, have the ability to use a fiscal year setting.
20 votesThank you for suggesting this. We don’t think that we’ll be able to devote time to it in the near future. When our plans are updated we will re-open voting and you will be notified.
- Don't see your idea?