Feedback by UserVoice

Excel for Mac

Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. 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.

How can we improve Excel for Mac?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add PowerPivot to Mac excel

    is it possible to open an existing Windows Power Pivot Excel on Mac?

    I have already created a Power Pivot Excel report on Excel 2013.
    Now i want to use that report on mac.Is there any way to do so?

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

    We’ll send you updates on this idea

    505 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  2. 202 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    26 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  3. "Night" version

    Make a setting that turns cells a dark/black color and the lines white. Twitter has a setting like this, where your timeline turns dark blue and the words turn white.

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

    We’ll send you updates on this idea

    1 comment  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Since the cells are formatted for what they will look like when printed, the default is to have white background with black text. You can make your own worksheets “Night” theme by selecting the entire sheet and then setting the background of the cells to a dark color, the font to a light color, and the cell borders to a light color. You could also apply a small dark image as the background image, which will be tiled across the entire sheet.

    It would be great to hear how you think Excel should handle a Night mode for the sheet automatically. For example, if the sheet has content that is in a wide range of colors, should they automatically be adjusted to be easily visible with a dark background, even if that’s not how the author wants them to show up in the light mode?

  4. Restore data form functionality (different from VBA UserForms)

    I miss the data form feature available in previous versions of Excel and would like to see it restored in Excel for Mac. Note that the Data Form feature is not the same as VBA UserForms. There's a separate suggestion if you want to vote for VBA UserForms.

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

    We’ll send you updates on this idea

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

    We will still accept votes on this suggestion. Please note that this suggestion is not for VBA UserForms. There’s a separate suggestion you can vote for if that’s most important to you.

    Some comments on the other suggestion indicate that clarification was needed, so I’ve updated the titles and description to be clearer.

    Steve K [MS Excel]

  5. Median function on Pivot Tables

    Please add a median function for Pivot Tables. It is mind boggling how Google Sheets has this capabilities but the much more powerful MS Excel does not

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

    We’ll send you updates on this idea

    6 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  6. Please Add Quick Analysis for Formatting

    Quick Analysis is available on Windows Excel 2016, but not Mac 2016 - please add.

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

    We’ll send you updates on this idea

    32 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. Allow exporting of Sharepoint lists

    It would be great if you could export a Sharepoint list to Excel for Mac. At present you have to use Excel on a PC - as I believe this requires some kind of ActiveX component.

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

    We’ll send you updates on this idea

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

    Thanks for the suggestion and the votes. We will continue to monitor the votes to help prioritize this along with other data connection requests. You may want to add a comment about connecting to SharePoint in the thread discussing PowerQuery.

    Steve K [MS Excel]

  8. Enable VBA Support for creating and editing UserForms (not the Data Form)

    In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.

    (March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)

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

    We’ll send you updates on this idea

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

    Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.

    I updated the title and description for this one and we’ll continue to monitor for comments and votes.

    Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality

    Steve K [MS Excel]

  9. Trend line to cell

    Function that references a chart and gives trendline parameters.

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

    We’ll send you updates on this idea

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow Ribbon AUTOHIDING in Mac Excel

    The idea is simple.

    IF AUTOHIDE RIBBON is turned on,

    THEN the Ribbon collapses into the TITLES OF THE RIBBON TABS automatically as your mouse moves off it. The Ribbon re-expands when your mouse hovers over the Title Tabs that the Ribbon collapsed into.

    The whole key to this is to have NO DELAY between when you hover on it and the Ribbon Autoexpands, and NO DELAY when you hover off it and the Ribbon Autocollapses.

    Please Don't even put in a 0.1ms delay for aesthetics. Default to 0.00ms delay, so that it SNAPS OPEN AND CLOSED. If you want…

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

    We’ll send you updates on this idea

    0 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  11. Just click individual cells to sum

    Excel 2011 had the possibility to sum individual cells by typing "=", and then just clicking on individual cells across the workbook that you want to sum, and "return" when done. This functionality is no longer available in Excel 2016 (you have to type "=sum(", then clicking on the individual cells while holding down the command key, "return". I would be happy if the old functionality is brought to Excel 2016.

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

    We’ll send you updates on this idea

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

    Update – thanks for the continued support of this feature. We’ll keep this request open for voting, but we’ll need to consider modifying the behavior slightly if it is to be brought back. For this suggestion, we would want to enable such behavior on both Mac and Windows, but we would need to do it in a way that does not cause problems for people who don’t want this behavior. For example, it may be that you would type =, then hold the CMD key as you click the cells to be added. Or perhaps you would need to enable a preference to get the old behavior. Please comment on these options or offer other ideas.

    We’ve been working to make Excel more consistent between Mac and Windows, as can be seen by the updates over the past several months, which have satisfied several thousand votes on this forum (multi-thread…

  12. Allow for personalised data labels in XY scatter plots

    In Excel 2016 for Mac there is no way to (easily) insert personalised labels to an XY scatter plot (like in the 2013 version for Windows, for instance...). In the Windows version (which I know best) there was the possibility to choose values for the labels that were not part of the XY plot itself but that option does not exist for the (2016) Mac version I can modify a few labels manually but with hundreds of point it is very complicated...
    I believe this feature is of utmost relevance!!

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

    We’ll send you updates on this idea

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

    Thanks for all the support and comments for this suggestion. We will continue to monitor this and prioritize it along with all the other suggestions. We’ve been working to make Excel more consistent between Mac and Windows, as can be seen by the updates over the past several months, which have satisfied several thousand votes on this forum (multi-thread calculation, PivotCharts, modern chart types, new functions, slicers for tables). We are listening to the suggestions, comments and votes, and we will continue to make improvements.

    Steve K [MS Excel]

  13. Make available the forecast tool since that is needed for several statistical analysis

    The forecast tool is fully available in the Windows version. Its absence actually limits various processes that are so important from financial and statistical point of view. Please look into this and try including it in the future.

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

    We’ll send you updates on this idea

    6 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  14. Printing vertical and horizontal worksheets

    When printing within a workbook that has both vertical and horizontal work sheets the page orientations all become vertical or horizontal rather than maintaining the original orientation.

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

    We’ll send you updates on this idea

    29 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  15. Bring back the "option-click" shortcut to insert column(s), row(s), or cell(s).

    Please reinstate the option+click shortcut or at least a way to customize for it. It makes my work much easier and is the only reason I've yet to upgrade. Thanks a lot!

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

    We’ll send you updates on this idea

    26 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  16. ALT key ribbon access

    The ability to utilize the ALT keys to access any button or command on the ribbon greatly improves productivity on the PC versions of excel. Implementing this feature on the Mac version of excel would be greatly appreciated.

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

    We’ll send you updates on this idea

    34 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add Find all in the Mac app

    IN the windows version you can click on the button find all when you are in a search box. This then shows you all cells which contain your search criteria in a list. Please add this feature to the Mac app, too!

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

    We’ll send you updates on this idea

    58 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  18. A better Name manager

    Dear all,
    What I love, please read this a need, is a better Name manager.
    The size of the list is way to small. If you work a lot with names, then you get longer names which are not easy to select.
    Also would like to see an easier way to replace, rename and exchange Names and references. When I make a Template sheet with names/reverences and want to make multiply copies bij code or manualy, its a crime to change or update the Name.

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

    We’ll send you updates on this idea

    25 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Support multi-row worksheet tabs, or vertical tabs (some way to see more sheet tabs at a time)

    The workbooks I work with often have 10+ tabs. This makes it very hard to navigate as you don't get a good overview.

    Why not introduce a feature in which the tab list can be viewed in a vertical mode, either to the right or the left side of the actual spreadsheet? This would make navigation much easier.

    (2015-11-05 Dan [MS] - recategorized and clarified idea title)

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

    We’ll send you updates on this idea

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

    Thanks for the suggestion and the votes about ways to make it easier to work with sheet tabs. We will continue to monitor the suggestion and prioritize it accordingly.

    Currently, you can CTRL+Click or right-click on the sheet navigation buttons to the left of the sheet tabs to see the complete list of sheets, which can help you quickly find and navigate to a desired sheet.

    Steve K [MS Excel]

  20. Provide way to avoid automagical field value reformatting when opening CSV files

    Theis is related to the leading zeroes one, but it is at least as bothersome that it tries to format as an excel data anything that looks like a date -- including values that are not dates. And the date formatting means you can't use Excel to open a CSV with dates, edit it, and re-save it without completely changing the way dates are formatted.

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

    Thanks for all the votes and comments for this suggestion. We are considering improvements to how Excel deals with reformatting (or not) as data is imported and entered from CSV and other sources. Your comments are very helpful.

    Steve K [MS Excel]

← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base