Feedback by UserVoice

# 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 in-app 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.

• Hot ideas
• Top ideas
• New ideas
• My feedback
1. ## implement data analysis in excel online

implement data analysis in excel online

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

2. ## Include a button to change the border color of the active cell

Include a button to change the border color of the active cell

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

3. ## 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.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

4. ## 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.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

5. ## 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.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

6. ## 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 "0-1^2".

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

7. ## 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

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

8. ## 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.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

9. ## The function price

In the function "price", the yield argument is restricted to non-negative 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.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

10. ## 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.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

11. ## 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…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

12. ## 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 number

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

13. ## 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.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

14. ## 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 user-defined functions, from SPREADSHEET formulas.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

15. ## 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.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

16. ## Create a historical record for cell value

Create a historical record for cell value on daily, weekly, monthly basis automatically without using VB.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

17. ## 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…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

18. ## 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.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

19. ## 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.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

20. ## 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 Descending

OR another Idea is to return all range values again as formula output without specifying the return range.