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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 319 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    63 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  2. "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.

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

    We’ll send you updates on this idea

    2 comments  ·  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?

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

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

    We’ll send you updates on this idea

    37 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]

  4. 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)

    1,280 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    334 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]

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

    40 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 →
  6. 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.

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

    We’ll send you updates on this idea

    24 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  7. Improve the Help

    I am a former PC user now with the Mac version. Some of the graphics functions I have been doing for years on the PC (e.g., plot data on two vertical scales, put a title on the vertical scale), I cannot find on the Mac version. Surely there is a way. HELP in Excel in the Mac is NO HELP. (True also for WORD--HELP is NO HELP).

    28 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 →
  8. 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!

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

    We’ll send you updates on this idea

    111 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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!

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

    We’ll send you updates on this idea

    34 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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.

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

    We’ll send you updates on this idea

    41 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add the ability to export high quality graphs like vector images.

    Add the ability to export high quality graphs like vector images and 300 dpi images. I'm running OSX 10.10.5 with Microsoft Excel for Mac 2011 Version 14.5.9. Options available in this software aren't good enough for high quality graphics.

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

    Thanks for the feedback. We consider this in our next round of planning for a future release. In the meantime, please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  12. For charts link a color to a series name so that we don't have to worry about changing its colour anymore.

    I've been waiting for this for ages. Why is the color scheme linked to a given order of series? We need to set once and for all a series name to set colour.

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

    Thanks for the further details and example. We’ll definitely consider this in the context of our future planning. Please continue to vote on this idea.

    Thanks,
    Scott {MSFT]

  13. Improve graph performance with plots containing >1000 datapoints in Excel 2016

    Excel 2016 chokes when handling plots containing many data points. Copying these plots from Excel to Word or Powerpoint causes issues in those applications as well.

    31 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 →
  14. Have Excel - and other Office programs - follow current OS X standards for menus and title bars

    In your info page for Office, you say:

    "Unmistakably Office, designed for Mac … combining the familiarity of Office and the unique Mac features you love."

    But Office 2016 seems just like Office 2011 by not updating some menu and title bar features to reflect current OS X standards. It took me a while to get used to these, but now that I have it's frustrating to expect them and find them missing. Two big ones:


    • Save/Duplicate/Save As… Shift-Cmd-S is now supposed to be "Duplicate" by default in OS X, not Save As. Instead, the Option key is used to…

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

    We’ll send you updates on this idea

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

    Thanks for the suggestion, comments and votes for following OS X standards for menus and title bars. Some aspects mentioned here have been addressed, such as switching windows within Excel by pressing CMD+` (key that has ~ on it). We will continue to monitor votes and comments to prioritize accordingly with other suggestions here.

    Steve K [MS Excel]

  15. Keep graph format the same when scrolling to other data

    When I scroll down to a next set of data to produce line graphs for several items, the format of lines and markers changes, which I do not want (the idea is to produce multiple graphs with identical formats). I can overcome this by copying the graph- paste special-format (onto this graph) before I start scrolling, but I have to do this again each time I re-open the excel file. Very annoying.

    19 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 →
  • Don't see your idea?

Feedback and Knowledge Base