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.

Change external file links with the INDIRECT() function without having the file open
Currently the INDIRECT formula is limited in that we cannot use it to link to other files that are not currently open. If I have multiple files that are named the same except for a unique identifier (AA forecast model, BB forecast model, CC forecast model...) I should be able to use INDIRECT to change the file links.
Example of what should exist:
Assumption is the Cell A1 = "AA"
="L:\Drivename.drive"&INDIRECT(A1)&"forecast model.xlsm"
27 votes 
Use F4 key to lock reference in a table
When you create formula with the named range of a table, you can't easily block the reference of your column.
For instance, if you used the fillhandle to copy to the right, the reference of your column will change :( The only way to avoid that is to write [[column1]:[column1]] for all your reference (very annoying)
So my suggestion to block the reference of a named range is to use the F4 key.
Your formula is =SUM(table1[column1]) and after pressing F4 it becomes =SUM(table1[[column1]:[column1]])166 votesGood suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.
Best,
John [MS XL] 
Need a "DELETE" function to work in a formula to automatically delete rows when a certain value exists in a cell
I have seen, over the years, NONautomatic methods for this.
I am asking if MS will please develop a new FUNCTION called 'DELETE ROW' that can and will AUTOMATICALLY delete a certain range of rows, if another cell contains a particular value or character.
Everything I have seen that seems to suggest this functionality won't do it.
And myself and about 98% of MS Excel Users no nothing about VBA (if that's the internal complex programmer's language). I am looking for an honest to goodness automatic Delete Row FUNCTION that will delete rows specified in a formula by itself, if…
6 votes 
Auto resizing of formula bar
Give us an easily accessible option to have the formula bar resize automatically if a formula spans across multiple rows in the formula bar so the whole formula will be visible.
244 votesThanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.
Cheers,
John [MS XL] 
Support inline variables in formulas (similar to PowerPivot)
As shown here:
http://www.powerpivotblog.nl/daxnowhasvariablesupport/In PowerPivot you can write inline variables like so:
Future value variable =
var Ratescalc = Productx(Rates,1+[Rates])
var Revenue = [Sum of SalesAmount]
return if (Revenue, Revenue * Ratescalc )The same ability in Excel would make the writing of an entire class of formulas much easier, such as the specific one mentioned here:
=IF([Formula]>5,5,[Formula])
22 votes 
Add a funciton to search in a string from the end (INSTRREV)
Please add a formula that works like INSTRREV in VBA.
(20160308 Dan [MS]  updated title to include INSTRREV, when merging in duplicate idea)
9 votes 
Show intermediate values in formulas for troubleshooting.
Show intermediate values in formulas. Add the ability to highlight a portion of a formula to see a tooltip showing the value... for example a value of 7 in A3 and a formula elsewhere with if(A3+4/2,"yes","no") highlighting the "A3+4/2" would show a tooltip of 9. Obviously a simple example, but it would help avoid disassembling complex formulas to troubleshoot.
12 votes 
Make all textrelated functions work in textboxes
Spellchecking, find and replace, and autocorrect all appear to be disabled in textboxes. Please make them work for all textboxes, including those inside other objects.
Also, the line spacing function under the "Paragraph" dropdown command for textboxes should work in ordinary cells.
4 votes 
Root Mean Square Error (RMSE)
Please add RMSE formula to statistical function library.
3 votes 
Add an IFCOND() function
similar to IFERROR, add a function that only evaluates second argument if first argument not met, like
=IFCOND([Formula],">5",5)
instead of
=IF([Formula]>5,5,[Formula])
This would make a lot of formulas much shorter and also improve execution time, as it would only have to evaluate [Function] once instead of twice if the condition is not met.
64 votes 
Integrate units into cells for display and mathematical operations
Allow numbers to be displayed with text (without using the concatenate), while also being able still use the numbers/text for equations. Then units can be displayed (e.g.20 mm) and referenced to be operated on via another cell (e.g. 20mm*2+5 = 205mm)
Keep reading if want more Details/explanation
Minimum way to implement would be to provide function to ignore all text for calculations (deconcatenate?) but then add it back in at the end (reconcatenate)...all in one function. This would be the quick and dirty method to get the low hanging fruit.Super slick way to implement would be to go a…
9 votes 
Prominent Manual Calculation Mode warning
Given the great danger of not realising that calculation mode is set to Manual, it would be very beneficial if a "Manual Calculation Mode" indicator (in bright fireengine red!) was displayed (and visibility maintained until calc mode is switched back to nonmanual) in a prominent location  such as in the Title Bar to the left of the Minimize button.
38 votesThanks for the suggestion Col. There’s a lot to do, and we’ll take a look at getting this into the plans according to the number of votes – vote on!
Thanks,
John [MS XL] 
Date/time stamp with auto update
A means by which entering/changing data in a range would update a date/time stamp. It could be a simple function like TimeStamp(range). This would be hugely beneficial when for example working with a group of coworkers on a data table in a shared spreadsheet, allowing the team to immediately see what has been updated without forcing team members to manually enter a date/time for each edit.
7 votes 
worksheet function for returning a field inside a delimited lists
I’d like to have a function available that returns a specified field within a delimited list. I would pass the list, a delimiter and a field number as arguments to the function and it should return the value in that field.
For instance with the pipe separated list ”TEST1TEST2TEST3TEST4 TEST5TEST” in A1.
I’d like to use something like GetFieldInDelimitedList(A1;"";5) and have it return “TEST5”.Any equivalent formula will requires quite a lot of nested functions e.g.:
=MID(A1,FIND("([])",SUBSTITUTE(A1,"","([])",4))+1,FIND("([])",SUBSTITUTE(A1,"","([])",5))(FIND("([])",SUBSTITUTE(A1,"","([])",4))+1))13 votes 
Please a button to show all external file references
Sometimes it is really hard to find out why Excel whinges about external file references. Would be nice to have a button to show where exactly each reference occurs.
28 votes 
string function which returns the number of occurences of a substring
I regularly have comma separated lists, and would like to know how many values there are in the string. Currently do that in VBA, but it would be nice if there was a function for that. E.g.:
A1 = "abc, def, pqr, xyz"
B1 = PARAMS(A1,[optionally]",") optionally so that you can do ; or others as well5 votes 
Numbers to text function
We need a native Excel function, that read a number in a cell and then convert it in text.
10 votes 
To create a new function to Convert figures into letters
A new function in order to convert a figure for ex. 2 into two, and more difficult as 1.350, 1.698.367 etc.
2 votes 
Extend VLOOKUP() and HLOOKUP()
Extend the lookup functions so they can lookup left/up as well as right/down. That will save us having to build and maintain unintuitive formulae combining INDEX() and MATCH().
79 votesThanks for taking the time to post a suggestion Malcolm! We’ll be taking a look at lookup functions. There’s a number of votes on the site for them – I’m not going to merge all of them though because different posts are asking for slightly different things. Please keep voting for the ones you want to see most!
Cheers,
John [MS XL] 
Create a function ISDATE(Data)
Please, create a function ISDATE() to test if the contain of a cell is a date or not. This function exist in VBA but not in the Excel function. That's weird
12 votes
 Don't see your idea?