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.

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 .
39 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 Fernandes12 votes 
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.
810 votesProgress! As of this morning, we’ve begun enabling the first iteration of Excel’s new data types for a percentage of Office Insiders, including the ability to pull and refresh live stock quotes (and other financial data) straight in to Excel! We’ll be increasing the percentage of Insiders with access to the feature over the coming days and weeks, so if you don’t see it right away please hang in there!*
We acknowledge that right now this is only half of the suggestion (pull current stock prices), but historical data is in our sights and we’re planning to add this and many other improvements to stock and financial data. Your feedback thus far has been immensely valuable in helping us plan and design this work, and we look forward to your continued suggestions for how we can improve to better meet your needs
Again, we genuinely appreciate your involvement as we…

COUNTIFS / SUMIFS with OR  COUNTOR, SUMOR
Countifs or Sumifs function use all criteria as AND. Instead 2 more formula can be added such that all criteria are treated as OR. Suggested Names of Formula are
COUNTOR, SUMOR25 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.
10 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.
5 votes 
Text Interpreter Function without Evaluate()
I would like to harness the ability to evaluate a text formula expression in a range or table. I was wondering if anyone else has thought about this before. It seems that FORMULATEXT() or INDIRECT() could be used for this purpose but alas..... it seems they cannot. Basically, the scenario I would find it most useful would be the ability to set up a formula lookup table and essentially do a vlookup to get the correct formula to use for a particular variable. This would eliminate the need to inject custom VBA functions or use EVALUATE(). This type of functionality…
16 votes 
replace Count by CountA
replace Count by CountA
In the home ribbon, change the quick function (sum, average, count...).
I think that we need COUNTA more than COUNT.5 votes 
2 votes

A =CORRELIF(S) Formula
It would be the =CORREL formula with added IF criteria, such as SUMIF, to allow for easier correlation between specific categories in one data set.
2 votes 
Formulas that directly format
Too bad we don't have formulas that directly format. For example, one might then have a formula like =IF(A1=2,AND("That's a winner!",FILL(A1,[Red]),TEXTCOLOR(A1,[Yellow])),AND("Oh... Sorry!",FILL(A1,[Light Blue]),TEXTCOLOR(A1,[Red]))) .
No more screwing with a horrible, nonintuitive, one might even say "broken" given its foibles, conditional formatting. Except legacy work, of course.
3 votes 
Save User Defined Nested Formulas in the Formula Tab
I have numerous nested formulas that I create from time to time. I would like to see a section in the Formulas Tab where user defined nested formulas, with their defined name, can be selected from a drop down list.
2 votes 
When Excel is used as a "Form"
Sometimes Excel is used as a "Form" where users can fill in data. Sometimes the data that they fill in has associated logic, the "IF" function.
They can enter anything in the cells including "spaces" and "clear contents". But the required logic is that these things be ignored.
The only way around this so far is to create a "mirror ghost sheet" that translates this scenario to ABSOLUTE VALUES.eg. =IF(OR($A$1<>"",$A$1<>" ",$A$1<>" ",$A$1<>" "),0,1)
The cell is Visually Blank. Can we forget the Boolean purist thing and treat this a One Logical Condition, and have an operator such as VBLANK…
2 votes 
Create a function that will easily convert US dates (mm/dd/yy) to UK dates (dd/mm/yy) and visa versa
As above  e.g. =Dateconvert (US, UK) or =Dateconvert (UK, US)
1 vote 
Create a function that will easily convert US dates (mm/dd/yy) to UK dates (dd/mm/yy) and visa versa
As above  e.g. =Dateconvert (US, UK) or =Dateconvert (UK, US)
1 vote 
Make/force formulas to work
Here's my formula: =B66+C66
That should be super easy. I filled in down to have a running total. I see no reason for it to not work. This is not some super spreadsheet. It's just a worksheet, like scratch paper. Does Excel need to have pretty borders and headers to make it work?
There are other numbers around, but I'm not getting the chance to say click "Ignore Error"
I really don't like when Excel tells me something has an error when it doesn't. Ask if it's an error. Let me say ignore if forever or at least in all…2 votes 
Change how Calculation Options work across multiple workbooks
Currently, the Calculation Options in Excel seem to have some odd behaviour:
Principally, the setting is specific to the workbook, but I set up 2 books as a test:
Book1  Manual calculation
Book 2  Automatic calculationWhen I ONLY open one of the books, the calculation setting is correct to what I had set on it. However, if I open the other workbook when the first one is still open, the setting pulls across to the second book.
So:
If I open Book2 (automatic) first, then open Book1 (manual), Book1's calculation setting becomes "Automatic"
If I open Book1…1 vote 
Please modify the Name Manager
Please modify the Name Manager such that when the name given to a cell is deleted, formulas in other cells that were based on that name are updated based on the actual cell address rather than keeping the formulas with references to the deleted name.
1 vote 
Nova função que utilize a equação escrita em uma célula e automaticamente substitua os valores de uma linha em sua variável independente e r
Suponha que você escreva uma função na célula A1
Exemplo: Você escreve em A1 a função: x^3+LN(x)No lugar da variável independente x você deseja substituir valores que se encontram em uma determinada linha (exemplo: os dados que se encontram na linha entre as células B2 a B10) para que retorne solução da função (exemplo: retorne a solução na linha entre as células C2 a C10).
Atualmente, poderíamos resolver esse problema digitando em cada célula na coluna C de C2 a C10 a função desejada. Exemplo escrever na célula C2 a função: =B2^2+LN(B2); na célula C3 a função: =B3^2+LN(B3); ...e…
1 vote 
Documentation Defect in SUMIF(): contradictorily defines use of sum_range
A "documentation defect" has been reported to Microsoft which Microsoft has flatout denied I suggest Microsoft correct the documentation defect below. Anyone else agree?
In the main documentation Microsoft states:
"• sum_range Optional. The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied)."
There is no indication that the cells added might differ. The statements are absolute.Down in the Footnotes and Remarks Microsoft clarifies…
1 vote
 Don't see your idea?