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.

Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality (see description)
Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality for example =UNIQUE({Z:Z},{A:A})
Also, please upgrade the protection similar to Google sheets or rather launch all Google sheet functions here as well.
3 votes 
Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality (see description)
Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality for example =UNIQUE({Z:Z},{A:A})
Also, please upgrade the protection similar to Google sheets or rather launch all Google sheet functions here as well.
3 votes 
2 votes

Convert Dynamic Arrays into Tables
The new Dynamic Arrays make possible to automatically fill down formulas. Tables can also fill down formulas. Microsoft Excel Team could make both features be compatible so we could convert Dynamic Arrays into Tables making them expand and shrink according to the main formula.
157 votes 
Add a MONTHDIF function
The formula should work like the YEARFRAC function. It should calculate partial months on either end of the dates. So starting 1/15/20 should calculate as 16/31 days or 0.516.. months, and ending at 6/5/20 should calculate as 25/30 day or 0.8333.. months. Currently, I have to use a ridiculously long formula to achieve this.
42 votes 
Need Stock Data Type Functionality on Office Pro Plus 2016
Dear Microsoft Team :( ,
Did you know there is a Stock Function in all your desktop versions of office products and did you know it does not work?
I am wondering if you will ever get it to work? It's not that you are short on funds to add that additional line of script to pull the free data from from exchange.
If you still don't want to give it as a free update to your customers, you can sell it as a chargeable addin.
If you don't want to do either, please add a popup saying "YOU WERE…
3 votes 
COUNTIF, SUMIF............etc. based on cell color
If Excel allow us to use cell color as function criteria, it would be wonderful.
2 votes 
DECODEURL function
Currently, The ENCODEURL function returns a URLencoded string, replacing certain nonalphanumeric characters with the percentage symbol (%) and a hexadecimal number.
There needs to be a DECODEURL function that does the reverse, replacing the percentage symbol (%) and a hexadecimal number with the appropriate nonalphanumeric characters.
2 votes 
DONT'T CHANGE MY FORMULA!!!!!!!
How about keeping the formula intact, returning a #REF result and NOT editing the formula with a #REF comment. This stupid idea prevents one from following the formula back and evaluating what the error is, or what cell it's referencing. Who ever thought of doing this should have some training! If one receives a spreadsheet developed by someone else, they may not know how the formulas work/reference, but leaving the formula intact gives the opportunity to understand what the result should be. CHANGING the formula should NEVER be an automatic option by the software!!!!!
11 votes 
Formula to get valueout of merged cells
lets say we have merged cells A1:D10, when I do =A1 then I get the value, but when I do =C3 then I get nothing becuase the value is not stored the. But if there would be function, lets say =GetMergedValue(C3) so it would lookup the merged area and gets the value, this would be great!
2 votes 
Date picker button for excel in offfice 365 for Windows 10 64 bit
I am so surprised that there is no Date picker function available in Excel 365. I see that this function existed and has been removed. this makes no sense to me what so ever. This is what has been pushing me away from Microsoft. This is why I have stopped using One note ( due to feature removals) and seek other options as you just cant rely on such thing.
I feel less protective of Windows/ MS at home and hence Apple and Google devices have started replacing MS specially by Kids. Surface pro 4 was highly disappointing. So now…
3 votes 
Support of dynamic array formulas in tables
Support of dynamic array formulas in tables
1 vote 
Formula to return multiple values from LookUp function
We need a simple formula that can return all the values from data source based on a lookup. Vlookup, Xlookup return only first matching value and don't check further.
1 vote 
Add NonRepeating Option to RANDARRAY
Currently it is difficult to get nonrepeating random numbers in Excel. Can we add an option to RANDARRAY to force it to only generate unique random numbers?
3 votes 
vlookup case sensitive
very simple,VLOOKUPs are case insensitive, VLOOKUPS should be case sensitive. One use case are Salesforce reports. They produce 15 character Ids that require case sensitivity functionality in order lookup against.
11 votes 
Allow lookup functions to spill in two dimension
Currently Vlookup, Xlookup, Lookup and Index function is able to produce a spilled array only across one dimension (i.e. row or column).
So, if I give a formula like =Vlookup(J4#,Table1,{2,3},0), it spills only across rows and does not spill across column. This limitation exists with every other function in the lookup family.
If these functions can be made to spill across both the dimensions, we can completely avoid copy pasting in MS Excel.
1 vote 
Disable the "SPILL!" error function completely
Disable the SPILL! error fucntion/code completely, it is garbage and wrongfully tags formulas with SPILL! Having to go in and change formula syntax to satisfy this random error is ridiculous.
4 votes 
Please add Xlookup and XMatch functions for Office 2019 Professional Plus users.
Please add Xlookup and XMatch functions for Office 2019 Professional Plus users.
For that matter either give Office 2019 Pro Plus users the option to migrate to Office 365 at a reduced cost or provide the nice new office 365 functions to Office 2019 Pro Plus users
3 votes 
Extend XLOOKUP and XMATCH to return nth matched item/position
INDEX, MATCH and other variants return the FIRST value that matches the given criterion. Extend the functions (especially the new XLOOKUP/XMATCH functions) so that the formulae return the nth matching item or position
Extend XLOOKUP and XMATCH to return nth matched item/position
9 votes 
Immediately colorcode cell references upon selection
When we edit a cell by doubleclicking it or hitting F2, we get a very helpful colorcoding of the cells it references. Why can't we just get this colorcoding immediately upon selecting the cell? That way we could easily click or arrowkey through several cells and quickly see what they're referencing, rather than having to squint and find "Column G.... Row 11....., Column K .... Row 15....", etc.
See attached GIF animations demonstrating the current behavior versus what I'm proposing.
3 votes
 Don't see your idea?