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.
-
swaping xy ranges
When charting xy charts the order of the columns determines which axis is used for X and Y. To change around you need to drag one selection over, drag the second to the first column then drag the first to the second.
It would be much easier and simpler to have a swap axis button for the series so can swap over. Suggest put in Select Data box.
Lotus 123 had it 40 years ago!
1 vote -
Bug Chart select data source
when adding more ranges to a xy chart the Series Y values: has a =(1) in the input box that needs to be deleted every time before adding a range. Takes key strokes to delete and I have never understood why its there.
A second bug turns up where again adding a new series that will not allow input to the Y series. The work around is to press OK and reedit the series again deleting the =(1) before adding
1 vote -
Rounding Error in Excel
You have a serious rounding error issue in excel that I confirmed with your help desk they could recreate.
Go into excel and type -3 in cell B2
In B3 type the formula =B2+0.1
Copy the formula down to cell B36
Cell B32 should read 0 exactly but does not 1.53E-15
I had this rounding error turn up when creating a more complex spreadsheet and could not understand why there is an error
if you format the cells to 30 decimal places you will see that when 0.1 is added to -1.1 the answer returned is -0.999999999999998000000000000000
not -1.00000000000000000000000000001 vote -
highlight cells with find tool
When using the find tool it now barely outlines the cell. The old excel would highlight it so it was obvious which cell was found. Now it just puts a dim green line around it making the find tool MUCH less helpful than it used to be. A glaring step back on the newer excel making it less useful than previous versions.
1 vote -
It would really ******* great if the appliction window did not shift up and down repeatedly when working with a document.
It would really ******* great if the application window did not shift up and down repeatedly when working with a document. HOW ABOUT THAT FOR NEW FEATURE? You ***** add all kinds of useless new features- how about un-******* one of your last crapware updates?
1 vote -
Recent Query and Connection issue
Recently after update I spot that my Power Query is not connecting to my Organizational account and moreover when I want to download something from web --> Connection Properties --> Edit Query... does not work properly.
Multiple pictures attached.
Please fix this as soon as possible
1 vote -
Recent Query and Connection issue
Recently after update I spot that my Power Query is not connecting to my Organizational account and moreover when I want to download something from web --> Connection Properties --> Edit Query... does not work properly.
Multiple pictures attached.
Please fix this as soon as possible
0 votes -
Need normal filter option for pivot
Using Pivot Table, it gives a filter option for 1 or 2 columns only. Why cant we have a simple filter, that we use in a normal table. To get that, I copy paste my pivot into a text in excel, then apply a normal filter for my working.
1 vote -
Need a normal filter option for pivot tables
Using Pivot Table, it gives a filter option for 1 or 2 columns only. Why cant we have a simple filter, that we use in a normal table. To get that, I copy paste my pivot into a text in excel, then apply a normal filter for my working.
1 vote -
After a recent update, the "Insert Comment" option is no longer available from the right-click menu.
The "Insert Comment" option is no longer available from the right-click menu. It is still visible under the "Insert" tab, but the button is gray and I can't click on it. I can use shift + F2 or I have to add a custom group to the ribbon in order to get it to work. Why has it been removed from the right-click menu and why has it been disabled?
1 vote -
STOP JUMPING THE ******* SCREEN UP AND DOWN WHEN SCROLLING. ******* YOU.
STOP JUMPING THE ******* SCREEN UP AND DOWN WHEN SCROLLING. ******* YOU.
1 vote -
HEY ********- WHY IS THE SCROLL BAR ON THE LEFT SIDE OF THE SPLIT VIEW MAGICALLY GONE TODAY? ********.
HEY ********- WHY IS THE SCROLL BAR ON THE LEFT SIDE OF THE SPLIT VIEW MAGICALLY GONE TODAY? ********.
1 vote -
Vim keybindings
Can you incorporate vim keybindings for excel, it would be magnificent?
1 vote -
Make is easier to download onto chromebook
maybe one app thaty would download the whole windows package with all apps included......
1 vote -
"Eng" number fomatting
One of the most common formats in numbers is Engineering format, i.e. 1.5E-3, 1.5E-6, 2.34E-9, etc. Used in the scientific community but referred to as Engineering format. 1.62E-2 would become 16.2E-3, which is easier to use in engineering. Would be great to add Eng format to the numbers formatting drop down menu.
1 vote -
STOP BOBBLING THE ******* WINDOW UP AND DOWN WHEN SCROLLING. UNFUCK YOUR CRAPWARE.
STOP BOBBLING THE ******* WINDOW UP AND DOWN WHEN SCROLLING. UNFUCK YOUR CRAPWARE.
1 vote -
Heres a suggestion. Unfuck your applications so that the windows do not jump up and down when scrolling within the document
Here's a suggestion. Unfuck your applications so that the windows do not jump up and down when scrolling within the document
1 vote -
to be able to have an area that you can store a fill-in color and a font color in the same box
have an area devoted to have a fill color and a font color in the same box so when you need to use that combination of fill and font all you would have to do is pick that box and it does both at the same time. We use this a lot and this would be very helpful and speed the process up rather than pick the font and then pick the color then pick the fill and then pick the color. These should be user defined and allow users to set this up. maybe a spot for 5-8 such…
2 votes -
bring back performance for calculations, filters and conditionnal formatting
Overall performance of calculations, conditionnal cell formatting and auto filters have suffered a lot in the last two versions of Excel.
We use to put formulas everywhere. Now I must recommend users to use them with caution because it might freeze their Excel and changes will be lost if it crashes.
Now I must make sure those formulas are taken care of by SQL queries so Excel does not have to bother about it. But that puts a lot of pressure on my team which we had not when formulas were running like lightning.
Also, display of formatting with an…2 votes -
Improving the =PROPER function
The =PROPER function is so useful for me when adding products to my website however it doesn't recognise units of measurement or abbreviations and will add an upper case letter at the beginning and turn everything else to lowercase.
What would be great is for it to automatically recognise units of measurement i.e. millimetres is represented as "mm" and not "Mm".
Also for there to be a feature in the system whether its under preferences or something to enter abbreviations so that the function does not touch these. i.e. instead of writing More Than Safety it can be abbreviated to…
1 vote
- Don't see your idea?