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 Reporting Ribbon to Excel to consolidate and highlight the amazing capabilities of Power Query and Power Pivot

    Tables, Power Query, Power Pivot and Pivot Tables are amazing tools that will transform the way people build their reports, but only once they know about them!

    Let's SHOUT about how good these things are and how well they work together by putting them onto a single new Ribbon called "Reporting" - something like the attached image.

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

    We’ll send you updates on this idea

    28 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for posting and voting for this idea, but unfortunately we won’t be implementing it. Excel is a tool for a wide set of audience and while this may help to some, it may defintely confuse others. As a workaround, I suggest to use the Customize Ribbon option and add a new tab with you desired set of tools and commands.

    Guy Hunkin
    Program Manager, Excel Team

  2. Bring VBA into the modern world

    It would have a couple of stages.
    Stage 1: Get Visual Studio features into the VBA development environment.
    Stage 2: Fully integrate VBA into Visual Studio.
    Stage 3: Continually improve VBA until it is a modern langauge.

    Notes:
    VBA is probably the most used programming language in the world.
    It has so many established users that MS could really get big brownie points by continually improving the experience for users and developers. Why it has stagnated for so long I have never understood.

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

    We’ll send you updates on this idea

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

    I want to thank everyone for weighing in – none of us on the Excel team are surprised that this item is getting a lot of votes, and we have read all of the feedback in this thread. Extensibility in Excel is something that we are passionate about, and while we’ve been focused on other investments over the last few years (primarily around getting Excel onto more devices with versions for Mac, iOS, Android, and Windows 10), this is something we’ve been actively discussing as we figure out how to enable extensibility of those new platforms.

    As it stands, here’s our current position.

    First, VBA is very important to Excel, and we plan to keep it around for the foreseeable future. As we add new features to Windows Desktop and Mac versions of Excel (where VBA is supported), we’ll continue to add object model for those features (see http://dev.office.com/blogs/VBA-improvements-in-Office-2016),…

  3. Allow autosave/co-authoring for password protected workbooks

    When using co-authoring with Autosave in latest Excel desktop client, it fails if the workbook is password protected. Allow multiple users to edit a password protected workbook.

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

    We’ll send you updates on this idea

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

    Thank you for taking the time to suggest and vote for this feature. We do not have plans to support coauthoring in password protected notebooks, but we are working to support coauthoring with protected documents in desktop clients. See here for more information: https://office365.uservoice.com/forums/928576-microsoft-information-protection-mip/suggestions/19696030-enable-co-authoring-of-protected-documents.

    Thanks,
    Pallavi H [MS Excel]

  4. Show Tables in Power Query when opening an xlsb file

    When using Power Query / Get Data to open .xlsx files and .xlsm files, the Tables present in those files are shown in a list.
    When opening a .xlsb file only Sheets are shown and not any of the Tables present within the file.

    If there is only one table on a sheet, AND it starts in cell A1, then it is relatively easy to still load the data, but where there are multiple tables per sheet, OR the tables don't start in A1, then there is a lot of unnecessary work deleting Rows and or Columns to obtain your…

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

    We’ll send you updates on this idea

    22 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  5. Return share workbook functionality to Excel 2016

    Excel 2016 has recently removed the share workbook functionality and hidden the icon for easily sharing workbooks. It appears that this has not taken into account spreadsheets that are saved on file servers, and aren't uploaded into the cloud (ie the co-authoring functionality). Please return the functionality so that workbooks can be easily shared.

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

    We’ll send you updates on this idea

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

    The Shared Workbook functionality is a limited experience and did not support usage of many Excel features during co-authoring.  We chose to invest resources in building a full experience of co-authoring in Excel through Office 365.  It is not possible at this time to provide that functionality to on-prem servers.

  6. Go to first/last tabs

    In the previous versions of Excel, I was able to go the first/last tab by using the arrow buttons adjacent to the ones that move the tabs left or right. I am using spreadsheets with many tabs and I found this feature quite useful in the past to go to the end or beginning of all the tabs.
    I don't understand why there are now two redundant ways to scroll through the tabs. I have not seen a difference between the left/right arrows and the ellipsis to either side of the tabs. Why don't you bring back the go to…

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

    We’ll send you updates on this idea

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

    You can navigate to the first and last sheet in the workbook by holding down the CTRL key while clicking on the Scroll Sheet Left or Right buttons.

    Thanks,
    Eric (MSFT)

  7. Harmonize Excel.CurrentWorkbook with Excel.Workbook

    Please adjust the M-function "Excel.CurrentWorkbook" so that it returns the same items (in the same structure) than Excel.Workbook (in connection with File.Contents) does:

    Returning a table view of all elements with helpful columns like "Kind".

    But most importantly also returning content from sheets that isn't in a special format like Table or Defined Name but in a simple range.

    There are multiple reasons for letting the source-data untouched but also performing transactions on them and I've come across this request very often. The workarounds are pretty painful (error-prone and need to save file before being able to access data).

    Thanks…

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

    We’ll send you updates on this idea

    8 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for posting and voting for this. Unfortunately, changing the implementation of Excel.CurrentWorkbook will break the existing solutions. With this in mind, we are currently not planning to do it.

    Guy Hunkin
    Principal PM
    Excel Team

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

    We’ll send you updates on this idea

    8 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    This idea is not actionable, so we’re marking it declined to release votes (and prevent more votes).

    Cheers,
    Dan [MS]

  9. Allow Excel to undo macro actions

    I understand that not every macro is undoable, but some should be. For example, "Selection.Interior.Color = 255" is not undoable at the moment, but should be since you could do the exact same thing from the Ribbon. This really discourages people from using the macro recorder, or even macros in general.

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

    We’ll send you updates on this idea

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

    This VBA integration with the undo stack is not something that we’re planning on doing (see the idea about bringing VBA into the modern world).

    Cheers,
    Dan [MS]

  10. there is a problem with the clipboard

    "There is a problem with the clipboard, but you can still paste your content within this workbook" August 22, 2017 In Excel, under File/Options/General, please provide a switch so that users who like to be shown this message can see it, and the unhappy people, like myself, can switch this feature off. Almost every time copying is required ....#@&!!

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

    We’ll send you updates on this idea

    23 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for sharing this feedback! If you see this issue, please use the in-app feedback in the File menu to send us more information, and include the steps you took before you saw the issue. That will give us the information we need to further investigate.
    -Sharon

  11. Default pivot table's to default to "Sum" rather than "Count"

    I would like the default on pivot tables to go to "Sum" rather than "Count" or have an option for the user to select what the default is.

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

    We’ll send you updates on this idea

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

    The default is already SUM as long as the data in the field is numeric. It changes to COUNT when there are text values in the data because we cannot SUM non-numeric data. The current behavior is the intended design.

  12. Include image of new charts

    Excel 2016 would make ooxml more attractive if it included an image of the new chart types.

    Word and Powerpoint include this image of new chart types (e.g. word/media/image1.png) , but Excel does not. This means that implementers of ooxml interpreters have to interpret the new chart data, styles, etc. right away.

    16 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 are not planning to include an image of the chart in the file format in Excel because charts tend to be positioned next to the data that they represent. In backcompat situations, if an image was shown of the chart, it would not update if the chart data was changed. This would create a misleading situation. If there are other scenarios, where providing a chart image in Excel’s file format would be necessary and appropriate, please open a new feature request with those details.

    Thanks,
    Scott [MSFT]

  13. Multiple copies

    Stop making multiple copies of same spreadsheet. This is very confusing, and I end up sometimes entering data on the wrong one.

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

    We’ll send you updates on this idea

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

    Excel doesn’t automatically make copies of spreadsheets except for AutoSave, but that only kicks in if Excel is closed unexpectedly. It sounds like that’s not what is happening though, so it’s more likely that someone is choosing “Save As” to create copies of the workbook.

    I’m declining this idea, so you get your votes back.

    Cheers,
    Dan [MS]

  14. Selecting an area, mark the info in cells with another colour (default: light grey), just like in previous versions

    I know many people do not like the idea of 'supporting columns' integrated in the worksheet for the user. But I'm all for it. Font in same colour as background colour so no one sees it. If I'd like to quickly check what value the formula returns, I'd only need to select an area incl. that cell. The darker grey colour, to mark the selection, is of another shade of colur than the font.

    At least until Excel 2010 this was always standard in excel. In the Mac version it still is the case! Please guys, would you consider going…

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

    Hi Maarten,

    We aren’t going to be changing the selection color in order to make “hidden text” show up more easily because we don’t think that “hidden text” is a good thing in spreadsheets (generally).

    Have you considered adding column to your sheet and simply toggling the hidden/visibility of that column (hide/show) based on whether you want to see the notes?

    Cheers,
    Dan [MS]

  15. insert row/column

    Make it such that double clicking on a row number inserts a row after that row. Likewise for columns.

    4 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 →
    declined  ·  Jeff Zhang (MSFT) responded

    Dear Excel User

    Thank you very much for your time and passion in submitting this feature request. We are doing our best to respond to suggestions that get at least 20 votes. However, we are closing ideas with fewer than 5 supporters that have had no activity for more than 60 days, with the intention of freeing up your votes. Please resubmit your idea if you think it’s super important.

    Thanks,
    Microsoft Excel Team

  16. Change Default Percentage Settings

    When you click the Format as Percentage button on the Home Ribbon, it formats with 2 decimal places. No one in the entire world ever uses 2 decimal places for percentages! I know, I have asked them all :-).

    Please make it 1 decimal place by default, or better still allow the user to easily set their own default settings for each of these format number buttons.

    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 →
    declined  ·  Jeff Zhang (MSFT) responded

    Dear Excel User

    Thank you very much for your time and passion in submitting this feature request. We are doing our best to respond to suggestions that get at least 20 votes. However, we are closing ideas with fewer than 5 supporters that have had no activity for more than 60 days, with the intention of freeing up your votes. Please resubmit your idea if you think it’s super important.

    Thanks,
    Microsoft Excel Team

  17. Allow filters to filter on more than two criteria at the same time

    When filtering data, sometimes you want to be able to have more than two sets of criteria at the same time.

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    declined  ·  Jeff Zhang (MSFT) responded

    Dear Excel User

    Thank you very much for your time and passion in submitting this feature request. We are doing our best to respond to suggestions that get at least 20 votes. However, we are closing ideas with fewer than 5 supporters that have had no activity for more than 60 days, with the intention of freeing up your votes. Please resubmit your idea if you think it’s super important.

    Thanks,
    Microsoft Excel Team

  18. Increase the number of lines we can work with

    Make it possible to have data with more than 1MM lines

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

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
    declined  ·  Jeff Zhang (MSFT) responded

    Dear Excel User

    Thank you very much for your time and passion in submitting this feature request. We are doing our best to respond to suggestions that get at least 20 votes. However, we are closing ideas with fewer than 5 supporters that have had no activity for more than 60 days, with the intention of freeing up your votes. Please resubmit your idea if you think it’s super important. :)

    Thanks,
    Microsoft Excel Team

  19. Bring back the menu instead of the ribbon

    The ribbon is awful and requires a bunch of re-learning every time we upgrade versions. I want the menus from excel 97-2003 back, if only as an option for "power users"

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

    We’ll send you updates on this idea

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

    The ribbon is a cross-Office, cross-Microsoft, and now cross-industry paradigm for UI. At this point we will not be switching out the ribbon in Excel for menus/toolbars.

    Cheers,
    Dan [MS]

  20. Power Excel

    Rename and rebrand Excel to become 'Power Excel'
    This would reflect its modernity, point towards closer integration into Power BI and truly distinguish the product from old Excel
    Modern Excel with all the new functionalities therein represents a tremendous analytic arsenal at your disposal yet most users are unaware of this
    A product name change would immediately change perceptions and promote awareness
    Office 2017 Pro Plus comprising Word, Access, Outlook, Power Excel

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

    Hi Anthony,

    While I personally love the implications of renaming Excel to Power Excel, this isn’t something we’re going to do at this point in time. The (Microsoft) Excel brand is already a well-known brand, and we’re going to look for ways to drive awareness of the new functionalities in that brand rather than change the brand itself.

    Cheers,
    Dan [MS]

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

Feedback and Knowledge Base