Excel for Windows (Desktop Application)
Update: Microsoft will be moving away from UserVoice sites on a productbyproduct basis throughout the 2021 calendar year. We will leverage 1^{st} party solutions for customer feedback. Learn more
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.

New Formula editing experience
With the arrival of LAMBDA and LET we now need a new formula bar experience. Please vote and put your suggestions in the comments on what features you’d like the formula bar to have
144 votes 
See LAMBDA inputs and text in formula edit box
When selecting a cell with a LAMBDA function and then using the fx icon to display the Functions Arguments dialog it would be wonderful to see the function's input name(s) and description (from Name Manager's Comment box).
Please see attached mockup
54 votes 
A New Function to Make Scalar Functions More Powerful in an Array World
When Dynamic Arrays (DA) were introduced, it opened a plethora of possibilities and a lot of formula nerds and automation ninjas were empowered to begin a new wave of creativity while building more powerful worksheets with fewer formulas. As we explore the potential, we are discovering that there is a new limitation that begs for a solution. This is a proposal for a new function, SEGMENT, that can expand the flexibility of scalar functions that accept arrays as parameters so they can operate more robustly in an array world.
Consider the following problem as an example.
We have a twodimension…
20 votes 
Use new dynamic arrays in data validation
The use helper columns in tables now often is unnecessary if using the the new dynamic arrays. But if I want to use the output of one of the new functions as the source for a data validation list, I need to put the function in a cell and reference to that cell as the source for the data validation list. I would like to be able to put the dynamic array function directly into the source field of the data validation dialog.
Example: I have a table with a column of countries. I want to add a cell with…75 votes 
Add a Split dynamic array function
Add a dynamic array function to split apart a delimited range. See attached file for an example.
314 votes 
would like to make a cell "flash" on given condition
would like to make a cell "flash" on given condition
6 votes 
Allow INDIRECT to work with dynamic names
Now that we have dynamic arrays, we can set up dynamic range names to define those dynamic ranges.
However, because INDIRECT doesn't work with dynamic names, we're limited in the ways we can use those dynamic names.
Please fix the INDIRECT function so that it works with dynamic names.
19 votes 
16 votes

Timespan calculus
Currently, in cells formatted as time ([$xsystime]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 
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 
Add FLATTEN() function
Background
Quite often you need to transform a list of horizontal and vertical ranges into 1 single column of stacked values.
 In A1:A3 put 1, 2, 3 respectively.
 In B4:B6 put Hello, World, Microsoft respectively.
In order to get a single column of those 2 range you need to use these crazy formulas like described here, for example: https://www.extendoffice.com/documents/excel/2775excelconvertmatrixtosinglecolumn.html
https://www.youtube.com/watch?v=Q9NjdogVBo8
https://www.youtube.com/watch?v=4qZ8ud8akusIf you put any of those formulas from videos in C1 cell result should like that:
C1 = 1
C2 = 2
C3 = 3
C4 = Hello
C5 = World
C6 = Microsoft.
Problem
The problem is that…
4 votes 
Can we please get IntelliSense for LAMBDA functions?
Add the ability to define arguement prompts when using a LAMBDA function
11 votes 
Stockhistory function to return the correct historical price  adjusted for splits AND Dividends
Currently the stockhistory function returns a historical price that is only adjusted for splits. Using this to calculate historical returns for any instrument that pays any sort of dividend or capital gain will yield incorrect results.
5 votes 
SUBSTITUTES function supporting arrays of "find" and "replace" parameters
From time to time, users need to remove multiple characters from a string. For example, you might want to remove all punctuation, or all accented characters.
Right now, you have to do that with a lengthy nested formula using the SUBSTITUTE function. Such formulas are hard to read and challenging for a novice to debug. Or you could write a VBA userdefined function that performs each of the substitutions for you.
The better approach would be a SUBSTITUTES function that works like SUBSTITUTE but accepts an array (or range of cells) for the Find parameter, and possibly also for the…
138 votes 
Excel Aggregate Place Value.
Hello team,
I would like to suggest an idea in excel. since I am using Microsoft Office for a long time, my work was going well unless I discovered a problem. it is actually not a problem but I think a feature can be added.
Suppose, when I calculate a value from multiple cells and get the result in the decimal form we can use place value to round off the value and see the value, but it would be great efficient if somehow exact value (after round off) could be generated by the system itself.
Example:
497*45% = 223.65,…2 votes 
Allow me to run multiple instances of Excel again (as in 2010)
The intent here is to allow me to disable autocalculation on one (1) spreadsheet, without disabling it on all open spreadsheets. I should then be able to manually trigger calculation on one (1) spreadsheet without triggering calculation on all open spreadsheets.
2 votes 
Correção na documentação da função SOMA
Correção na documentação da função SOMA.
Correção da documentação na função SOMA, como neste exemplo anexo informa que se deve informar de 1 a 255 "números" mas que na verdade são argumentos, podendo dentro delas constar números, célula, intervalo de células, funções ou fórmulas e não somente números, para um usuário que está começando e lê isto pode, e já
foi presenciado, inserir de forma manual números nos argumentos por não ter o conhecimento e não estar especificado de forma correta a diversas formas que pode ser aplicada.
Como sugestão alterar o "núm1;núm2"... para arg1;arg2... e de 1 a 255…34 votes 
Allow UNIQUE() to operate on a rectangular range, returning all unique values
The new Dynamic Array function UNIQUE is awesome. It can return all of the unique items in a column or in a row. But it would be nice if the second argument could accept a 3 to indicate cellbycell.
For example, see the screenshot below.108 votes 
Change external file links with the INDIRECT() function without having the file open – Welcome to Excel’s Suggestion Box!
Pouvoir utiliser la fonction somme.si sans être obliger d'ouvrir le fichier source
4 votes
 Don't see your idea?