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.

implement data analysis in excel online
implement data analysis in excel online
6 votes 
Include a button to change the border color of the active cell
Include a button to change the border color of the active cell
22 votes 
How about some geodetic functions?
It would be nice to see some geodetic functions like great circle distance between two points, final lat/lon given a starting point/direction/distance etc. Vincenty's approach for direct and indirect solutions is pretty reasonable to implement.
3 votes 
HIGHLIGHTING ROWS IN FIND
When using the "FIND" function, allow users to highlight the whole selection/part of a selection matching a particular search criteria.
4 votes 
Numbers to Words
We desperately need an INBUILT and SIMPLE function wherein we can convert the amount mentioned in number into words.
(For Example Rs.25,000 to Rupees Twenty Five Thousand Only)
Many accounting software are capable to do so. So why excel being the most sophisticated calculator in the world can't add this simple function. Many accountants are dependent on your spreadsheet software. Please don't disappoint accountant community.3 votes 
Formula  "1^2"  First squared and then minus is correct.
When I input "1^2", the result is 1. Is it an error? First squared and then minus is correct. It should be different from "(1)^2". It should be the same as "01^2".
6 votes 
Adding back what was available in office 2003 & 2007. Great features missing. For excel Previous & next arrows when you add a link.Thanks
Adding back what was available in office 2003 & 2007. Great features missing. For excel Previous & next arrows when you add a link.Thanks
2 votes 
Allow to expand Evaluate Formula window
It's not possible increase the size of the formula evaluation window. This is a simple but very useful request to better understand the evaluation of large formulas and array formulas.
34 votes 
The function price
In the function "price", the yield argument is restricted to nonnegative numbers. This no longer makes sense, and have rendered the function useless and us as users in troubble since we now have negative yields on the market. Mathematically there should be no problem to allow a negative yield, so fixing the issue would be easy.
11 votes 
Add formulas for most common colors. SO =COLOR(E6) would return name of color for cell E6. Then we can write IF based on colors.
Add formulas for most common colors. SO =COLOR(E6) would return name of color for cell E6. Then we can write IF based on colors.
4 votes 
find and replace formulas with a volatile function like INDIRECT
When you use for example formulas with volatile functions like INDIRECT or OFFSET and you want to use less volatile functions to optimize your excel performance and you want to do find and replace actions then you can't make changes. Let me show it with an example:
SUMIFS(INDIRECT("Table1[volume]");INDIRECT("Table1[products]");A10)
you want to remove the INDIRECT in your formulas; so you want to find and replace first: 'INDIRECT("' with "nothing"
Secondly: '")' so you want to have a remainder that looks like:
SUMIFS(Table1[volume];Table1[products];A10)
But that doesn't work, because at the first find and replace action you already get a warning stating: "There's…3 votes 
LASTROW() returns the row number of the last row with data. LASTCOLUMN() returns the column header of the last column with data.
LASTROW(range[optional, whole sheet if not used]) returns the row number of the last row with data. LASTCOLUMN(range[optional, whole sheet if not used]) returns the column letter of the last column with data. Results can be used in ranges.
Select cell A1 and press <ctrl> + <shift> + <end>
=CONCATENATE(LASTCOLUMN(),LASTROW())
would return the cell reference of the of the bottom right cell that is selected
=LASTCOLUMN()
would return the column letter of the last column
=LASTROW()
would return the last row number8 votes 
Enable full feature functionality for a shared xls
Enable full feature functionality for a shared xls. When shared currently limits are placed on ability to copy or move tabs as well as chart and pivot table functions.
4 votes 
Support named arguments for optional parameters of custom functions
For functions with "many" parameters it would be great to be able to pass named arguments in the function calls within spreadsheet formulas, e.g.
=YesNo(B4, AcceptTF=true)
rather than
=YesNo(B4,,,,,,,true)
To be clear, this is about calling functions, including or especially userdefined functions, from SPREADSHEET formulas.
This request is NOT about addin functions calling other addin functions internally to the addin code.
2 votes 
OR function within the SUMIFS function
I would love to have OR function within the SUMIFS function so if it meet either of two (or more) criterias it will be true.
18 votes 
Create a historical record for cell value
Create a historical record for cell value on daily, weekly, monthly basis automatically without using VB.
5 votes 
Alternative Column and Row Range Names
Similar to creating a range name. Enable users to rename selected columns or rows to unique names.
E.g. Columns B thru M may be renamed Jan, Feb, Mar ... thru Dec to represent calendar months.Rows 2 thru 5 renames as "Sales", "CostOfSales", "GrossProfit" and "GrossProfitRatio" respectively.
The formula for Gross Profit in cell "B4" would currently be B2  B3 however with the renamed columns and rows the formula would be "JanSales"  "JanCostOfSales" .
The formula for Gross Profit Ratio in cell "B5" would currently be B4 / B2 however with the renamed columns and rows the formula…
3 votes 
Add a suite of nonparametric statistical formulas and tests
Add a suite of nonparametric statistical formulas and tests such as the Spearman rank correlation coefficient, nonparametric regressions, semiparametric regression, Tukey Duckworth test, Anderson Darling tests, Wald Wolfwits run test, Kendall’s tau, Kolmogrov Smirnov test, Kuiper’s test etc.
Likewise add the Durbin Watson runs test and other measures for the stability of timeseries.
4 votes 
Add "YYYYMMDD" to text that DateValue() can convert to a date
A lot of systems keep dates in YYYYMMDD format and when extracting text, it would be nice to wrap that in a DateValue() function to convert to date. Fortunately Date.FromText() in PowerQuery/M Language does this, but =DATEVALUE() should too.
15 votes 
Custom Sort Formula
It will be great and very powerful formula if excel has formula that return result similar to applying Custom Sort. I imagine the syntax to be something like this =CUSTOMSORT(RetunArray,Array1,SortKey,[Array2],SortKey,....)
Where
Return Array is the range user is looking to return the values from
 Array is range(s) with equal dimensions.
 Sort Key is Sort Order Ascending and DescendingOR another Idea is to return all range values again as formula output without specifying the return range.
5 votes
 Don't see your idea?