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.

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.
916 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…

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 idea66 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 .
88 votes 
Add cell reference to Data Validation Messages (Input Message, Error Alert)
Please add the ability to use cell references or formulas in the Data Validation Messages (Input Message, Error Alert).
This would make possible to use variable contents.Thanks,
Fernando Fernandes24 votes 
Make the Evaluate Formula dialog box resizable
The evaluate formula box is unusable with large and/or CSE formulas. Please just make it resizeable. Thank you.
29 votes 
COUNT.DISTINCT Values
Proposal for a builtin function for: Count distinct/unique values in a range
There might be a dedicated function for counting distinct values in a specific range.
Currently the following function is a solution:
=SUMPRODUCT(1/COUNTIF([RANGE],[RANGE]))However beginnerlevel users would like probably a predefined parametric function, sg like this:
=COUNT.DISTINCT([RANGE])Thank you.
6 votes 
Allow column name to be used in vlookup
Allow the VLOOKUP formula to recognise a column label in place of the column count. This is a sorely lacking functionality when referencing large data sets that can easily extend to column counts of 50 or more.
Example: =VLOOKUP(A2,F:AM,AM,false) instead of =VLOOKUP(A2,F:AM,34,false)
5 votes 
Perform Calculations (Sum, Count, If, etc.) Based on Cell Color
Allow users to create formulas and that perform specified operations with data/values from only cells with a chosen background color, from a range of cells.
For example, in a range of 10 cells (A1:A10), only 3 cells have been colored yellow (either by the user or by a specified condition). A user can create a formula, such as =SUM or =COUNT or =AVERAGE, that will only use the cells colored yellow to determine the result. All other cells in the range, regardless of background color, will be excluded from the formula's result.
Alternatively, the same functionality can be achieved based…
7 votes 
From to infinity
I am reluctantly using Google Sheets for freelance work. There are a couple situations that have come up that make me wonder why Excel doesn't do it already. This is one of them.
In a formula, when I want to 'future proof' a template, I want to say B10 and the rest of column B, for example. In Excel, I can't do that. In Google Sheets, I can say 'B10:B' and anything starting from B10 and below will be factored into the formula. Any formula. Bliss. So simple and powerful and yet not advertised in Sheets and impossible in Excel.…
5 votes 
Live exchange rates in excel (compliment to the new stock features)
The new stock feature only displays stock prices in the currency on the exchange. The ability to convert between different currencies (ether in the stock feature or as a separate function) would be great and remove the need for many (including me) to copy paste exchange rates from the internet.
9 votes 
Name a dynamic array (rather than use "A1#" notation)
The new dynamic array notation is incredibly powerful, but one thing that makes formulas complicated is the "A1#" notation when used in formulas.
It would be great if you could (easily) assign a name to it in the same way that you can name an Excel table.
It would be much easier to see:
=SUMIFS(TABLE1[totals],TABLE1[dept],departments)
than
=SUMIFS(TABLE1[totals],TABLE1[dept],B1#)
I am able to define a named range for these values, but that is a bit clunky. It would be great if the naming was exactly the same as Table naming (e.g. in an ARRAY context menu like the TABLE context menu).
4 votes 
Should be able to add comments to formulas like you can in Power BI and Power Query
Need the ability to add comments to formulas like we can in Power BI and in the Power Query Advanced Editor.
6 votes 
be able to add hyperlinks to comments in excel
be able to add hyperlinks to comments in excel
4 votes 
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.
58 votes 
allow users to use =avg instead of having to type out the full =average
allow users to use =avg instead of having to type out the full =average. Having to type those four addition characters of has cost me decades of life. Why not? How hard would this be to code?
2 votes 
INDIA's Currency Symbol is missing
Please add the all countries symbols of currency in Microsoft Excel.
Specially INDIA's currency symbol because if i am not wrong number user is very high in india of your product and they definitely found lack of our symbol in excel when they need.3 votes 
SUMIF Function Support Array Input
The following array formula will not be accepted by Excel:
=SUMIF(ROW(INDIRECT("1:10")),"<5")I would like SUMIF to be able to accept an array as well as a range of cells.
1 vote 
Give the same full support for formulas as in cells  to noncell (not in cells) formulas: in names and conditional formats
Give the same full support for formulas as is in cells  to noncell (not in cells) formulas: for instance in names and in conditional formats.
3 votes 
Please make Vlookup work for greater than 254 characters. There are workarounds, but these are a bit complicated and slow processing down.
Vlookups have a character limit of 254 characters, and I would greatly appreciate it if this could be increased to say 500 characters if possible. In my job I do a lot of data validation from two different data sets derived from two separate systems (i.e., Work Day and PeopleSoft). In order to validate the data I frequently will need to create unique strings of data to utilize the Vlookup function. That being said, these strings of data can often extend past 254 characters. While there are workarounds using Index and Match, this can be a bit cumbersome and time…
2 votes 
Improvements to formula viewing
Currently alt+tab can be used to segregate sections of a formula onto new lines. This could be enhanced by including an option to display values at the end of each line. This could make the interrogation of large formulas far easier.
3 votes
 Don't see your idea?