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. Scroll horizontally by pressing Ctrl+Shift+Wheel scroll, or with mice that support side scroll, like Adobe Reader, Chrome, IE...

    Scroll horizontally by pressing Shift+Wheel scroll, or with mice that support side scroll, like in other aplications, like Adobe Reader, Chrome, IE...

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

    We’ll send you updates on this idea

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

    Good news! On Windows, you can now scroll right and left using a mouse with a scroll wheel by holding down CTRL+SHIFT. If you move the scroll wheel up, it will scroll your sheet to the left, and scroll down to go right. On Mac, you can just hold the SHIFT key to do the same thing.

    To see all the suggestions we’ve completed, please see https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/filters/top?status_id=1406092

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

    167 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,…

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

    We’ll send you updates on this idea

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

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

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

    109 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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]

  6. make excel 2016 as stable as previous versions

    Make Excel 2016 as stable as previous versions
    We run complex spreadsheets with conditional formatting and links between spreadsheets and macros to drive behavior - this is both inherently slow (on various different computers) and unstable - crashes almost daily
    Previous versions of Excel handled these same spreadsheets cleanly and easily !!!

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

    We’ll send you updates on this idea

    26 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you all who voted! And we hear you loud and clear and we have been working hard at improving Excel 2016 stability on-going with every monthly release with our January monthly channel release at historically low levels based on our internal measures.

    Moving forward, please send us feedback from within Excel, which includes actionable crash information we monitor regularly. Once Excel reboots from a crash please goto File → Feedback → Send a Frown, provide information on what Excel specific action you were doing when the crash occurred and press the “Submit” button.

    thanx,
    Prash [MSFT]

  7. Allow PowerQuery to Extract Data from PDF tables

    Allow PowerQuery to import tables of data from PDF files.

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

    We’ll send you updates on this idea

    11 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. Make Excel obey the "scroll inactive windows" setting in Windows 10

    Make Excel obey the "scroll inactive windows" setting in Windows 10. Currently Excel will scroll when it is an inactive window, but it will not allow other windows to scroll when it is the active window. This makes transcribing data from a source that needs to be scrolled difficult.

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

    We’ll send you updates on this idea

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

    Thanx for creating and voting on this folks!

    You should see this issue fixed starting with the latest Windows 10 Preview 17133.73 build update on 4/10 (https://blogs.windows.com/windowsexperience/2018/03/27/announcing-windows-10-insider-preview-build-17133-for-fast/) as well as latest Excel Monthly channel 1803 Build 9126.2152 update on 4/11 (https://technet.microsoft.com/en-us/office/mt465751.aspx).

    Please let us know if you find this still not fixed with these builds (and later).

    thanx,
    Prash [MSFT]

  9. Improve the Concatenate Function

    Make Concatenate to Work with Range of Cells / Arrays rather than 1 cell separated by Comas

    =CONCATENATE(Array,Seperator)
    The Array to Accept A1:A10 or A1:D1 or {"Abb","Areva","BHEL"} or {"ABB";"Areva";"BHEL}
    or

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

    We’ll send you updates on this idea

    19 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Histogram, box plot, quantile plot, and other statistician-friendly features needed

    I am regularly surprised when Excel can do complex operations using built in functions, but there is a lack of data visualization options out there. For example, a histogram, box plot, and quantile plot can provide options for visualizing and comparing data. I know these can be achieved using various add-ins (for example QI Macros), but those are never perfect and always seem hokey. Also would love to be able to do hypothesis tests (t-test, f-test, z-test, and so on) in user friendly and visual manner. Also, for all charts, please add a feature for using split column(s) to differentiate…

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

    We’ll send you updates on this idea

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

    In Office 2016, we released 6 new built in chart types: Treemap, Sunburst, Histogram, Pareto, Box & Whisker, and Waterfall. Checkout the following link for the top new features in Excel 2016. https://docs.com/ExcelDemos/7981/excel-2016-top-features.

    However, there are several other feature requests wrapped up in this post. Please enter those as separate items so that we can respond to them individually.

    Thanks,
    Scott [MSFT]

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

  12. Please add MAXIF and MINIF

    It would just be so useful to have this. Thanks!

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

    We’ll send you updates on this idea

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

    2016-04-19

    Hello all,

    Just wanted to let you know that we’ve released MAXIFS and MINIFS to Excel as part of Office 365. If you’re a subscriber you should already have (or see soon) these functions in your arsenal.

    Cheers,
    Dan [MS]

    2015-11 ========
    Hi there,

    Great news – we’re working on this! Actually, we’re working on MAXIFS and MINIFS – even better :-)

    Cheers,
    Dan [MS]

  13. 38 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Better testing with large, complex workbooks

    I work with a large, complex workbook (several MBytes, about 150 worksheets). Excel crashes several times per day, and even crashes Windows 10 regularly with a stack overflow. Simple VBA code that works with small workbooks will regularly crash Excel (e.g., For Each ws In wb.Worksheets; do something simple; next ws). I suspect that the problems are memory or stack related, but my real request is for the testers to specifically create test cases based on huge workbooks, then see what happens.

    21 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 →

    Over the last few years, we’ve improved our ability to detect and fix performance issues significantly, and as a result we’ve seen performance improvements for users as well.

    We intend to continue working on performance, but we’re marking this suggestion as completed.

    Steve [Excel team]

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

  16. Kindly make power pivot option as a standard in excel 2016

    The use of pivot has increased over the period of time. Currently power pivot is provided as add-in and is not part of standard excel. Request you to make power pivot as a standard option in next release of excel i.e. Excel 2016

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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.

  18. Disable time grouping

    The new automatic time grouping in PivotTables should be an option within Excel. Users should not need to make a registry edit to disable this feature, and the time grouping should not be on by default.

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

    We’ll send you updates on this idea

    completed  ·  80 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add User Voice Button to Excel interface

    To add a button to reach this page directly when there is a new idea to work on ... Ideas will come more fresh and easier to describe..

    10 votes
    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 →
  20. 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]

  • Don't see your idea?

Feedback and Knowledge Base