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 inapp 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 thirdparty 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.

Save as option when right click on the sheet tab
I want to be able to save a single sheet(or just selected sheets) to a new file  if I have many sheets I need to delete the ones I do not need after saving to a new file.
2 votes 
Content Pane Remove Size Limit, Add Positioning, Resizing
There is a limitation to the width and height of a Content Pane at 1000 x 1000px. This limit is imposed when resizing via mouse in Excel Desktop and the JavaScript API. This (via mouse) is not true in Excel Online (or in PowerPoint) where the size can be set and saved to any size via mouse.
It would make the Content Pane consistent and open up a huge number of innovation opportunities to remove the current 1000 x 1000px limitation in the JavaScript API and Desktop Content Panes in Excel.
The ability to position and resize the Content Pane…
6 votes 
Better Support for Analysis Services Tabular
It's about time to improve support for SSAS Tabular:
1. Autogenerate DAX
2. Avoid splitting a table into a "measure group" and "dimension". See how PBI Desktop handles metadata.
3. Carry over data types so that users can create reports, such as show me invoices where Due Date is greater than ... Currently, all dimension table fields map to Text.
4. Many customers have expressed interest to connect Excel tables directly to Tabular, bypassing Pivot Table, so they can use the column dropdowns and other Excel goodness.
5. Support descriptions as tooltips when the user hovers on a field in…63 votes 
I need to open documents that have numbers starting with zeros without Excel dropping the zeros
open documents that have numbers starting with zeros without Excel dropping the zeros
15 votes 
MS Office 365 ProPlus, Excel / Access date recognition bug
MS Office 365 ProPlus, Excel Version 1808, Build 10730.20280
What I did:
1. Copy column B to C
2. Replace "2018" with "2019" in column CWhat is the result:
 German month names are recognized
 English month names only recognized for Apr, Aug, Sep, NovWhat I would expect:
 English month names are recognized as wellSame result within MS Access
1 vote 
Name a dynamic array (rather than use "A1#" notation)
The new dynamic array notation is incredibly powerful, but one thing that makes formulas complicated is the "A1#" notation when used in formulas.
It would be great if you could (easily) assign a name to it in the same way that you can name an Excel table.
It would be much easier to see:
=SUMIFS(TABLE1[totals],TABLE1[dept],departments)
than
=SUMIFS(TABLE1[totals],TABLE1[dept],B1#)
I am able to define a named range for these values, but that is a bit clunky. It would be great if the naming was exactly the same as Table naming (e.g. in an ARRAY context menu like the TABLE context menu).
10 votes 
Fuzzy Match in Power Query Excel
Include Table.FuzzyNestedJoin fuzzy match capability in Power Query Excel
3 votes 
How about a function to enable data to be swapped from one cell to another, eg if you want to move an item up a list to another cell and hav
A function to allow you to swap data from one to another, eg when constructing a list of priorities, if you have data in a cell that you want to move up a list to a cell that already has data in it then that data should have an option move to the cell that was just vacated. This would help when prioritising cell contents without the need for inserting cells, cutting & pasting and remembering what you have pasted over when cutting cells.
2 votes 
Correct illogical limit of 255 characters for entering Matrix formulas using VBA
When you use Excel, you have a limit of 8192 for the lenght of a formula.
When you assign a matrix formula using VBA, it is restricted to 255.
Even using macro recorder, it'll save the correct instruction, but then it'll be useless as VBA won't execute that instruction.6 votes 
New Template, Investment Tracker, Use in UK
This is a great idea. But I am in UK and entering my shares does not work.
(XLON:RDSB) produces a field error.
(XLON:AV.) produces a US$ price which is about 10 times the actual £ price.
The template is just what I need; but as with many others I have looked at it is not easily adapted for UK use. This severely limits the value of their subscription for UK users of Office 365.Can UK versions be supplied, please?
1 vote 
More vba events
VBA events are extremely powerful but currently they are seriously lacking! If the Excel team went through and exposed more events VBA would a lot easier to manage for complex applications.
Events to expose:
* Row and column insertion
* Table specific events:
** Table  Insert_Row
** Table  Insert_Column
** Table  Cell_Change
** Table  On Filter
** Table  On Filter button click
* Chart events!
** Chart  On Mouse Down
** Chart  On chart object select
** Chart  On chart resize
* Shape events
** On shape resize
** On shape click …12 votes 
A tool is needed for auditing Conditional Formatting formulae
Conditional formatting allows a formula as part of a rule, and that formula may refer to another cell in the workbook. If that other cell is deleted, then a #REF error creeps into the conditional formatting formula.
Of course a properly constructed formula would allow for such circumstances, but there is no simple method to check the conditional formatting rules to validate them.
It would be helpful to have a way to download the conditional formatting rules to allow the programmer to audit those rules.3 votes 
Filter Option  for 6 Months
In Filter, there are options for Last Week, Month, Quarter & Year. There could be following 2 options that can help user a lot:
1) Last 6 Months
2) First 6 Months (Current Year)26 votes 
undo by cell
Have a way to undo the last thing that was done to a specific cell, without having to undo everything that has been done since that. I have a workaround, but it is a bit involved.
3 votes 
add to the ribbon a nummeric updown control
Not only to excel but to all of office
implement getmin, getmax, getvalue3 votes 
Sync ribbon settings
I want to sync settings that is ribbon customize in my O365 account.
Now I need export ribbon and import.3 votes 
A formula to calculate the direction of a vector from 0 to 360 degrees.
The formula is working for any value of x and y, is not using any trigonometric function and give the result with an accuracy of one billionth of the degree.
f(x , y)=180/pi()*(pi()/8*sign(x*y)*sign(y^2x^2)+pi()/4*(42*sign(y)sign
(x*y))pi()/2*(1sign(y^2))*(sign(x^2)+sign(x))
n=0
sign(x*y)*Σ(1)^n*((abs(x)*(sqrt(2)1)^(x^2y^2)abs(y)/
n=17
(abs(x)+abs(y)*(sqrt(2)1)^(x^2y^2)))^(2n+1)/(2n+1))2 votes 
Copy multiple selections into Clipboard
I've always wanted the option to copy multiple selections to the clipboard. When you paste, you'd be presented with the option of everything on your clipboard, to be able to pick which selection(s) you want to paste.
10 votes 
Parameters passing to Named Ranges
I'd like a simple passing of parameters to Named Ranges that would work similarly to the way they are passed to functions:
=VLOOKUP(A12,People,2,FALSE)
for example. Similarly, if I had a Named Range (call it "Horse") that implemented the VLOOKUP() function and desired to pass it the first and last parameters needed by VLOOKUP(), I would enter:
=Horse(A12,false)
I CAN do this, with a LOT of work to set it up each time, and not, um, precisely looking the same, but close:
=Horse + N("A12,false")
but again, not only is the work involved onerous, the bulk of it means that a…
1 vote 
Set default to Copy  paste visible only, opt into paste hidden
Set default to Copy  paste visible only, opt into paste hidden
The Default setting should be able to be set for visible only with paste special being for hidden.Really annoying when working with filtered lists and pasting on everything hidden and not knowing / forgetting.
3 votes
 Don't see your idea?