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. For better focus highlight current row/column

    Have the option to highlight the entire row or column (or both) that you are working on so you are less likely to read the wrong data.

    101 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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  2. Quit having a spreadsheet reopen in a different size than it was when it was closed

    When I close a spreadsheet, it is the size I want it to be. But when I reopen it, Excel is as likely as not to have "decided" that it knows better than I do what I want, and it reopens in a different size. Sorry, but I do know better than Excel does what I want, and resent the arrogance displayed in changing my preferences. Make it stop!!!

    131 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

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

    When you say that it opens a different size – can you give more info? Do you mean the application window is a different size (it shouldn’t be) or that the font sizes (zoom) are different? (again, they shouldn’t be)

    Additionally, if you can post a video of what you’re seeing, that would be a big help for us.

    If there is a problem here, it’s definitely something we’d want to fix.

    Cheers,
    Dan [MS]

  3. Better productivity-oriented interface (allow dialogs to be modeless, make everything dockable panes)

    As a production tool, drop the ribbon and go to proven high-productivity paradigms with tool palettes, such as exist with Adobe products as Photoshop and InDesign. Being able to arrange direct access to tools on a second monitor provides for far better ease of use and understanding of options.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  4. Provide a way to determine which instance a particular Excel window belongs to.

    I use Excel 2013 at the office and always have multiple instances open, with multiple windows open in each.

    Two important things this would help with are: 1) Clipboard functionality differs for inter- and intra-instance use; 2) Running long calculations (ie, Solver) ties up an entire instance.

    It would be very useful to have a way to identify which instance a particular window belongs to. An instance number or name in the titlebar of each window seems like a good, unobtrusive solution.

    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

    0 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  5. Tool to use arrows in order to highlight one full row at a time

    Currently, if you select a full row and then hit the down arrow, it will jump down to the left-most cell below the row you had selected. Since many people go through row by row to analyze data, it would be helpful if you could use the arrows to go up and down while highlighting/selecting one full row at a time. The workaround most people use for this is shading every other row so it is easy to see which row each cell belongs to.

    26 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

    7 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  6. Function Syntax

    I am applying formulas in excel by viewing the syntax which always
    For example : Sumif(range,criteria,[sum range])

    Everytime you press "," it highlighting in Bold which criteria you are mentioning.
    Now recently what I have found that if any sheet name contains any "," in it and you are applying the formula(example : sumif) from it, then it will not showing all syntax.

    Not sure if this is correct forum. but just found this issue and what to share if we can remove this bug.

    Regards,
    Rajender

    Regards,
    Rajender

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  7. Locking Tab

    The ability to lock individual tabs so that unauthorized users can not open them to either view or change content.

    Locked tabs could still be seen from in the "hide/unhide" drop down but unauthorized users would not be able to open the tab.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  8. Capability to resize Title bar, Tab names (of masked Ribbon) and Quick Access Toolbar

    Hello,

    Moving from Excel 2013 to 2016 lead to loose 1+ raw (same zooming) because Title bar, Tabs of masked Ribbon and Quick access bar are higher. This is a problem at least for these reasons :
    - Sheets sized to fit a sceen (2013) ... don't fit any longer
    - Screens height became smaller with 16/9 (cinema format) pushing us to scroll and scroll...Various bars (Title, Quick Access, Menu..) are now taking more space see hard copy leading us to scroll even more !

    It would be great to be able to resize (height, text and icons) these bars…

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  9. Please allow for expansion of all text boxes (e.g. when tracing dependents to another sheet (alt+m+d))

    When tracing dependents to another sheet (alt+m+d), Excel does not allow you to expand the text box so that you can see the whole reference to the cell, making life difficult when tracing dependents.

    And I am sure there are lots of other cases when the same applies, so please can you make this simple update to Excel to expand any text box.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  10. Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)

    In the good versions of Excel (prior to 2007) one could open multiple workbooks in the same window. Now, one has multiple instances of Excel (and every other Office app) whenever one opens more than one document / spreadsheet.

    Again, here are the issues:


    1. Stability - I experience ~3X Excel crashes in 2016 (SDI) as compared to 2010 (MDI)

    2. Screen Space / Real Estate - Drastically reduced screen space when each workbook requires its own Ribbon, Quick Access Toolbar and Formula Bar

    3. Toolbar to Workbook Confusion - One Ribbon + Quick Access Toolbar + Formula Bar to control all workbooks…
    1,315 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

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

    Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

    Some of the specific issues mentioned are addressed as follows:
    – Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
    - Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
    - Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook. …

  11. Don't Allow Modal Dialogs to Go Behind Excel Windows

    The move in Excel 2013 to use an SDI instead of an MDI has caused some rather serious problems with modal dialogs. There are many ways this can bite you, but the easiest one to describe in this forum is this:


    1. Open Excel 2013 or 2016

    2. Make sure there are two different workbooks open and maximize both their windows.

    3. Go to VBA and in the immediate window type MsgBox "X" and execute it.

    4. The display switches back to the active spreadsheet and there's a "X" in a modal dialog on top of it, as expected.

    5. Now in the Windows taskbar,…
    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  12. When you go to the "move or copy" tab icon, it would be easier if that drop down list included the highlights that I've added to each tab.

    When you go to the "move or copy" tab icon, it would be easier if that drop down list included the highlights that I've added to each tab.

    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

    0 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  13. make an option to shade a row/column as you scroll in a large spreadsheet. This is so you know you are in the correct row/column.

    make a option to lightly shade the row and column you are working in so you can not confuse it with another row/column on the worksheet.

    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

    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  14. Allow personalized tab display

    Allow for drag and drop of tabs from standard horizontal view (like Windows Taskbar) to vertical view (kind of like OneNote).

    My boss is tab happy and I often have to keep selecting move over to see the names. Often, I have to then go back to find what I need. A list display on the right or left would allow me to quickly jump (and it would be a cleaner look).

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  15. A "tree" view like worksheet explorer for grouping worksheet and navigating worksheets. Similar to windows explorer for files/folders n

    A "tree" view of worksheets explorer. For grouping of worksheet and navigation of worksheets. Similar to Windows explorer for files/folders management and navigation. The "tree" worksheet explorer shall appear vertically at the side of the excel software window. This will also speed up the navigation when compare to navigating the worksheets by scrolling the worksheets horizontally

    13 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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  16. Scrolling while writing or editing a formula

    It used to be possible to scroll around the screen using the mouse wheel while writing formulas - to find the cell reference to include in the formula. Now only the scroll bar can be used. This is particularly painful in large sheets as the scroll bars are not sensitive enough to find the right cell easily.
    Thanks for considering

    24 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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  17. Ability to zoom (or set zoom) when embedding a spreadsheet in an iframe

    When i embed a spreadsheet, that resides in sharepoint, using the <embed> option from O365, I should be able to specify a zoom factor, or make the spread sheet scale with the size of the /iframe

    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

    0 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  18. New Slicers - combo boxes and an option for cascading slicers.

    Sometimes slicers take up too much screen real estate or have too many members which hinders the UI experience. Searchable combo boxes and a cascading option where slicers only appear if a parent slicer was first selected would help address this and give more option to designers for creating a better experience.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  19. Dynamic Freeze Panes

    Freeze panes are a really useful way of having some column headings always visible as you scroll around a sheet.

    However, on a sheet with multiple tables or lists of data, the column headings may be different for each table, so can't be included in the freeze pane. As you scroll through the table you then lose sight of the column headings, making the table harder to use and understand.

    It would be great to have dynamic freeze panes in addition to the overall sheet freeze pane. As you're scrolling down a particular table the header row of that table…

    31 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

    6 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  20. Switch to previous tab by clicking currently active one (as an option).

    After (temporary) jump to some tab (sheet) in the same workbook, often I would like to return to the previously active sheet. So I need to look for the proper tab and not always it's easy. It would be much easier to activate the previous one just by clicking currently active tab. This feature could be optional.

    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

    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base