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. Support slicers for tables

    Only pivot table slicers are supported in Excel 2016 for Mac

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

    We’ll send you updates on this idea

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

    I’m happy to report that Slicers for tables are now supported in Excel for Mac. Just check for updates and make sure you have version 16.×. Timelines are coming soon for filtering date fields in PivotTables.

    Thanks for all your votes.
    Steve K [MS Excel]

  2. After upgrade to High Sierra Excel crashes when I try to change a cell

    Excel 15.39 and High Sierra. Changing a cell (whatever, for example a stupid =5000/2 to =(10000/2)/2 Excel crash. Please fix it as it become unuseful and very frustrating!

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

    We’ll send you updates on this idea

    134 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →

    For the specific crash described with version 15.39, we are not receiving reports of this exact scenario. We continually monitor for crash reports that are submitted at the time of the crash as well as by feedback sent from within Excel (the smiley face button near the top right corner of the Excel window). Other comments here mention a variety of crashes, but we need more detail, such as exact build/version numbers, and exact steps that lead to the problem.

    This topic is closed, but again, we continually monitor for crash issues and release fixes each month.

    The best way to report a crash is to submit the crash information when prompted by the Microsoft Error Reporting dialog that shows up after a crash.

    Steve K [MS Excel]

  3. Add Map Chart

    Something that already exist for Windows and it's not available in office 365 for Mac !!!!!

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

    We’ll send you updates on this idea

    5 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for suggesting and voting for this feature. As of version 16.9 (released in January 2018), Map charts have been supported in Excel for Mac for O365 subscribers, and they’ll be getting easier to use very soon.

    Currently, if you have geographic data that can be used on a Map chart, you can click on the Insert > Recommended Charts button and Excel will recommend a map chart to insert.

    In an update coming soon, we’ll be adding a “Map” chart button to the Insert tab of the ribbon, so it’s more obvious that you can insert a map chart.

    Thanks – Steve K [MS Excel]

  4. Allow switching between Light or Dark theme in Excel.

    With the new Mohave MacOS update, the dark theme setting has become global which now impacts MS Excel for mac. With the dark theme turned on the colour scheme on excel looks horrible and is very harsh on the eye because of massively contrasting colours. See ribbon screenshot attached, the colours stand out. If you have a sheet which has been colour coded to explain things, visually the sheet stands out and is very harsh on the eyes.

    There should be an option within Excel to switch back to the "Light" theme, but for people who like the dark theme,…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  5. 108 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Good news. This has been fixed and will be available in the 16.12 update. If you get monthly updates, you should be able to update in April. To get the update sooner, you can opt into the Insiders program by going to Help > Check for updates and opt to get the Fast Insider updates.

    Thanks – Steve K [MS Excel]

  6. Please give Mac users of Office 365 Excel the SWITCH function too

    I have an Office 365 subscription and it's infuriating that the SWITCH command which I can use on my PC will not work on my MacBook version (OF THE SAME SOFTWARE FROM THE SAME SUBSCRIPTION!).....Isn't it time you synchronised all versions of the software to give the same functionality to all users regardless of platform?

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

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. 1,734 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Excel for Mac now has multi-threaded calculation, as of the release of version 16.9 on 18-Jan-2018. To update, go to Help > Check for updates. Thanks for all of your comments and support for this feature.

    As mentioned in earlier comments, if you encounter any issues, please send the details to us by clicking the smiley-face button in the top right corner of the Excel window.

    Thanks – Steve K [MS Excel]

  8. Add recent Excel Windows functions to Mac version

    A bunch of great new functions just went into the Windows version of Excel: https://blogs.office.com/2016/02/23/6-new-excel-functions-that-simplify-your-formula-editing-experience/

    Please add them to the Mac version ASAP!

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

    We’ll send you updates on this idea

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

    Hi All – with the latest update to Excel for Mac (version 16.x), there are new functions, including IFS and SWITCH, to go along with CONCAT, TEXTJOIN, MAXIFS, and MINIFS. These new functions are available to Office 365 subscribers.

    Thanks – Steve K [MS Excel]

  9. Allow users to turn off cursor "glide" animation (cell selection animation)

    l find the silly animation that "glides" the cursor from cell to cell to be distracting. That's bad. But the fact that there is no way to turn it off is absolutely infuriating. Let me turn it off.

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

    We’ll send you updates on this idea

    489 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Good morning (5 April, 2016),

    I’m happy to be able to update that we’ve released an update for this issue in Mac Excel 15.21, which has rolled out to Office Insiders today and pending any blocking issues we find there should start rolling out to everyone in a week or so.

    In order to turn off this animation once you have the updated build, you’ll want to go to Excel > Preferences > Edit and uncheck the “Provide feedback with animation” checkbox.

    Hope that helps,
    Dan [MS]

    =========

    Greetings and happy Friday (2.26),

    Good news – based on the feedback here, we’re going to hook up all of the new animations – including this cursor glide animation – to a setting in Excel > Preferences so that you can turn them off.

    Cheers,
    Dan [MS]

  10. Excel for Mac (2016) is very unstable and I often loose work and have to restart.

    Unless Excel for Mac becomes stable, I will only use it on Windows and revert to other sw on the mac such as google docs, etc.

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

    We’ll send you updates on this idea

    26 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  11. Enable pictures or photos to be inserted into the header of an excel sheet

    Enable pictures or photos to be inserted into the header of an excel sheet

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

    We’ll send you updates on this idea

    321 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  12. Bring back a fully functional VBE (Visual Basic Editor for VBA)

    Please bring back the full editor capability of VBE to Mac Excel 2016, like we had in Mac Excel 2011. As it is, the "slimmed down" editing experience of VBA is more like a notepad experience than anything - making it basically impossible to
    * edit VBA from scratch,
    * get syntax highlighting
    * see a watch window
    * etc.

    (Note: this title and description updated by Dan [MS] on 10/19/2015)

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

    We’ll send you updates on this idea

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

    Hi All – The Visual Basic Editor was greatly improved in an update several months ago. If you don’t have the latest version of Excel for Mac, please go to Help > Check for Updates and update to the latest version to check it out. Thanks for all your comments and support for this feature.

    If you notice issues as you are using the latest VBE, please let us know by clicking the smiley-face feedback button near the top-right of the Excel window.

    Steve K [MS Excel]

  13. Bring back Relative References in Macro Recording

    In Mac XL 2011 You had ability to create Macros that made use of Relative References in a addition to absolute references. In the Excel Mac 2016 Answers forum this is vitally important.

    Any possibility of returning this to Excel Mac 2016

    [10/22/2015 - Dan [MS]: Added image to show where this feature used to exist in older versions of Mac XL]

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

    We’ll send you updates on this idea

    160 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  14. Customizable Ribbon Menu Item

    In my opinion, there are too many preset ribbon items, which makes finding the command/tools one needs more difficult and time consuming. Immediate access to some tools is essential. The Quick Access Toolbar attempts to provide this function, but let's face it, the QAT is relegated to a place of very low prominence and capacity. And besides, some tools do not currently function if placed in the QAT (e.g. Paste Values) and some tools are not available for the QAT (e.g. Format Painter).

    Would it be possible to have the capability of having a customizable Ribbon Menu in the same…

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

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  15. Modern Charts for Excel

    Make the Modern Charts (Treemap, Sunburst etc) that are available on the Windows version of Office also available on the Mac version

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

    We’ll send you updates on this idea

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

    Hi All – the new version of Excel for Mac (version 16.x) includes the modern chart types. There are TreeMap, Sunburst, Waterfall, and Histogram charts now available. Office 365 subscribers also get Funnel and Map charts (as on Excel for Windows). There are some improvements coming for all these chart types in the next few months.

    To update to the latest version of Excel, go to the Help menu and click Check for Updates.

    Thanks – Steve K [MS Excel]

  16. Fix broken scrolling in Excel for Mac *** IN NORMAL VIEW *** (see other idea for Page Layout View)

    Vertical mouse scrolling in Excel is laggy and jumpy in Normal View.

    I've posted (and may others have posted) about this actress all of Microsoft's forms for months. This issue has existed since the first betas.

    Here are some links:

    https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/9194508-erratic-mouse-scrolling-in-excel-15-2-3

    https://answers.microsoft.com/en-us/mac/forum/macofficepreview-macexcel/excel-2016-on-mac-jumpy-scrolling/391412e8-6c18-4796-b757-3a6613995306?auth=1

    https://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/excel-2016-mac-jumpy-scrolling/22583584-7b3a-4817-b401-f7267868adb2

    Today's update, 15.15, did not fix this issue. I'm afraid we are still stuck on 2011 from a usability standpoint. This is awful.

    I've uploaded a video of 15.15 here: https://twitter.com/rxcs/status/654031164001247232

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

    We’ll send you updates on this idea

    185 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Update 2016-06-30:
    Hi all,

    I’m marking this idea as completed, as we’ve determined that scrolling in “Normal view” is working correctly on various monitor types/Mac hardware.

    Note 1: We do know that scrolling in Page Layout View (where you see page margins, like Word) is slower. If you are experiencing slow/laggy scrolling there, please go add your vote to this idea and *include a video if you can – that really helps us!*

    https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/15044469-scrolling-is-slow-laggy-in-page-layout-view-where

    Note 2: You can tell if you are in Page Layout or Normal View by clicking on the View Ribbon, and then checking the two left-most buttons. The view you are in will be “selected” there.

    Cheers,
    Dan [MS]

    =========

    Update 2016-04-13:
    We rolled out more scrolling fixes in 15.21, and we think this fixes most of the remaining issues of scrolling in Normal View. (At least internally for us, it seems to have fixed…

  17. Bring back REAL keyboard customization!

    It is completely not true, that keyboard customization through OS X keyboard preferences really works. Tell me how to make a shortcut to fill cell with color: for instance CTRL+2? Or how to paste values (without any mid-steps)? Or even do something more advanced than copy/paste with my own combination of inputs.

    The fact is that office 2016 for mac lacks this feature and this "workaround" is NOT a replacement. Please bring back the option that was SO USEFUL!

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

    We’ll send you updates on this idea

    64 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  18. Font smoothing

    Please enable the font smoothing on Mac Book pro (not retina display).
    The fonts look horrible on non-retina displays.
    Moreover, I read a lot of complaints about this missing feature.
    Thanks.

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

    We’ll send you updates on this idea

    88 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Make the solver work! (Input boxes should use the reference/range picker)

    Fix the solver so that fields that take range references as inputs have the reference picker control (RefEdit), which you can click on and then select the range to use. Today, you have to manually type in the range, and it's super frustrating.

    [Note: Title and Description updated on 10/19/2015 by Dan [MS]. Original description follows:)
    just make it work!

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

    We’ll send you updates on this idea

    70 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    Great news – as of Mac Excel 15.19.1 this should be fixed – the reference picker in Solver is back!

    Thanks,
    Dan [XL]

  20. Support UTF-8 for .csv import/export

    UTF-8 is the dominant character encoding in the Western hemisphere.

    At present when importing and exporting .csv files UTF-8 is not supported and non-standard characters become garbled!

    This is a massive wtf!

    P.s. regex support in find and replace would also be super useful!

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

    We’ll send you updates on this idea

    11 comments  ·  Flag idea as inappropriate…  ·  Admin →

    = 2016-12-12 =
    Hi all,

    Just wanted to share the news that we’ve added support for UTF-8 encoded CSV files to Mac Excel.

    Once you install Excel 2016 build 15.29 or later (which hit’s the streets shortly), you should have a working UTF-8 CSV option as one of the file types (and of course, we load them too).

    Cheers,
    Dan [MS]

    PS – You may notice the option in Save As UTF-8 CSV in 15.28 as well. We had a couple bugs in it then, which is why we didn’t announce it. Please wait for 15.29 before using it.

    = 2015-11-26 =

    Thanks for the suggestion Matt. We’ll be taking a look at CSVs all up (there’s been a number of requests around them) and we’ll make sure we consider Mac as well. As always, to help us prioritize, keep the votes coming! We’ll be factoring those…

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

Feedback and Knowledge Base