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.

Formula: (A1*B1)(A1*C1)(A1*D1)(A1*E1)...(A1*AP1)
I need to do a formula like below: (A1B1)(A1C1)(A1D1)(A1E1)...(A1*AP1) Is there anyway I can fill this faster, because it takes a lot of time to fill manually.
A formula to do this should be very nice and time saving.
1 vote 
Shortcut key to access the specific filtered fields in the worksheet that can save a lot of time instead of reaching the fields manually
You can provide the shortcut key to access the specific filtered fields in the worksheet that can save a lot of time instead of reaching the fields manually.
1 vote 
Pull Stock Historical Data Into Excel
When will Microsoft put historic stock prices? In this link created more than 3 years ago Microsoft informs that it is under development. For over 3 years? It is very unwilling to help customers. Apple's Numbers and Google Sheets already have this function. Google and Apple listen to their customers. Microsoft does not.
Quando o Microsoft irá colocar os preços históricos das ações? Neste link criado há mais de 3 anos a Microsoft informa que está em desenvolvimento. Há mais de 3 anos? É muita má vontade em ajudar os clientes. O Numbers da Apple e…
2 votes 
Native DAX and Mashup functions in Excel worksheets
Now with the dynamic array philosophy, even if the results are spilled or not, a cell may act like holding tabular data in it (which we can refer by #). So why not have Native DAX and Mashup functions directly as worksheet functions and play with tables contained in worksheet cells?
3 votes 
Allow user to consider problematic cells in their formulas
For instance, if I am trying to do an average of a sequence of numbers (a list of them or a range) and there is a cell that has an error, excel doesn't let me use those cells in their formulas.
Supose I have this sequence of Numbers
A B C D
1 3 4 7 average(A1:C1) > returns 4.6
2 3 4/0 7 average(A2:C2) > it will return an error
3 3 div/0 7 average(A3:C3) > will also give an error.
Sometimes in a database an user lets the whole table referenced and he knows certain rows or collumns…
1 vote 
Evaluate Formulas based on spilled array need to show evaluation for each row (not just formula row)
If you enter a dynamic array formula in cell A1 (which spills the results) and then you write a formula in cell B1 that is based on A1# that results set will also spill.
However the evaluate formula function will never evaluate for any row in the spilled array in column B except B1. Put another way if you go to cell B2 and click Evaluate Formula and step through it the formula that is evaluated is the formula in cell B1. This makes it impossible to debug formulas based on spilled arrays.
I really think this is a bug…
6 votes 
SEARCH functions to return 0 (instead of #VALUE!) if the text is not found
All Find & Search functions should return the 0 (null) code if the "Findtext" does not get found in "Withintext" instead of the current #VALUE! error. That would much simplify usage of SEARCH function together with IF function.
1 vote 
sub catogories in excel (Money)
Unable to create the subcategories under Category in Money in excel application.
1 vote 
fd
I wanted to change my characters of "Row N" into numbers in "Row O" by using VLOOKUP formula. I wrote a table array and keyed in my formula in "Block O2", and then I wanted to pull down to fulfill all my "Row O" with the same formula. However, the "tablearray" in those formula should not have been changed!!!! The "lookupvalue" should be the only value changed among all my formula in "Row O"
1 vote 
LET function should better return #NAME? whenever undefined variable was used inside the formula
If you write the formula
=LET(
target,A1,
list,B1:B5,
IFERROR(VLOOKUP(targt,list,1,FALSE),"not found"))The current insider version of the Excel in my computer outputs "not found" even if the value in the A1 actually exists in the range B1:B5.
This is because of the typo "targt".I would like Excel to warn me that I made a typo.
One idea is to make whole formula return #NAME?, whenever the undefined name is used somewhere inside the formula.
Another idea is to highlight the undefined names when editing the formula.This issue is not only about the LET function, but the LET function make…
1 vote 
1 vote

COUNT helper line should be Number1, Number2... not Value1, Value2...
Count only counts numbers... it is essentially the exact same function as SUM, AVERAGE, MAX, and MIN.. it even shows up on the Autosum dropdown... yet it is the only one with a different helper line.
I suspect the person who made COUNTA took a shortcut, but it sets people up to fail1 vote 
#CIRC! instead of 0 for Circular reference errors
Every error shows up clearly on screen except for Circular References...
0 as the display choice is not at all useful as sheets commonly have 0's.
Errors should be easier to spot
CIRC or something similar would resolve that1 vote 
This is for all Excel versions. What if you could use blockbased programming instead of writing unreadable oneliners?
This is for all Excel versions. What if you could use blockbased programming instead of writing unreadable oneliners?
Consider, for example, the programming learning tool Scratch, released by MIT. If you built a tool akin to this, Excel's formula features would be significantly improved in accessibility and interpretability for the average knowledgeable user as well as for those who find formulas difficult to understand or write today. To prevent an increase in Excel file size, this feature should be program side only, Excel would create a formula editor, the editor would output the oneliner, and interpret existing oneliners as visual…
4 votes 
=SUMIF(Trend!$A:$A,$A4,Trend!$F:$F)+SUMIF(Trend!$A:$A,$A4,Trend!$G:$G)+SUMIF(Trend!$A:$A,$A4,Trend!$H:$H)+SUMIF(Trend!$A:$A,$A4,Trend!$I:$I)
=SUMIF(Trend!$A:$A,$A4,Trend!$F:$F)+SUMIF(Trend!$A:$A,$A4,Trend!$G:$G)+SUMIF(Trend!$A:$A,$A4,Trend!$H:$H)+SUMIF(Trend!$A:$A,$A4,Trend!$I:$I)
any simple formular for this adding?1 vote 
vlookup based on multi column match
VLOOKUP with categories e.g. match column 1, then match on 2nd (or further) column(s).
I use the following logic
If x = cell(row,a) and y = cell(row,b) then
'got a match
end if1 vote 
Include Levenshtein Distance as a bakedin formula
The Levenshtein Distance Formula is great for duplicate detection. I've tried using the PowerQuery "Fuzzy Match" algorithm, but this assumes there's a known clean list of values, and I often don't have that.
I'm working to standardize data and need the ability to normalize/relate data to itself.
1 vote 
Use a keyboard modifier to add a cell as absolute reference when entering a formula
When entering a formula by clicking cells, it enters their relative (A1) reference. It would be nice if we could, by holding a modifier (e.g. Alt), make it enter their absolute ($A$1) reference when we click the cell.
1 vote 
Can you add change case into the excel like in the word. To make all the letters capital or small without formula. Thanks.
Can you add change case into the excel like in the word. To make all the letters capital or small without formula. Thanks.
1 vote 
Allow trendline equaitons to be copied from a graph
Allow trendline equaitons to be copied from a graph
2 votes
 Don't see your idea?