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. Add a select case function

    =Selectcase(A1>89,"A",A1>79,"B",>69,"C",A1>"59,"D","F")

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

    We’ll send you updates on this idea

    6 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Ribbon appearance customization

    Add way to customize the appearance of the Ribbon such as the way it looked in previous versions, tweaking/modifying them, or creating ribbon themes from scratch.

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

    We’ll send you updates on this idea

    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Cory,

    You can customize the ribbon under File > Options > Customize Ribbon. There, you can create new Ribbons, new Chunks for existing Ribbons, etc.

    Hope that helps,
    Dan [MS]

  3. Allow Charts to use data from hidden cells

    As of now, if you group and/or hide cells that contain data going to a visualization, the visualization goes blank. I'd like to be able to hide data without losing the corresponding visual.

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    We actually support this feature in versions of Excel back to XL 2007. Here are the steps.

    1) Select the chart
    2) from the chart “Design” tab in the ribbon click on the button “Select Data”
    3) In the dialog, click on the button called “Hidden and Empty Cells”
    4) In the dialog, check the box called “Show data in hidden rows and columns”

    Thanks,
    Scott [MSFT]

  4. Absolute Reference Shortcut

    Really simple. Pretty much in all my data analysis involves absolute references and relative references. For a formula I enter, I have to go through and manually type in the $ symbols to lock those references, which can be cumbersome when I have 15 or so references to take care of. What I suggest is a shortcut key e.g. ctrl + click/alt + click where by clicking the cell in the formula using this combination will convert it to an absolute reference.

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

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Great news, we have this in Excel already. as you are authoring a formula, when you select a cell/range, you can press F4 to toggle the “absolute-ness” of the reference.

    cheers,
    dan [MS]

  5. Don't autocorrect if you can't override (idiotic functionality keeps changing EHR to HER, but you can't undo like in Word or Outlook).

    Get smart like iOS on your autocorrect. If you a user deletes/overrides your autocorrection right away, leave it alone. The way the feature is implemented in Excel leaves the user no choice but to turn it off.

    Try it. Type EHR (as in Electronic Health Record) into a cell (with our without the leading single quote and watch it autocorrect to HER when you hit return or select another cell. Undo does not work (like it does in Word or Outlook).

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

    We’ll send you updates on this idea

    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

    This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.

  6. Stop Auto correcting certain words

    Just as in Word when you type: i.e ihs, it will auto correct to "his" but it will place a little grey bar under that word that has a pull down menu allowing an option "Stop automatically correcting this word." Excel does not have that feature, must enter auto correct menu and use the exception menu to place it on the list. Change Excel to have same options as Word.

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been greatly improved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

    This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you…

  7. stupid speling correction

    hey hey hey ! what is this ! i am trying to type a name list (teh) excel change back (the) and keep changing and changing u think u fking god know what i want is it ! i HAVE NO TIME FOR TIS ****.

    1 vote
    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 →

    We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

    This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.

  8. 12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Update (July 25)

    Hi again Erik,

    This issues should be fixed in our August 2nd update.

    If it isn’t, pls reach out to me directly at myfirstname dot mylastname at microsoft dot com.

    Thanks again for raising it.
    ash

    Program Manager
    Excel

    Hi Erik,

    Boy, you’ve been having quite a saga here. Even though this site is for new requests, appreciate finding out about this. I’m reaching out to Brian to understand what’s happening so far.

    thanks
    ash [Microsoft Excel]

  9. Found an error in Excel 2016 help documentation

    The results column in the help window for the index function just mirrors the formula. Looks like it's because there's an apostrophe before the formula. Not sure where to report this. Looks like it's the same for 2013 too.

    Screen shot can be found here: http://answers.microsoft.com/en-us/office/forum/office_2016-excel/found-an-error-in-excel-2016-help-documentation/410a27a3-0b3b-41c7-a99c-8fc2ff323542?tm=1472245876517

    1 vote
    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 →

    Thanks for the heads up. We’ve updated the topic, so the changes should go through shortly.

    (And thanks Smitty for making the update!)

    Cheers,
    Dan [MS]

  10. HTML formatted files (with an XLS extension) no longer opened

    Since a recent update HTML formatted files with .xls extension are no longer opened. When downloading such a file Excel opens but does not open the file anymore, it just shows a blank screen, no error message. This used to work for years and was very easy to create reports from our intranet by just sending HTML files with Excel headers out. Because of this we now have to re-engineer all reports, please bring the functionality back.

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

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all,

    We’ve released a fix for this issue. I’m copying the official release notes for it here, as this is part of several different updates to several different versions of Office:


    The Excel team has released a change in behavior in today’s security update for Excel 2010, 2013, and 2016. Excel will warn about the mismatch between the file extension and HTML content, but will now open the workbook in Protected View as an additional layer of security. If you trust the workbook, you can then enable editing. The behavior of .xla and .xlam files will remain the same.

    How do I get the update? It depends on which version of Office you have.
    • Office 365 subscription (Click-to-Run)—install the latest updates
    • Windows Installer version (MSI)—you could wait about a week for the next security update for MSI, and it will update automatically. Or, to…

  11. Allow me to submit missing Polygons in 3D Maps

    Allow me to submit missing polygons from the page that mentions it so I can get them fixed faster. 3D maps is no good if it won't show the polygons for a territory.

    https://1drv.ms/i/s!AjApVpgq6WQ0h6JwzoqyAzQ4XbnuKQ

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

    We’ll send you updates on this idea

    3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    You can submit feedback through the “Send a Smile” mechanism. Click on the smiley face in the upper right corner of Excel.

    Thanks,
    Scott [MSFT]

  12. error in support page

    in the support page: https://support.office.com/it-it/article/Rilevare-gli-errori-nelle-formule-3a8acca5-1d61-4702-80e0-99a36a2822c1?ui=it-IT&rs=it-IT&ad=IT there's an error.

    in particular at the point:
    Excel visualizza questo errore quando un valore non è disponibile per una funzione o una formula.

    Se si usa una funzione come CERCA.VERT, il valore cercato ha una corrispondenza nell'intervallo di ricerca? Nella maggior parte dei casi non è così.

    Provare a usare SE.ERRORE per eliminare l'errore #N/D. In questo caso si può usare:

    =SE.ERRORE(CERCA.VERT(D2;$D$6:$E$8;2;VERO),0)

    the correct formula is:

    =SE.ERRORE(CERCA.VERT(D2;$D$6:$E$8;2;VERO);0)

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    We’re fixing this now, will likely take several days to propagate out to the internets.

    Cheers,
    Dan [MS]

  13. let pen usage toggle between inking and pointer

    The January 2016 Office update defaults the Surface Pen to an inking tool. Most Excel users prefer to use the pen as a pointer. Please give us a toggle in the ribbon to switch between inking and pointing.

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

    We’ll send you updates on this idea

    166 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    (2016-03-15 – Completed) (Edit: Added link to Office Insider signup)

    I wanted to let everyone know that in the update to Office that started rolling out to Insiders today, you will find a new preference in the Options dialog to allow you to make the pen select instead of ink by default. Enabling this preference will make the pen function exactly like it did before, plus you can use the options on the Draw tab if you do decide you want to ink. If you are an Office Insider (which anyone can join – https://products.office.com/en-us/office-insider), you should get this update within the next day or so. If you are not an Office Insider, it may take another week or two to reach you.

    This is a per-app preference, so you can enable selection by default in Excel for instance while leaving ink as the default in Word and PowerPoint,…

  14. Kill nested IFs

    What about a function like =ELSEIF([if1]; [then1]; [elseif2]; [then2]; [elseif3]; [then3]; ...)

    1 vote
    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 →

    Give our new IFS and SWITCH functions a go – they are exactly what you’re looking for.

    Cheers,
    Dan [MS]

  15. Increase usable memory or switch to 64-bit Excel as recommended version.

    Being limited to 2 GB of memory usage for Excel seems ridiculous in this day and age. Large files are more and more common, and the newer versions of excel (2013 and 2016), particularly VBA-containing sheets, seem to experience major performance changes based on how many files are open. Being forced to close all other sheets just to run VBA code in one is annoying.

    Can you either make changes to increase the usable memory or make whatever shifts are necessary to be able to recommend the 64-bit version of excel as standard? At this point the performance impact of…

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

    We’ll send you updates on this idea

    2 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all, great news!

    32-bit Excel 2016 build 16.0.6868.2060 onwards is enabled for Large Address Aware. This will allow 32-bit Excel 2016 to consume beyond 2 GB virtual memory… up to 3 GB on x86 Windows and 4 GB on x64 Windows. We believe this should help alleviate some of the out-of-memory related errors seen before when memory is constrained for 32-bit Excel, for more details see KB3160741 here https://support.microsoft.com/en-us/kb/3160741

    Also – I should note that this idea covered two topics – more memory for 32-bit Excel, as well as making 64-bit Excel the default/standard. I’ve created another idea on UserVoice that you can vote on if you’d like to see 64-bit Excel as the standard: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13795662-create-a-64-bit-version-of-excel

    Cheers,
    Dan [MS]

  16. Excel Ink Broken in NEW ways

    Fix The Pen, Now. I spent $$$$$$ on the Surface Book, and now the main purpose of buying it is DEAD.

    Specifically, Excel sporadically chooses when and when not to allow pen for inking. Sometimes there is an invisible box where writing isn't allowed. Sometimes it works okay, but I am literally in the cold sweat mode hoping it works each time. Maybe I need counseling?

    By the way, I have an audience of 50-100 future business managers every day, watching me use this. I get a new group every 3-4 months. Guess what I complain about!?

    Fix it. Then…

    3 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 →
  17. 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Black theme is back. Update to the latest update for Office 2016, and you can choose Black Theme as one of the options.

    Cheers,
    Dan [MS]

  18. Fix the 'Apply Names' bug that corrupts formulas or crashes Excel

    As already reported in

    http://answers.microsoft.com/en-us/office/forum/office2013release-excel/when-will-the-apply-names-bug-in-excel-be-fixed/0eb23d54-fbf0-4c64-8bad-cf52bc32547f?auth=1

    The Apply Names command loses parts of formulas and in certain cases Excel will crash.

    This bug is in Excel 2010 and 2013 and 2016, not in Excel 2007 or 2003.
    To reproduce this, follow these steps.

    Enter 2 in B1 and 3 in B2
    Enter =B1 in A4
    Enter =B2 in A5

    Give $B$1 the name "value1"
    Give $B$2 the name "value
    2"

    Enter the formulas below starting in B4, and then click Names > Apply Names and select both names.

    =B2/B1
    =$B$2/$B$1
    =$B$2/B1
    =B2/$B$1

    In B4 The expected result is…

    1 vote
    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 →

    Hi,

    I just read through the answers.microsoft.com post that you linked to, and it appears that this is fixed in Excel 2016 build 16.0.6568.2025.

    Also, we’d like to try to keep this uservoice site for new feature ideas, rather than for bug fixes (which answers.microsoft.com is targeted at.)

    Cheers,
    Dan [MS]

  19. Recent Files pane in Excel 2013 was pretty good, but Excel 2016 broke it (Pin pinning recent files no longer sorts alphabetically)

    In Excel 2013, you could pin recently opened files to the top of the list, and they would be sorted alphabetically. This way, you could easily get the same file by using keyboard shortcuts. For example, Alt-F-R-1 opened the first one on the list, alphabetically. The order stayed constant until you pinned or unpinned a file.

    In Excel 2016, the files are listed chronologically, so Alt-F-R-1 opened the most recently used one. If you wanted to get a certain one, you have to wait to see where it is in the list. This is a TERRIBLE change. I keep opening…

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

    We’ll send you updates on this idea

    165 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    = 2016-12-09 =
    Hi all,

    The MRU should be sorting alphabetically again if you’re using build 16.0.7466.2038 or later. You can find your build number under File > Account.

    Cheers,
    Dan [MS]

    = 2016-09-22 =
    Hello,

    I noticed a few reports of folks not seeing alphabetized MRUs anymore so I followed up with the Office team (it’s shared across Word, Excel, PowerPoint, etc.) that owns this.

    Turns out that they rolled it out in July (and then we posted here that the work was completed) but then ran into some bugs and so disabled the feature on the MRU-service side.

    That bug has been fixed, and they are planning to roll it out again in October.

    Cheers,
    Dan [MS]

    = 2016-07-11 =
    Greetings,

    Good news on the recent files front – pinned files are now sorted alphabetically, as they were in previous versions of Office (and Excel).

    To see…

  20. When filtering allow boxes on right of filter values to auto unselect all & select value

    When you are filtering a worksheet, when hitting the drop down value we get a (Select all) and a check box for each data value. Rather than having to unselect all and scroll to the items you want to check to display allow a checkbox to the right of the values to simulate the unselect all and check current item. Then continue checking items as usual if needed. Very helpful on larger data filtering.

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

    We’ll send you updates on this idea

    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    Unselecting all items in the filter dialog/drop down can be done with the “(Select All)” item that is checked by default — if you uncheck that, then it will unselect all of the items in the list and you can continue to select just the items you want to filter on.

    Hope that helps,
    Dan [MS]

  • Don't see your idea?

Feedback and Knowledge Base