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. ## Date PIcker in Excel for Windows

Date Picker

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

2. ## Enter hyphen instead of zero in blank cell

Select File, Options, Advanced and you have a default choice to leave a cell which has a formula but no data to show either a blank cell or a zero. I suggest another choice should be allowed as a default. A hyphen,
That way you would know there is a formula in the cell and not to place data in the cell over writing the formula.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

3. ## you should make it so you cube and square cells

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

4. ## I think that arrays should be able to pass in expressions

In Excel there has been a bunch of Array work done. I think we should be able to pass expressions into an array...

Something like this:
={sum(1,2,3),count(1,2,3),average(1,2,3)}

so that I can dynamically generate a spill out list of expressions or perform a "lookup" function to dynamically select an expression to run within a cell by array position

=lookup(2,{sum(1,2,3),count(1,2,3),average(1,2,3)})
this expression would evaluate like this:

=lookup(2,{6,count(1,2,3),average(1,2,3)})
=lookup(2,{6,3,average(1,2,3)})
=lookup(2,{6,3,2})
=3

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

5. ## I think that arrays should be able to pass in expressions

In Excel there has been a bunch of Array work done. I think we should be able to pass expressions into an array...

Something like this:
={sum(1,2,3),count(1,2,3),average(1,2,3)}

so that I can dynamically generate a spill out list of expressions or perform a "lookup" function to dynamically select an expression to run within a cell by array position

=lookup(2,{sum(1,2,3),count(1,2,3),average(1,2,3)})
this expression would evaluate like this:

=lookup(2,{6,count(1,2,3),average(1,2,3)})
=lookup(2,{6,3,average(1,2,3)})
=lookup(2,{6,3,2})
=3

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

6. ## excell производит рассчеты с ошибками

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

7. ## Disabling macros embedded in a totally different Excel file, since it prevents, for example, cut-and-paste functionality

Monday, 21-Sep-2020

1. While working on a different file []File-A], keeping a macro-enabled workbook [File-B] open, the macros in that workbook [File-B] prevent me from using cut-and-paste functionality in File-A. File-B has the built-in, embedded macro function of preventing cut-and-paste [inside File-B].

2. This is quite annoying, because all that happens is that File-B is just OPEN, but the error message says, "you can't use cut-and-paste function" here in File-A.

3. How can an open File-B prevent me from using this function in File-A ?

4. Does File-B have a built-in formula or macro that disables the entire Excel Program's function ?

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

8. ## Formula Tab Indentation

Can you please allow tab indentation of formulas?

It would be even nicer if Excel did it automatically.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

9. ## Terms used in the Descriptive analysis output

The descriptive statistics function (Analysis Toolpak) returns the Margin of error based on a selected confidence level. However, the output table presents it as "Confidence level" - that is not what the value is - the value returned is the Margin of Error. This is just wrong terminology and an easy fix. Please make it right.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

10. ## BUG: VLOOKUP Confused by Commas in Sheet Names

VLOOKUP treats commas in sheet names as argument separators (attachments 1-3).

To troubleshoot, I replaced the single quotes delimiting the sheet's name with double quotes. At first sight, the double quotes do away with the confusion (attachment 4), but they are not accepted when attempting to enter the formula (attachment 5).

This seems to be a bug, but I couldn't find a way to report bugs for Excel. The feedback buttons in my Excel are greyed out.

EDIT: The comma used to reference a column in a table (VLOOKUP(A1,Table[[#All],[Column]],1,FALSE)) seems to not confuse VLOOKUP at all.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

11. ## Outliers Function for Office 365 Excel Desktop App

I do not understand why Excel - Desktop or Web - does not have a function to identify and flag Outliers (statistical unusually high or low data values) in a column of data? Outliers in data skew any data analysis results whether we are talking about simple data visualization or more advanced regression and other modeling. For example, it could be a spreadsheet function where you enter "=Outlier" in a cell and then select range of data. Or, it could show up in the list of Excel Functions under the Formulas toolbar tab at the top of Excel. Or, it…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

12. ## Slow in responce 2019 and excel 365

In Data Validation i have apply the Custom Data Validation with multiple criteria . few criteria belong to same worksheet and few of them from other worksheet with few calculation. That Data Validation work properly in Excel 2013.
But when ever i tested over the Excel 2019 or Excel 365 that work afer entring wrong value in next cells.If i put the value in cell and save then Data Validation work properly in 2019 and 365.

please guide me how can i Handeled this problem.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

13. ## An MROUNDUP and MROUNDDOWN feature

MROUND rounds to the nearest specified multiple.
ROUNDUP and ROUNDDOWN allows to choose whether you round to the nearest decimal place or to the higher or lower number.
It would be great to combine these with an MROUNDUP or MROUNDDOWN feature.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

14. ## STOP FUCKINGTHINGS UP. STOP WASTING MY ******* TIME WITH YOUR **** UPDATES.

STOP THINGS UP. STOP WASTING MY TIME WITH YOUR **** UPDATES. GO FUCK_YOURSELVES MICROSOFT.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

15. ## STOCKHISTORY - STOCK Field

Spit the STOCK field in the function into Exchange Code and Ticker Code. Otherwise in Data Stock have the fields combined as one e.g. XNAS:MSFT

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

There should be an information formula to look for notes, comments it could be a big help like do conditional formatting based on cells that contains notes, comments

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

17. ## Consider adding a keyboard shortcut for subtotal(9,

Consider adding a keyboard shortcut for subtotal(9,. Like Ctrl = for sum

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

18. ## Spliting a single cell

please program to split a single cell. thank you

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

19. ## The ability to traverse through a formula - i.e. move between cells and tabs when selecting individual elements of the formula.

There's a company called BPM which has a Traverse feature. When you select the feature and click on the individual elements of a formula, the feature takes the user to the location of the element, whether it's in the same sheet or a different sheet, or workbook, i.e. t will open up the tab and go to the cell refernce.
This is extremely helpful for complex formulas as it allows the user to navigate directly to each element of the formula string without having to find source references across multiple worksheets and workbooks.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

20. ## Include historical Price/Earnings ratio and Price/Book ratio as parameters in the STOCKHISTORY function.

Include historical P/E and P/B information in the STOCKHISTORY function. e.g. property1=close, property2=open, ... , property6=P/Eratio, property7=P/Bratio.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

← Previous 1 3 4 5 52 53