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.

3 votes

Create NETWORKHOURS as a new function
I would like to see a function that calculates hours worked over a period of Excel Dates that incorporates working hours and nonworking hours as well as holidays and weekends parameters. This function could use similar logic to the NETWORDAYS.INTL function's use or holidays and weekends parameters.
26 votes 
#REF aid
When Excel changes an element of a {cell,name,chart,DV,CF,..} formula to #REF and stores it, it obscures what it was. This makes it between difficult and impossible to rectify. Please make this friendly. Like being able to click on the #REF! to see what it was, or something like a string #REF!&"\This is what it was"
Regards
Brian8 votes 
Adding the possibility of using English for functions/formulas as an option to showing translated functions
Using English name of functions in all languaje versions of excel
156 votes 
Array Formula  allow us to type the curly braces instead of CSE (and make them persistent when i edit formula!)
currently we have to use CtrlShiftEnter. What an odd concept. Please make array formulas easy to enter just like any other formula. Either let us type in the curly braces, or add something like ARRAYFORMULA(......). At least, PLEASE make the array formula persistent. Currently if I (or any other user) even looks at the formula, they can easily break it just by pressing enter.
8 votes 
Support for SQL statements
There are lots of times that I've had to create really complex formulae or macros just to replicate the equivalent of simple SQL statements (e.g. select * from range where xxx=yyy).
Would it be possible to include SQL statements as a new type of formula?7 votes 
Extended IF formula
I'd like to see the IF formula extended to 3 arguments: true, false, error.
So we don't need to use iferror, if(iserror(, etc. and input a formula twice.
The default result for the third argument 'error' should be "", but should be adjustable ad libitum.
This new If argument prevents the construction of any errorhandling in other formulae.17 votes 
Allow Tables to be referenced by name from another workbook
Currently you can reference an Excel table by name from an external workbook and the reference works while the workbook with the table is open. As soon as the table is closed, however, the formula returns an error on recalculation.
Allow tables to be referenced from external workbooks, similar to how named ranges are. Unfortunately setting a named range equal to a table as a workaround doesn't work.
11 votes 
vlookup for 2nd, 3rd, etc occurrance
How about something like =VLOOKUP(lookupvalue,tablearray,colindexnum,range_lookup,occurrance) like =VLOOKUP(123,A1:B100,2,FALSE,3) where the 3 means to return the 3rd occurrance of the lookup value. Of course, #N/A if there isn't one.
10 votes 
vlookup should treat the lookup value as it APPEARS
If you VLOOKUP (or HLOOKUP) 123 (or a range containing 123) into a range which clearly has 123 in it, but the latter is formatted as text, it doesn't find it. If it LOOKS right, it should find it!
3 votes 
ARRAYFORMULA
In addition to Ctrl+Shift+Enter (and remembering to do this after modifying an array formula) provide another way like the Google Sheets ARRAYFORMULA. This has advantages like seeing that it is an array without looking for curly brackets, and not having to CSE.
In fact you should definitely review all the functions of Google Sheets that are not available in MS Excel as candidates for inclusion. https://support.google.com/docs/table/25273?hl=en&rd=2
Regards
Brian17 votes 
Sequence function Numeric Run
Instead of futzing around with things like ROW(INDIRECT("1:"&Len(A1))) and Column and Transpose in order to construct certain array formulas which need runs like 1,2,3,4,...., provide a Seq array function.
Seq(from,to[,step][,Horiz/Vert]). Also make it imply an array function like does sumproduct.
REgards
BRian8 votes 
Extract groups of numbers or characters from Text
A frequently occurring problem is how to extract groups of digits or characters from text.
We need a new function something like this: Extract groups of characters from a textstring
 Allow the user to define what constitutes a group of characters
 Extract the Nth group from the start, or the Nth group working backwards from the end
 Option to specify the maximum number of characters to extract from the front or the back of the group
 Option to give the start and/or end position within the string for the search for groups.GROUPS(Text, GroupNumber, MaxChars,…
13 votes 
VLOOKUP with exact match and sorted data
VLOOKUP formulas where you want an exact match are often accused of being slow, especially when the lookup table has a large number of rows and columns. And if you have a lot of VLOOKUP formulas, changing a value in the lookup table can result in an annoying delay while all the VLOOKUP formulas using that table recalculate.
In many cases, the user would be willing to sort the lookup table by the first columnprovided that led to a significant improvement in recalc time because of a binary search. The problem is that setting the fourth VLOOKUP parameter to TRUE…
6 votes 
Allow date literals in functions
Many functions like VLOOKUP, SUMPRODUCT, and IF allow dates as inputs, but you need to know the tricks for doing so. The result is a neverending series of questions in help forums from newbies who just don't understand why their formula isn't working.
If you enter 1/15/2015 in a formula, it is treated as the small number resulting from two successive divisions instead of a date. If you enter Jan 15, 2015 in a formula, it results in an errorand if you encapsulate it in double quotes "Jan 15, 2015" if is treated as a text literal. My current workaround…
3 votes 
Shift+Click to select $A$1 and Click to select A1
When writing the formula:
=$A$1+A2
Traditionally we (can) click cell A1, type +, click cell A2, then go back and edit A1 to include the $ signs.
It would be super helpful if holding Shift while clicking automatically filled in the $A$1 when selecting cells.
19 votes 
Protect me from #REF! ambushes
Every so often I delete cells and unbeknownst to me create a bunch of #REF! errors in another part of my worksheet. I may not realize until much later when I can no longer undo back to fix the error. Excel could spare me this. If my deletion is about to create #REF!s it should bring up an alert like "Other cells depend on the cells you are about to delete. Would you like Excel to adjust their formulas to avoid #REF! errors? [Yes][No][Cancel]. [No] would do what it does today. [Cancel] would abort the operation. [Yes] would smartly substitute…
124 votesThanks to RH for posting this suggestion. If avoiding #REF! errors is important to you also, please add your vote to support RH’s suggestion. We will prioritize accordingly.
Thanks,
Steve (MS Excel) 
Add real multiline editing with autoindentation to the formula editor
Formulas today are increasingly complex especially since the character limit has been increased. It's common to see many nested functions that are difficult to read unless pasted into Notepad and separated by line breaks with logical indentation. Why not have the formula editor incorporate multiline display with automatic indentation like other code editors?
31 votes 
Add an IN() function to check for existence of a value
Right now, I often use formulas like this:
=IF(COUNTIF("A", myRange)>0, ..., ...)
It's be handy to be able to just use:
=IF(IN("A", myRange), ..., ...)
This could also help with formulas where a number of different criteria are allowed:
=SUMIFS(B:B, A:A, "2016") + SUMIFS(B:B, A:A, "2013") + SUMIFS(B:B, A:A, "2010")
becomes
=SUMIFS(B:B, A:A, IN(A2, "2016", "2013", "2010"))
3 votes 
GUI IF builder
Creating a GUI/ menu to build IF statements. It would have fields to enter your reference, condition type (e.g., =, <>), test value, value if true, value if false and ability to nest IF when true/ false.
Ideally you could select a cell with an IF statement and open the GUI and it will break apart all the nested IFs for you. Could be very helpful for people who aren't strong Excel users or for people troubleshooting complex nested IFs.
3 votes
 Don't see your idea?