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.
-
I'd like to avoid the "DISCLAIMER regarding financial market information... etc." - please allow possibility to tick off after reading
Hi
Seeing the "DISCLAIMER regarding financial market information is provided as-is... etc." multiple times is annoying.
Please provide a possibility to tick off the disclaimer after having read it - potentially based on the user, so it pops up ONE TIME for each new user of the spread sheet.
I hereby hope NEVER to see the Disclaimer after having seen it ONCE in the same spreadsheet :-)Regards
Søren9 votes -
There are Duplicate Shortcuts For Converting a List into Table, Let's use one them for another functionality
A Table has a lot more functionality than a List. Although there are 6 different ways of converting a List into a Table, Excel users find it easy to do that with a shortcut. Surprisingly there are 2 shortcuts performing the same exact task:
CTRL + T (T stands for Table) or CTRL + L (L stands for List)
Why should we reserve 2 shortcuts for the same action? let's keep only the relatively new one CTRL + T (users are familiar with this one)
While Assign the older shortcut CTRL + L to copying to the left (L stands…35 votes -
Money add-on for Canada
Hello. I just heard about the new Money add-on for US users. Looking forward to have this available in Canada.
31 votes -
text water mark
Right now we have only Addition of picture for watermark. Adding text water mark option as given in ms word will help us a lot.
5 votes -
16 votes
-
Timespan calculus
Currently, in cells formatted as time ([$-x-systime]h:mm:ss AM/PM), if I sum 16:00 and 12:00, I get 04:00. I would like to have the possibility of getting 28:00.
Maybe this could be achieved through a new TimeSpan cell format that would show the absolute number of years, months, days, hours, minutes, seconds, etc. without a calendar, according to the selected format.
So, 28:00 could, also, be shown as "1 day and 4 hours", or "1d4h", depending on the format selected by the user.
Those TimeSpan cells would operate with other cell formats nicely. It would be possible to add a time…
3 votes -
Lambda optional parameters
Using the new lambda function, can we have the ability to put parameter names in square brackets to turn them into optional parameters for the user?
LAMBDA(parameter1, parameter2, [parameter3])
This would be extremely useful for reusable functions. For example, I've created a function that combines arrays, but I don't want to have limit that function to passing only a specific number of arrays or forcing the user to enter commas for the remaining criteria. Similar to index, or sumifs or other function that has optional parameters please!
Also, if you're feeling generous, I'd love the option of hidden parameters too,…13 votes -
Color box - wrong color arrangement
Hello,
suggestion to change the color box so that the basic colors are red, blue and yellow.
The current situation is red, blue and green.
The reason is that green is not a basic color.
Regards
2 votes -
financial market information disclaimer
I know this has been requested in the past by others. But:
The Financial Market Disclaimer, across the top of the spreadsheet, when using stock data, needs to be removed as it is in the users face. Just have one universal acknowledgment, like the investment banks have, and remove the disclaimer.13 votes -
SUMCOLS and SUMROWS functions for Dynamic Arrays
Create new functions that SUM each column in a dynamic array (SUMCOLS(Ref#)) to produce a row of totals, and SUM each row to produce a column of totals (SUMROWS(Ref#))
Also COUNTCOLS, COUNTROWS, AVERAGECOLS, AVERAGEROWS, but these are less important than SUMCOLS & SUMROWS.
300 votes -
MBOX to PST Converter
If you wish to convert MBOX to PST files, first try the SysInspire MBOX Converter application's Free Trial edition to convert MBOX to PST files with just a few things from each mailbox. The trial version will show you how to use the software and its features, as well as how to convert MBOX files to Outlook PST files right away. Additionally, you may convert MBOX files to a variety of file formats, including EML, EMLX, MSG, MSG, and MSG, as well as Office 365.
Read More:- https://www.sysinspire.com/mboxconverter/
1 vote -
Get rid of scientific notation being automatically applied on large numbers
Excel automatically converts large numbers to scientific notation. This is possibly the most useless and annoying feature ever. Please stop.
17 votes -
Property in Power Query "Enable background refresh" - default to unchecked
When creating a new query in Power Query, by default the property "Enable background refresh" is enabled. Please make this property be unchecked by default. The cases where I need this property disabled outgrow at large the cases where the background refresh can be turned on.
31 votes -
formula bar position
With the advent of more programming type formulas (LET/LAMBDA etc), I would love to be able to resize and reposition the formula bar to the left or right hand side as a pane. Often times I need to scroll up and down a formula to see the impact of a formula change on a range of cells. A portrait orientation pane would solve that.
Possibly a floating thing would work. Actually yeah, a floating undocked formula pane would be sweet. Do that.
5 votes -
Make it possible to open 2 workbooks with the same name
There is no reason for this not to be possible.
5 votes -
Power Query Advanced editor
Please add Find/Replace to the Power Query Advanced Editor. Please! Please again!
5 votes -
There is No direct command for clearing the Data Validation on the Ribbon
Everyone is using Data Validation in Excel for simple or complex projects. However if you decide to clear your data validation rules there is No direct command on the ribbon to do that: So you have to go to the Data Tab >> Open the data Validation dialog box >> Click on Clear All >> Close the dialog Box.
My suggestion is to integrate this functionality with the Data Validation button in the ribbon (as explained in the attached Graphic) which will enable the user with a click to either clear Data Validation from a selected range or from the…40 votes -
Microsoft 365 Apps for business can’t use the "From Online Services" option in the Get Data feature of the Excel application
Title: unable to connect to SharePoint online with power query from Excel
Desc:
There is no SharePoint Connector as mentioned in the support docs at: https://docs.microsoft.com/en-us/power-query/connectors/sharepointlist3 votes -
A "Back" button that would take the user to the previous worksheet
I've always dreamed of a button where I could just hit back and I would be taken to the previous worksheet I was just working on.
The problem is, you can't easily create this with VBA. If you run a macro to record a user's action, you break the undo chain.
The back button would make a perfect and homey addition to a quick access toolbar.
2 votes -
Display pivot table headers in the columns headers
With the tables, if the header is not visible, Excel displays the headers of the table in the columns headers (see the picture attached)
It will be great to have the same behaviour with the pivot tables
63 votesWe’d like to see how many votes this gets as a way to help us prioritize the work. Thanks!
- Don't see your idea?