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

    We’ll send you updates on this idea

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

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

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    9 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. To create a new function to Convert figures into letters

    A new function in order to convert a figure for ex. 2 into two, and more difficult as 1.350, 1.698.367 etc.

    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 →
  8. 10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    5 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  14. Enable Scroll Wheel when select an active Cell eg. an Equation

    Now, it is not possible to use the scroll wheel when entering an equation. I would like to enable this. By the way, when entering an equation it is not possible to ungroup grouped cell. This is a problem when I intend to refer to an grouped cell. I can not open the grouped cell unless I stop entering the equation.

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. Improve productivity of the UI

    The Home Tab needs a re-design - Please focus on Productivity

    Here it how it should look

    http://1drv.ms/1S0qSgF

    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  ·  Flag idea as inappropriate…  ·  Admin →
  16. Power Query needs to pulls over Dax formulas from Excel Data source

    Could not create measure 'Demand'[BOMQty] - 'MRR'[RecvQty] in Power BI DeskTop

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  17. web page

    Make it easy to convert Excel to a back end web page so web site users enter information into fields on the web page, calculations are performed on the back end excel sheet and the results are displayed. Then make it possible to save those results intro a database so it can be used in programs like dynamics CRM.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  18. Change cell relations in another file even if this file is closed

    Problem:
    I have 2 Excel files, let’s call them A.xlsx and B.xlsx.
    Some of the cells are connected: in file A there might be cell C3 for example like “=[B.xlsm]example!D4” and otherwise round.

    If I close file A and add a row in file B that changes the cell names of all following cells, the former cell D4 is now e.g. E4.

    Now I open again file A, and the reference in cell C3 still reads “=[B.xlsm]example!D4” … but it should be E4 because the correlated data is now in cell E4!

    Result: Cell C3 in file A shows the…

    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  ·  Flag idea as inappropriate…  ·  Admin →
  19. Public roadmap for Excel

    Could you please publish the product roadmap for Excel. Other groups in MS have done so with their products, although I appreciate they are open source. It's really very helpful for the partner community and user community to know what's in the pipeline and in what time frame. Thanks a lot, Mark

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

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  20. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base