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

  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. CloseAs

    Instead of having to do both a SaveAs and a Close, have a CloseAs
    Easy-peasy for you to implement.
    Regards
    Brian

    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

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 10 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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    I received email back from Sam saying he’s expecting this to be the Table Analysis functionality (like key influencers, highlight exceptions), and not the explicit Data Mining features (like clustering). Am going to update the title, and we’ll wait for more votes before considering this item.
    Thanks, Sam!
    Ash

  16. Shortcut for un-hiding columns NOT WORKING IN OFFICE 2010

    Ctrl 9 Used for hiding rows
    Shift Ctrl 9 Used for un-hiding rows
    Ctrl 0 Used for hiding columns
    Shift Ctrl 0 Used for un-hiding columns (THIS IS NOT WORKING IN OFFICE 2010)

    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  ·  Flag idea as inappropriate…  ·  Admin →
  17. Check and X

    Conditional formatting is not good enough. I would like a big X and a big check mark right in the main menu. This would be so usable to so many.

    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

    5 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add rich-text support for Excel

    Excel's handling of in-cell text formatting leaves a lot to be desired.

    For example, if I have something like 30m^2 (30 square meters, where the 2 is superscripted), and I do a search and replace (e.g., changing m to cm), then the 2 ends up not superscripted any more.
    Or if that cell value is concatenated (using a formula like =A1&A2) with another cell value, then the formula does not show the 2 as a superscript.
    And it is not even with "odd" formatting like superscripting. Even if I have some letters (but not all) in a cell marked bold,…

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  19. New maths & stats functions

    Like MAXIF, MINIF and SUMPRODUCT that works on Row x Column (currently need to rely on MMULT even for 1 dimensional arrays or use TRANSPOSE)

    14 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 →
  20. Getting cell information without resorting to VBA

    Some organisations would prefer if we did not use VBA when designing their spreadsheets. It would help therefore if more could be done without it.
    As a start can the range of information returned by CELL() be expanded to included, for example, the interior colour of the cell and the formula in the cell (as text).
    As a bigger project, what about ensuring that all in-built Excel VBA formula can be accessed through the worksheet formula without resorting to VBA.

    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

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

Feedback and Knowledge Base