Feedback by UserVoice

Excel for Windows (Desktop Application)

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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. Can't empty the clipboard

    Why oh why is Excel throwing up a "Can't empty the clipboard" error for more than a DECADE. Why is it using the clipboard like that at all? It is these idiotic small things that drove me to Google Sheets.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  2. Change in format

    Sometimes Date formats, number formats etc change when the excel file is opened on another computer; probably when the custom format is not available on the target comp. This should not happen.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Root Mean Square Error (RMSE)

    Please add RMSE formula to statistical function library.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Eliminate redundant sheet references in formulae on that sheet

    Why does Excel sometimes add a sheet reference prefix to a cell reference in a formula when the host cell containing the formula is on that same sheet? A bizarre and inconsistent practice that is a completely useless waste of formula space.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow copying of tables from Word into Excel tables (you can't do that to a merged cell)

    Because of Excel's abysmal text processing functions, I frequently copy large tables from Excel sheets into Word flies. After translating the text, I copy them back to Excel. I'd like to copy entire tables into the original Excel cells, but I get two really stupid messages.
    "The data you're pasting isn't the same size as your selection. Do you want to paste anyway?"
    After clicking OK:
    "We can't do that to a merged a cell."

    This happens despite the fact that the content was copied out of those exact same cells.

    Make it so that I can copy a table…

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  6. worksheet function for returning a field inside a delimited lists

    I’d like to have a function available that returns a specified field within a delimited list. I would pass the list, a delimiter and a field number as arguments to the function and it should return the value in that field.

    For instance with the pipe separated list ”TEST1|TEST2|TEST3|TEST4| TEST5|||||||TEST|” in A1.
    I’d like to use something like GetFieldInDelimitedList(A1;"|";5) and have it return “TEST5”.

    Any equivalent formula will requires quite a lot of nested functions e.g.:
    =MID(A1,FIND("([])",SUBSTITUTE(A1,"|","([])",4))+1,FIND("([])",SUBSTITUTE(A1,"|","([])",5))-(FIND("([])",SUBSTITUTE(A1,"|","([])",4))+1))

    13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add a space between formulae components as the default

    Make the undocumented "feature" which allows the user to add a space between formulae components (e.g. =IF([space]A1[space]>[space]B1,[space]A1[space]*[space]C1,[space]0) without impinging the calculation as the DEFAULT method for saving formulae. This syntax makes reading, debugging and manually evaluating the Fx much easier as selecting the components is easier.
    (I think it would be advisable to still treat Wbk.sheet.range as a single component)

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. VBA: add a TAG property to the Chart object

    A chart in a worksheet has a name, the only way to identify the chart in VBA is to use the shape name.

    But when the user moves the chart to an other sheet and back, the name of the chart changes! I understand that it is necessary that the name changes, but at this point we can not identity the chart anymore.

    So a TAG property (same as in ActiveX controls) would be very helpful to find the right chart within a macro.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  9. Even better... allow for the two way link to include a mathematical expression for each direction

    Even better... allow for the two way link to include a mathematical expression for each direction. One equation for the forward link, one for the reverse. By combining many links, a complex mathematical tree could be created where a user could type in a value anywhere in the tree of cells (from the trunk out to the leaves) and see how the tree evolves.

    15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow full functionality with shared workbooks.

    With the shared worked book i would like to see if i can now merged and actually change things besides just adding rows and columns. i would like to merge,and cells and etc while also tracking what someone else is doing in the same workbook. Same goes for excel online, i like to track what the other person on the workbook is doing.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  11. string function which returns the number of occurences of a sub-string

    I regularly have comma separated lists, and would like to know how many values there are in the string. Currently do that in VBA, but it would be nice if there was a function for that. E.g.:
    A1 = "abc, def, pqr, xyz"
    B1 = PARAMS(A1,[optionally]",") optionally so that you can do ; or others as well

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Custom Formating for numbers is extremely complicated. Please simplify

    Custom Formating for numbers is extremely complicated. Please simplify

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  13. Please fix Filters bug

    When selecting a filter, if the first column in the set of filters does not stretch down to match the "length" of all columns in the filters then filtering is incomplete. Please fix that, by taking the longest consecutive column of all filtered columns, as the list to filter.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  14. Wrap on date formats

    Would be great if wrap could work on a date format; at present it doesn't

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  15. Change message that comes up when a sheet is protected

    The message you get "The cell or chart that you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection using the Unprotect Sheet ..."

    I want to be able to change that on a worksheet by worksheet basis. It is not always appropriate. I have spreadsheets where I want the user to use a specific macro to unprotect the sheet (because other things like logging on need to be done at the same time). We should be able to change that message to a user-customer one.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Remove VeryHidden sheets from "File>Info>Protect Workbook" list in Backstage

    Excel 2010 or later, goto Backstage: File>Info>Protect Workbook

    Under Protect Workbook, it reads "One of more sheets in this workbook have been locked to prevent unwanted changes to data"

    There is a list of protected sheets with Unprotect buttons next to them

    VeryHidden sheets are included in the list. MS, why is that?

    Keep VeryHidden sheets VERY hidden, so users are not aware of their existance, if VBA project is locked

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  17. Advance VLOOKUP

    We need other options to lookup, something like a Fuzzy Lookup but improved or with more features

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Greater control over 'used range'

    Too often does excel blow up spreadsheets' size by extending the used range of the sheet. Sometimes deleting rows/columns and then saving doesn't always work and you are then left with a file that is too big and too ungainly. A simple option to manually override the default used range would quickly resolve this annoying, but common, problem.

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. A Back-Step Button on the Formula Editor

    I use the formula editor a lot to troubleshoot long formulas. It would be nice to back-step at least 3 steps from the current step.

    Say, I've got a formula that errors out on the 15th step. I have to start all over again to carefully step through again to see what happened. It would be helpful to go back a few steps, then forward again.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Changes to Read-Only Mode

    In Read-Only mode for Excel 2013 you can still enter data into cells, at least when opening from a Sharepoint site. However, they information just doesn't save. Since sharepoint opens Excel in Read-Only as default and there is no prompt, my employees tend to not notice and enter their data and don't realize it is in Read-Only and therefore lose all their changes as soon as they exit the application. Read-Only mode either needs a prompt that shows up in the middle of the screen asking if the User wants to open in edit mode OR Read-Only mode needs to…

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base