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.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party 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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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

    0 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Formula Tab Indentation

    Can you please allow tab indentation of formulas?

    It would be even nicer if Excel did it automatically.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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…

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Notes, Comments Lookup

    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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Consider adding a keyboard shortcut for subtotal(9,

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

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Spliting a single cell

    please program to split a single cell. thank you

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  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.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 52 53
  • Don't see your idea?

Feedback and Knowledge Base