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.

Add a Split dynamic array function
Add a dynamic array function to split apart a delimited range. See attached file for an example.
270 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…40 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.
277 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…33 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…
118 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.92 votes 
"Excel found a problem with one or more formula references"  Please tell me where!
One of my least favorite messages that Excel provides is:
"Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."
But I can never find the bad references. It's usually buried somewhere very deep, in a chart series formula, or in a name definition, or who knows where else.
If Excel finds a problem, please Excel, tell us where it is.
253 votes 
Please create a FILTERJSON (FILTROJSON) worksheet function
Hi. How about creating a FILTERJSON function? It would make our life easier allowing us to get JSON data with less workarounds.
Oi. Que tal criarem uma função de planilha FILTROJSON? Tornaria a nossa vida mais fácil nos permitindo obter dados em formato JSON com menos soluções alternativas.
🇺🇸 English: FILTERXML > FILTERJSON
🇨🇿 Czech: FILTERXML > FILTERJSON
🇩🇰 Danish: FILTRERXML > FILTRERJSON
🇳🇱 Dutch: XML.FILTEREN > JSON.FILTEREN
🇫🇮 Finnish: SUODATA.XML > SUODATA.JSON
🇫🇷 French: FILTRE.XML > FILTRE.JSON
🇩🇪 German: XMLFILTERN > JSONFILTERN
🇬🇷 Greek: FILTERXML > FILTERJSON
🇭🇺 Hungarian: XMLSZŰRÉS > JSONSZŰRÉS
🇮🇹 Italian: FILTRO.XML > FILTRO.JSON
🇳🇴 Norwegian:…88 votes 
Add Translate Function
Add Translate Function as like as google sheet googletranslate function. it is very applicable if you add it in Mirosoft Excel. Thank you.
10 votes 
Change the Excel formula bar to the one from Power BI Desktop
Change the formula bar for advanced users as well as for beginners. better reading of functions makes work easier for everyone.
Indent the code, view the line (s) where there is an error, quickly see the syntax of a function and a bar that adapts depending on the length of the code that is entered.8 votes 
Outliers Function for Office 365 Excel Desktop App
I do not understand why Excel  Desktop or Web  does not have a function to identify and flag Outliers (statistical unusually high or low data values) in a column of data? Outliers in data skew any data analysis results whether we are talking about simple data visualization or more advanced regression and other modeling. For example, it could be a spreadsheet function where you enter "=Outlier" in a cell and then select range of data. Or, it could show up in the list of Excel Functions under the Formulas toolbar tab at the top of Excel. Or, it…
3 votes 
Add "Header" Argument to FILTER and UNIQUE Dynamic Array Functions
I'm proposing that header argument be added to the FILTER and UNIQUE Dynamic Array Functions just like we have seen in the STOCKHISTORY function
11 votes 
Add Corkscrew function for dynamic arrays
Corkscrew accounting is fundamental to Financial Modeling. It is where opening balances are carried over from closing balance of prior periods..
=OpeningBalance(FirstPeriodBalance, PriorBalances)
Where FirstPeriodBalance is the first period's opening balance and PriorBalances is an array of closing balances for each period.
The cell containing this function will return FirstPeriodBalance. The SPILL range will contain the n1 closing balance array value.
https://corporatefinanceinstitute.com/resources/excel/study/corkscrewcalculation/
20 votes 
Implement / expose object orientation
Would be great to be able to manipulate values returned by Excel formulas as objects with properties.
E.g. if I create select an array of cells (=A1:C20), I'd like to be able to manipulate that array as follows
=A1:C20().count counts the number of items in the array
=A1:C20().sort(index1,desc) sorts first index of array in descending order
=A1:C20().filter(index2,filterclause) filters array on index2 of array on filterclause
=A1:C20().filter(index2,filterclause)[:2] filters array on index2 of array on filterclause, and returns/slicereturns last two columns of array
=A1:C20()[1] returns/slicereturns first column of arrayAnd it would be even better to be able…
14 votes 
Inserting multiple rows or columns.
When I rightclick in a cell to insert a row or a column, have a dropdown box beside both the row or column add button allowing me to select how many rows or columns I want to add.
6 votes 
Vlookup column lookup bug
When adding new columns, there's a bug. vlookup formulas that depend on the columns surrounding the added new column don't automatically adjust. This has been a bug in ALL previous versions of excel.
i.e before the column is added here's a formula: vlookup( p10,$q$1:$v$100,5,false). Add a new column between r and s. You'll see that vlookup formulas throughout the entire spreadsheet do not realize that a column has been added (should now be vlookup(p10,$q$1:$v$100,6,false). You'll see that the column count should have been increased from 5 to 6, since the added column is in the middle of the data.
1 vote 
Make it to where you can use cell color as a reference point
I don't know of a way to use the cell color as a reference point in a formula, i.e. =IF(A2=Color X,(B2/C2),D2) I would like this capability.
12 votes 
Add a Split() function just like Google Sheets has. It is
=SPLIT(text, delimiter, splitbyeach, removeemptytext)
3 votes 
Create Array that joins two arrays
Create a function called ArrayJoin() or ArrayConcat(), this would join two or more arrays together to make one array. This could be used on spreadsheet directly or embedded in inputs of other functions eg to dynamically organise inputs for MMULT().
17 votes 
IFERROR function
IFERROR function returns 0 when there is an error. I would like to be able to provide value other than 0; for example, N/A, NO, or some other text string
1 vote
 Don't see your idea?