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.
744 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, SUMOR15 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…
13 votes 
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 
Something Wrong with Countifs?
I was just trying to analyse  now hot topic, the FIFA data, and used a
=COUNTIFS($B$4:$B$6,AC9,$F$4:$Z$6,AE$8)
here $B$4:$B$228  was the region of the individual member countries, (e.g. UEFA),
the AC column is the tabulation row$F$4:$Z$228 is the rank in the specific FIFA Finals (1..32)
AE8.... AL8 = 1,2,3,4,8, 16,32The formula gives Error i.e. $Value,
Though two subparts work perfectly OK i.e. COUNTIFS($B$4:$B$228,$AC10)
COUNTIFS($F$4:$Z$228,AE$8)
both return correct results...Is it because one is "String" equality check and other is "Numerical" Equality check?
2 votes 
Add functions to the Status Bar
Excel's "Customize Status Bar" now lacks text functions, eg. "Most frequent text" in a column, frequency/number of the "Most frequent text". Date and preferably custom functions / macros will be useful too.
2 votes 
Add options to enable/disable automatic calculations for sheets/workbooks
I really feel like I shouldn't need to use VBA everytime I want to prevent a single sheet from recalculating all the time. Adding this feature would improve the performance greatly.
3 votes 
it may be cool for the newer users to have subtraction formulas? multiply and divide as well. could improve a lot and save time
so we use autosum or sum for adding correct? well wouldn't it be cool to subtract and multiply and divide using formulas as well? newer users like myself that haven't been influenced by excel a whole lot have to figure out on my own how to subtract two different cells or a whole row of cells for that matter. typing out A2B2C2 etc... may seem tedious and pointless. it would be cool if we could just =sub a2:j2? thank you for your time.
1 vote 
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.
49 votes 
Allowing MultiSelect Functionality Through an Option List (Data Validation List)
As a Web developer and data management professional, my job relies on many functions that help me to get the work done faster. I was asked to create an excel sheet to import data faster into our website through a massive update. I got stuck at a task where one of the attributes had multiple options. I didn't know how to do so without having to create a list of all possible combinations which passed 40k possible combinations. I was losing my head until I searched online. I found a Macro Code that helped me select multiple options for a…
7 votes 
Have an option to allow using a VLOOKUP() to work if the lookupvalue is a number, but the table has numbers as Text
Have an option that allows using a VLOOKUP() to work if the lookupvalue is a number, but the table has numbers as Text and Vice Versa.
2 votes 
If function with criteria range
An expansion of the if function to accept a criteria range. The test is,"if criterion is a member of range, then..."
I can actually enter this into a spreadsheet without seeing an error, i.e., =if(criterion, $A$n:$A$nn, do if true..), but the results are unpredictable to me.3 votes 
Portugese Excel  Formulas with accents
Allow formulas to be inputed with or without accents.
Examples: =Média() >>> allow also =Media (without the accent)
Índice >>>> allow Indice
Não >>>> allow NaoAccents in the formulas are a pure nuissance and dont add anything other than extra work and mistakes. Allowing the command with and without the accent should be very easy and would allow Brazilian users to simply stop worrying about this detail.
Th
2 votes 
1 vote

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.
1 vote 
Eigenvalues and eigenvectors of a matrix
Add a function or functions to determine the eigenvalues and eigenvectors of a matrix
1 vote 
Enable Commenting of Formulas and Functions
Ability to add comments within a formula of function, eg:
=SUM(A1 <! Comment Here >, B1 <!Another comment here >, C1)
1 vote 
Add new Split formula
I want to add new formula called "split"
The formula will split cells or text upon a delimiter like "split" in vba
formula syntax:
=split(delimiter,cell or text)7 votes 
It is strongly recommended to add file labels, and add functions
1. It is strongly recommended to add file labels.
2. It is suggested that the function EVALUATE be added, to tconvert he macro function of EVALUATE into common function.
3. Add functions by color, such as sum, count, and so on.1 vote 
Extract words from two columns and extract numbers from two columns
A picture of my data is attached. What I need is a formula, preferably a non array formula, in column BZ to extract the Positive and Negative words from column BP first, then from column BT (the words from column BT should be in the first blank cell in column BZ below the words in column BZ that were extracted from column BP) and another formula in column CB to extract the numbers from column BR first, then from column BV. I can have words and numbers in from row 18 to row 417, and how many rows I have…
1 vote
 Don't see your idea?