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.
Take a look at the feedback that we are currently working on and what feedback we have already completed.

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.
539 votesThank you all for your enthusiasm – I’m excited to say that we’re working on it!
I’m even more excited to say that you’ll be able to try it out soon, as a part of our work to make Excel better understand the data in your spreadsheets. Keep an eye on this page for updates, including instructions on how to try the feature before everyone else – we’ll be using your feedback to help shape our designs!
James Spotanski (Microsoft Excel)

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.
27 votes 
VBA abilty to refresh a Power Query Group (a.k.a. folder of queries) using a single script line
We need a VBA solution to allow a module/macro to refresh a Power Query Group by name. This solution would allow a single line of VBA code to refrence the Power Quer Group (folder) Name and refresh all queries within that folder.
It could be something as clean as:
ThisWorkbook.Connections.Group("My Folder of Queries").Refresh
20 votes 
Give cells 'alias' names
For example one cell is called volts, one cell amps and the result is simply 'volts*amps'. This would be useful for complex calculations (especially science/technology applications) where you have to remember what a cell value is. I usually label the cell next to the one that holds the values I am trying to work with  but there must be a more elegant way.
1 vote 
Formula language
Allow an option to change formulae language without reinstalling the whole excel. It's really based on how the user has learn the formulas, so it should be easier to change.
4 votes 
Simple Addition by Cell Selection
In Excel 2011, all we had to do was type the = sign and then select individual cells we wanted to add together and excel would automatically put the + sign in for you after each selection. Now, in 2016 version, if I type =, select a cell and then select another cell, the formula will change to JUST equal the second cell selected. If I want to add, I have to manually add the + sign in between each and every cell selection. Super frustrating.
1 vote 
5 votes

formula range limits
IIRC (I'm not in the middle of it right now, so I'm working from memory) there are still some formulas where instead of being limited by available memory, the calculation is limited to a number of cells (64K?). It's super hard to audit when working with such large data sets, unless Excel provides some type of warning. Ideally, all those limits would just be removed, but in the meantime it would be great if, when a user implements a formula with an inherent range limit, and applies it to a range that is larger (like a whole column) AND where…
2 votes 
More functions to work with array formulae
I'm using array functions quite a bit to avoid hidden helper columns these days, but the operations you can carry out are limited by the lack of ability to manipulate arrays in the "raw" state without reverting to VBA.
The ones I miss most are DROP (remove elements from an array), TAKE (select elements from an array), and REDUCTION (collapse an array across a row or column). I've taken the names here from the similar functions in APL, if anybody remembers those.
1 vote 
Set a range as "Absolute" values
I use a same range to enter minus() values and also plus(+) values to differentiate between negative and positive.
However i need to SUM this range as a whole (i.e. a credit/debit column) = this is difficult to do as sum function will +/ the values
If i can set that column or range as an "Absolute" range, then SUM and other functions can honour the abs() value if need be6 votes 
array function
I've seen many great ideas here for more intuitive ways to enter an array formula without cse, or by being able to type the curly brackets.
Mayber make a function called =arrayformula that won't require cse and won't need curly brackets, and you can't mess it up by accident1 vote 
Keyboard shortcut for autofill
One function I use very frequently is the "double click in lower right corner to autofill down". It is a great function that fills down formulas, number series etc. as far down as there are occupied cells in the column just next to it to the left. Could you please implement a keyboard shortcut for this function. As it is now you have to use the mouse to activate it, and you have to double click precisely in the corner. When you're trying to be quick and for example quickly paste and fill down the same formula in several worksheets…
1 vote 
Ability to reference the end of the column or row regardless of the starting position
I can enter A:A to reference the entire column or 1:1 for the whole row, but if I want to go from A2:A, I have to enter a number for the end of the range.
What if I don't know where it ends? Or where it may end someday? If I type A2:A10000 I'm safe only as long as my data doesn't exceed 9,999 rows, which is hard to determine. I want to reference the whole rest of the column regardless of how much it expands in the future.
And because of this, sometimes a reference like A:A in conditional…
40 votes 
Option to display/edit funciton names in localized form or in English.
Add an option, which would allow to display and edit function names in formulas either in localized form or in English.
This would simplify input of math formulas for those, who is used to use English names of those (like SUM, SIN etc.).
Besides it would simplify sharing of sheets with formulas between excel versions with different localizations.1 vote 
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…33 votes 
MINIFS
Minifs and Maxifs have made my job easier.
I would have liked to see a falling min / maxIFS, which orders the lowest number first, second lowest next etc.. that should be an opportunity to choose it if you want or if you only want to use the lowest.3 votes 
Need functions that changes the color (and color codes) in a formula of a cell or range of cells based on a condition
Be able to change color directly without using the conditional formatting n the excel ribbon....to write a formula directly in a cell that can change color of a cell or range based of a condition or set of conditions. the available conditional formatting is of limited practical use.
1 vote 
Subtotal with Conditiona Countif & Sumif option for visible cells
Hi All,
I am looking for default function in excel , where we can conditionally sum or count in Subtotal function. current Sum & count function is available in it but it not included and conditional sum or count.
currently I hope many people are using some array or complex formulas for this solution where they can see only visible cell sum/count.
Thank you all for vote for this idea.
4 votes 
Allow number of undos to be changed in Advanced Options instead of Registry
Please add to Advanced Options the functionality to increase the maximum number of undos in Office applications instead of having to update using Registry. If the theory is that too many people will increase to 1million perhaps add a limit to it in the options with a reminder that increasing this number may slow down the application generally as it requires an increased amount of RAM; then cap it at 500 or a realistic number (whatever that may be). I have mine set to 200 and haven't experienced any issues.
4 votes 
Sticky Formulas
Enter a Formula in a cell and the formula calculates until it is overwritten. When the overwrite is removed / cell cleared, the formula automatically returns.
e.g. =STICKYFORMULA(<default_value>,formula)
An indicator to show they are Sticky Formulas and a menu / context menu option to "Remove Sticky Formula" would be required on these cells.
And as an extension to this allow the formula to reference the value entered into the cell to be used as a variable in the formula.
e.g. =STICKYFORMULA(<cellvalue>, <default_value>, formula)
example
User enters: =STICKYFORMULA(10, default_value*100)
Cell displays: 1000
User then writes 50 into the cell.
The formula…1 vote
 Don't see your idea?