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. Open find with options

    The find dialog has an options button but it always opens with the options hidden. I literally always need to click that button to get to the options I need, or even to see which are currently set. Can Excel PLEASE remember that I clicked that button and leave options visible? Preferably between sessions too.

    90 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

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

    Hi everyone – I have great news about this request. The options will remain visible now, and Excel will remember so that next time you Find, it will show you the options.

    Make sure you update to version 2106 (build 16.0.14131) or later and you should see the difference when you use the Find dialog.

  2. money in excel - Add Credit Karma Savings

    Connecting Credit Karma Savings #moneyinexcel

    1 vote

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

    Hi, 

    Thank you for taking the time to send this feature request! I agree that adding Credit Karma Savings institution would be useful. I’ll share your feedback with the rest of the Money in Excel team and notate this ticket to update you when we have more information about this issue. 

    Please feel free to reach out again with more feedback or if we can provide additional assistance. 

    Thank you for using Money in Excel! 

    Best,

    Prakhar Garg
    The Microsoft team

  3. Remove the lock symbols from the tabs of protected sheets

    Microsoft appears to have added this as a new 'feature' in Version 2006 (Build 13001.20266 Click-to-Run) and it's a disaster. For a workbook with a large number of protected sheets the visibility of sheet tabs is reduced by ~ 30%, thereby greatly reducing user-friendliness and the ability to navigate around the workbook using sheet tabs.

    I've attached a screen grab of a basic model containing protected sheets which has lost visibility of at least 3 sheet tabs as a result of the unnecessary and unwanted lock symbols on almost every sheet.

    This 'feature' needs to be removed or made optional…

    199 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

    233 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →

    Hi All, We apologize for being slow to engage on this thread. We are listening to your feedback and we really do care. After reading the comments here as well as the feedback sent from within Excel, we have decided to remove the lock icon from Excel on Windows for the time-being. Since it’s not new to the other platforms (web, Mac and mobile) and we haven’t had similar feedback about it there, we won’t change those for now. We’ll consider how best to get consistency across the desktop, web, and mobile apps, and we’ll share updates if we have any additional next steps.

    We appreciate all the suggestions for alternative ways of indicating that a sheet is protected, and will take them into account.

    Thanks for all your feedback.

    Steve [Microsoft Excel]

  4. Money in Excel: Multiple Accounts Per Institution

    It's very common for a couple to both have accounts at one institution, but want to track data together. Unfortunately I can't use Money In Excel until this feature lands.

    47 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

    23 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Circling back on this most upvoted feature, we’re excited to let you know that we just launched it due to your feedback!

    - With Multi-Credential Support, you and your family members can connect multiple accounts from the same institution into Money in Excel. We hope this will make Money in Excel more useful for those who manage their finances together.
    - To help you keep track of different accounts from the same institution, we’re also introducing Account Nicknames. In the Accounts tab in the Money in Excel pane, you can now customize your accounts with nicknames (You can even use emojis!)
    If you do not see this update in your version of Money in Excel, try downloading a new version of the template here: Money in Excel Template. And don’t worry, your financial account data will not be lost!

  5. Error in the translation of the function description "PROCURAR" (MS Excel Pt-Br)

    On the Brazilian Portuguese version of Microsoft Excel (desktop and online versions), the "PROCURAR" function has a translation error on its description.

    The "PROCURAR" function description text uses the word "LOCALIZAR" instead of the word "PROCURAR", causing an error because "LOCALIZAR" is also another function.

    The description states that "LOCALIZAR" is case sensitive. The "LOCALIZAR" function makes no distinction. The more adequate use on this case would be: "PROCURAR" is case sensitive.

    41 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. Translate XLOOKUP and XMATCH to PROCX and CORRESPX in Portuguese

    That's it: PROCX and CORRESPX in Portuguese versions of Excel to keep the same standard of the other functions.

    🇧🇷🇵🇹🇦🇴🇲🇿🇨🇻

    307 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

    29 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Release XLOOKUP to the world!

    Why only release to 15 percent of users?! Let the world have XLOOKUP and XMATCH now()!

    193 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

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

    XLOOKUP is now available to all users of modern Excel across all endpoints. We deployed XLOOKUP to the last group of users (Semi-Annual channel) in July 2020.

    XLOOKUP will not be available in Excel 2019 and Excel 2016. These are point in time versions of Excel that predate the release of XLOOKUP.

    [Joe McDaid – Excel PM]

  8. Add an If_NA optional sixth argument to XLOOKUP

    The new XLOOKUP function introduced on August 28 2019 is awesome - exact match by default, the ability to return several columns at once, and search from bottom of data. But one thing would make it better - an optional sixth IfNA argument to provide an answer in case nothing is found.
    One of the benefits of XLOOKUP is to eliminate the need to nest MATCH inside of INDEX. If you are trying to reduce the number of functions this would be a low-impact way of eliminating nesting XLOOKUP inside of IFNA.
    For me, the main argument is that

    108 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

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

    Thanks for the suggestions folks! We’ve added [if_not_found] as the 4th argument to XLOOKUP. The thinking is as follows:

    It’s a reasonably common use case
    The ISNA XLOOKUP approach cannot distinguish a “not found” from a #N/A returned from a valid match.
    - Joe McDaid [Excel]

  9. When copying tabs, somtimes we have to cycle through 100s of "Yes" or "No" to the "Name already exists warning" Can we add Yes to All option

    This is a major productivity killer for power users such as finance teams, and current UX does not help exit this state efficiently.

    230 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

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

    Thanx for all your feedback and voting folks!

    You should see a “Yes to All” option in the “Name Conflict Dialog” from O365 version 1907 onwards. https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2019#version-1907-july-29

    Also, the “Name Conflict Dialog” article have been updated accordingly: https://support.office.com/en-us/article/why-am-i-seeing-the-name-conflict-dialog-box-in-excel-f9251985-dbde-4030-86d8-e90775e79952

    Please let us know if you do not find this to be the case.

    thanx,
    Prash
    [Excel Team]

  10. Bring back Edit Comments (Legacy) to the Right-Click Menu

    The new Threaded Comments that appeared in Build 1809 are awesome for 99% of the people. But for the Commenting Gurus - anyone who has ever taken the time to build help systems by resizing, re-coloring, re-shaping and using Show All Comments, we are going to see our comments get destroyed by well-meaning co-workers.

    Yes, all of the legacy icons are available for adding back to the Ribbon, but we the comment gurus can not trust our co-workers and managers to take the time to add these.

    My request: If Excel detects any comment in the workbook that is a…

    153 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

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

    We have addressed the topic of this suggestion by bringing back the legacy comments as notes and included the edit comment action as “edit note” in the right click menu. Also, this topic has multiple suggestions, so if for any remaining suggestions which are not covered by the update to reintroduce legacy comment editing, please open a new suggestion. Thank you.

  11. STOP turning the AutoSave back on when users turn it off!

    STOP turning the AutoSave back on! AutoSave falsely represents users as updating the file AND creates unnecessary versions. Users turn it off and after Microsoft updates are pushed into the environment - it comes back on. Bad idea!

    11 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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Changes to AutoSave settings should not change on update. This issue was raised when the changes to AutoSave were made. This should no longer be a problem. If you experience further issues go to File > Feedback and send us more information.

  12. Power Query Advanced Editor and Formula Bar Intellisense

    Add intellisense to the advanced editor and the formula bar for the Power Query M-Code.

    48 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

    12 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    A little bit late updating the status on this suggestion, but we’re happy to say that Power Query now has Intellisense when using the Advanced Editor and the query formula bar. If you don’t see it already, just go to File > Options and Settings > Query Options > Power Query Editor, and enable M Intellisense.

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

    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 →

    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.

  14. removing sexist algorithms

    Please can you allow "Mrs. and Mr." to be written in excel without excel autocorrecting to "Mrs. And Mr." because the traditional rules state that the man is first. I am writing letters to donors and I always put the donor in the first position and the associated donor in the second. Excel only auto capitalizes the "and" when it is in the Mrs. and Mr. position. This is a pain that it was written into the algorithm. And sexist. Thanks.

    1 vote

    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

    8 comments  ·  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 “Mrs. and Mr.” into cell A1, Excel will autocorrect it to “Mrs. And Mr.”. If you go back and type “and” again in the same place, Excel will not correct it again. It will still autocorrect “Mrs. And” if you type it into a different location, or if another autocorrection happens before you change “And” back to “and”. 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.

  15. Pull Current Stock Prices and Historical Data Into Excel

    Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.

    It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.

    1,148 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

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

    Good news! The STOCKHISTORY function is now available to all Microsoft365 subscribers using Windows, Mac, and Excel for the Web!

    If you are unable to see the function you may not have the latest Excel Updates installed on your desktop or are on Semi-Annual Enterprise channel (which releases about 6 months behind current channels). Please send-a-frown or send-a-smile to let us know about your experience (https://aka.ms/ExcelSendAFrown).

    Here is an example formula to get you started: =STOCKHISTORY (“MSFT”, “1/1/2021”,“2/1/2021”)

    More details can be read on: https://techcommunity.microsoft.com/t5/excel-blog/announcing-stockhistory/ba-p/1404338

    This wonderful feature has been a long time in the making, and we are hoping this functionality helps enhance your decision making experiences using Excel.

    —Kaycee Reineke
    Excel PM

  16. Filtering Needs to Work in Co-Authoring

    Say that several people are editing the same workbook. If Tom filters to show only his records, then the other people will only see Tom's records. We need to be able to have each person apply a different filter and see only their records.
    Note that it is fine to require that the workbook can not have SUBTOTAL or AGGREGATE functions in order for independent filtering to work. If you allow these functions, then everyone will have different calculation results which would be problematic.
    It is more important to us to be able to have each person apply a local…

    721 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

    80 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  17. Unhide multiple worksheets at once

    We can hide several worksheets at once, but we can only show them individually.

    Although the VBA can solve this issue with some lines of code, but it would be a great improvement if you add this capability to Excel as a build in feature.

    775 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

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

    We’re excited to share that this feature is now available for Microsoft 365 Subscribers. To get it, you should update to version 16.0.13525 or greater on Windows, or 16.45 or greater on Mac. It’s also available in Excel for the web.

    If you are excited by this change or have comments for us, please let us know at Help → Feedback.

  18. I want "JOIN(range, delimiter)" function

    To concatenate multiple cells, I can use CONCATENATE() function or simply join by "&". But as a range, there seems to be no handy function.

    I want a "JOIN()" function.
    USAGE:
    JOIN(<RANGE>, <DELIMITER>)
    ie, for joining from A1 cell to AX1 cell with a delimiter ",", =JOIN(A1:AX1, ",")

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Options for AutoSave

    The AutoSave function is a great idea!!
    Just not in practice...
    In my business we re-use the same invoices made in excel for the same jobs, however save them as a new file each time in order to keep a record of the previous invoice.
    The new AutoSave feature is extremely dangerous in this regard.
    If I, or someone else, does not remember to turn off AutoSave, or save as a new file BEFORE making new changes, we LOSE our previous invoice.

    Have options for AutoSave, the most important one being, DEFAULT OFF rather than default on.

    151 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

    61 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you all for your feedback regarding the new AutoSave functionality in Excel.

    We’ve been working to better enable collaboration and AutoSave is a key component that. While it can take some getting used to, AutoSave helps users feel confident that their work is being saved. This is especially evident when working with other people, but it also helps when you’re working by yourself.

    We understand that you may need to turn off AutoSave for some workflows, so we are excited to announce that it is now possible to turn off AutoSave for a particular file as well as to change whether AutoSave is or or not by default.

    For instructions on how to do this please see here: https://support.office.com/en-gb/article/what-is-autosave-6d6bd723-ebfd-4e40-b5f6-ae6e8088f7a5#OfficeVersion=Windows

    This functionality is currently available to O365 subscribers.

    We hope you continue to leave feedback on Excel to help us improve.

    Thanks,

    Pallavi Hukerikar
    Excel Program Manager

  20. May 2017 update which keeps the copied item active in the clipboard

    Regarding the issue of...It's part of the May 2017 update which keeps the copied item active in the clipboard even if you do things that would normally clear it, like typing in a cell, applying formatting, etc.

    Pressing ESC will clear the marquee/dancing ants.

    Why in the world would Microsoft and an extra step here. This is terrible. At least give us the option to turn off the function. Please change this back or give us the option. Very disappointed!

    586 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

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

    Keep the Copy was designed to improve the experience of copying content to your clipboard based on customer requests. Copy and Paste functionality is different in Excel than most other applications because results from formulas can change and due to the large size of worksheets. Since making the improvements there has been mixed feedback about the changes that we made and it is not up to our quality standards. Effective today, Keep the Copy will be removed from Excel until we have improved the quality and design of this feature.

    Thanks,
    Eric Patterson
    Excel Program Manager

← Previous 1 3 4 5
  • Don't see your idea?

Feedback and Knowledge Base