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.

1,147 votes
Hi all,
We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey
Thanks!
Blake, Excel Product Team 
Pull Current Stock Prices and Historical Data Into Excel
Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.
It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.
1,013 votesHi everyone,
Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/enus/article/getastockquotee5af3212e0244d4cbea0623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.
We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

Make a simple safer version of VLOOKUP and INDEX MATCH
The majority of Excel users use VLOOKUP to get exact matches from a row or column, It would be good if they all used INDEX MATCH but it's more complex so how about this simpler version for the masses.
=GETMATCH(ReferenceToMatch, MatchColumn/Row, GetColumn/Row, Optional Value if no match)
If seen a few other references to updating VLOOKUPS and there are lots of opportunities, but it would be good to address the simple most widely used issue first.
730 votesThanks for the suggestion Wyn! Thanks also to all the contributors to this thread for the thoughtful discussion and debate.
Of the many lookup function requests, this is currently one of the highest ranking on UserVoice. Please keep the votes rolling in if you’d like to see this, it helps us prioritize new feature work.
JoeMcD [MS XL]

Give us a proper NULL() worksheet function.
This would make calculations and charts treat a cell containing a formula as a blank cell, not as a cell with a text string ("") or as a zero.
637 votesGreat suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.
Thanks,
John [MS XL] 
Builtin RegEx / Regular Expressions Functions to Search, Extract, and Replace
I've constantly found myself installing and reinstalling addins that add RegEx Functions to Excel. Everyone I introduce them too finds them extremely useful. There's over half a million results in google for the query ["excel" ("regular expression" OR "regex")].
403 votesThanks for the suggestion! We’re fans of Regex and its ability to parse text too.
If you’d like to see Regex support in Excel, please keep the votes rolling in.
 JoeMcD [MS XL]

VLOOKUP function for multiple criteria
There should be a *VLOOKUPS function (or you name it) alongside VLOOKUP to find data based on multiple criteria. I know there are workarounds like INDEX and MATCH but they are unnecessarily complicated considering COUNTIFS and SUMIFS functions do a neat job at counting and adding multiple criteria. And please make it so it works with unsorted data.
342 votesThanks for the feedback! We’re seeing a number of different posts about lookup functions – we’ll be taking a close look at this area and thinking it through. We’ll prioritize the asks according to votes along with other requests on the site. So I encourage people to keep voting if it’s something they really want to see the priority raised on.
Best,
John [MS XL] 
Workbook level calculation
We need the ability to calculate a single workbook when multiple workbooks are open.
When working with multiple large slow workbooks which are often not even linked together (think multiple versions of the same workbook or a large mostly static workbook being referenced by a smaller rapidly changing workbook) you want to make changes and recalculate without globally recalculating all open workbooks.
This should be implemented as
a) New calculation setting (persistent)  Calculate Active Workbook Only  works for Automatic and Manual F9, but Ctrl/Alt/F9 would full calculate all open workbooks regardless of the setting.
Automatic Calc in Active…182 votesThanks for the post Charles, and for the in person conversation at the latest MVP conference. We definitely understand the ask and will keep our eye on it – it looks like it’s moving up the vote charts pretty quickly. As always, keep upvoting the things you are about most.
Best,
John [MS XL] 
Two new =if's
Just like =IFERROR(), could we also get =IFBLANK() and =IFZERO(). I would use these on a regular basis, and it would cut in half the size of large formulas where I just want something specific to happen where the result is either blank or zero
176 votesThanks for the suggestion figboot. As always, we’ll prioritize this according to the number of votes it gets, so please be sure to vote it up if you want to see it done sooner.
Thanks
John [MS XL] 
NULL Worksheet Function
This request is to add a new function, =NULL(), which returns "blank" or null, forcing the cell to act as if it truly is empty; not a cell with an empty text string "" or 0.
146 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.
133 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] 
Create a function that returns the list of sheet name(s) in the workbook = SHEETNAME(), =SHEETNAMES()
1. provide a function that returns the current sheet name
2. provide a function that does the listing of the sheets in the workbook. This is presently being done using macro. there are certain companies which do not permit the running of macros within the excel workbook.
108 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
103 votes 
Add a CountDistinct (unique, etc.) function
Add it as a standalone function
95 votes 
Universal IF statement  to meet needs of IFNULL, IFBLANK, IFZERO etc.
Are you tired of duplicating complicated formulas within an IF statement in order manage blanks or zeros?
e.g. IF(long formula="","",long formula)
A universal IF statement (lets call it IFX) would decrease this type of duplication without having to add multiple new IF formulas the likes of IFNULL, IFBLANK or IFZERO.
An IFX function would accept the condition you want to test the formula against, if the condition is true it would return the specified alternative (such as blank). If the condition is false it would return the value of the formula itself. Ideally it would be able to accept multiple…
92 votes 
Directions from 0 to 2pi 1)atan(x,y) 2)atan(E,N) and from pi to +pi 3)atan2(x,y)
1)atan(x,y)=pipi/2*(1+sgn(x))*(1sgn(y^2))pi/4*(2+sgn(x))*sgn(y)
sign(x*y)*atan((abs(x)abs(y))/(abs(x)+abs(y))) when x=x2x1 ,y=y2y1
2)atan(E,N)=pipi/2*(1+sgn(N))*(1sgn(E^2))pi/4*(2+sgn(N))*sgn(E)
sgn(N*E)*atan((abs(N)abs(E))/(abs(N)+abs(E))) when N=N2N1 ,E=E2E1
3)atan2(x,y)=pi/2*(1sgn(x))*(1sgn(y^2))+pi/4*(2sgn(x))*sgn(y)
sgn(x*y)*atan((abs(x)abs(y))/(abs(x)+abs(y))) when x=x2x1 ,y=y2y1
The above fuctions give the directions in the 4 quadrans for all the pairs of dx and dy.
For dx=dy=0 the result is indefinite .
87 votes 
Function and formulas recommended
Mohammed A Elrify
Mohammed A Elrify Occasional Contributor4m ago
Suggested to Microsoft EXCEL
By creating the advantage of the proposed Function and formulas recommended
Such as recommended pivot tables and recommended chartsFor example, the work of options for the user
For example if he wanted to compile on terms, he would have the formula SUMIFS ready and only a choice
Also like the search that VLOOKUP uses
And so on
I hope the Microsoft community will support and encourage this idea74 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().
72 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] 
Formular Editor
Large formulas become very confusing. It would be nice if there is a formula editor that inserts, coloring and evaluates the formulas like Visual Studio and that can also be provided with comments and other hints. These formulas must then be displayed in the editor in exactly the same way.
67 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.
62 votes 
Advanced formula manager
Excel has gone a long way of development and continues to acquire new functionality. However, the original concept of a tool for tabular calculations with formulas does not develop. The mechanism for entering and checking formulas is obsolete.
Prerequisites for a new tool:
1) The builtin mechanism for entering formulas does not allow you to immediately check the calculation stages for correctness and check the logic. You must first enter the formula, and then look through the stepbystep calculations. If you need corrections, you have to go back to the formula editing field.
2) When you enter a nested formula…60 votes
 Don't see your idea?