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

    322 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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)

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

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

    163 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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 →
  5. 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]

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

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

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

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

    We’ll send you updates on this idea

    37 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →

    This issue has been fixed and the fix will be available in version 16.35 or greater. You can get the fix in the monthly update available in March 2020, or you can get it sooner by opting into the Insiders Program and getting the Fast updates. To opt into the Insiders Program, go to the help menu and choose Check for updates. Then click the Advanced button and opt into the program and make sure you choose Fast updates.

    Previously, orientation and paper size settings on individual worksheets were being overridden by the setting in the Print dialog. This meant that if you had 1 sheet to print in Portrait, and another in Landscape, you had to print them separately, otherwise they would both print in the same orientation. The settings were removed from the print dialog and now should be set on the Page Layout tab of the ribbon…

  9. 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 →
  10. Page Break Preview view

    Please implement the "Page Break Preview" view like in Excel 2016 (Windows Version)

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

    We’ll send you updates on this idea

    37 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →

    This request has been completed. You can now find the Page Break Preview button next to the Page Layout View button on both the ribbon and in the status bar. Thanks again to everyone who asked for and voted for this suggestion.

    Steve K [MS Excel]

  11. Fix Solver after update 15.19.1

    After the update 15.19.1 the picking problem is fixed. But now solver don't work anymore. When you try to solve a problem nothing happens.
    Please fix this!!

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

    We’ll send you updates on this idea

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

    Several issues with Solver have been fixed since this suggestion was posted, so I am marking this post as completed. If specific issues are noticed, please post the details about what you are seeing. More detail is better, so that we can try to reproduce and investigate the issue.

    Steve K [MS Excel]

  12. 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]

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

  14. Cursor not properly positioned when editing directly inside cell

    I found out that if you have longer texts (>20 chars) inside an Excel Cell and you try to edit them the more you get to the right of the text the more the cursor is drawn off to the left of the characters it is actually between. Cursor Position seems to be calculated wrong. I am using Standard Calibri Font. This problem occurs on all Excel Zoom-States except for 200%. Using a non Retina Mac with latest Yosemite.

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

    We’ll send you updates on this idea

    87 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all – this update is very long overdue, but I wanted to let you know that this issue has been fixed. The update was release in July 2016. You should now see that if you click into a long formula or text value in a cell or formula bar, the cursor shows up where you clicked.

    Thanks for supporting Excel and please keep sending your feedback and suggestions. I know it took too long to update this issue, but we are listening. If there are other issues you discussed in the comments here, you may want to move those comments to an open issue that is more relevant to what you’re seeing.

    Thanks,
    Steve K [MS Excel]

  15. Enable coauthoring (co-auth) between multiple users (don't lock files)

    (2016-03-01 Title updated for clarity by Dan [MS])

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

    We’ll send you updates on this idea

    7 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add the Find and Select button onto the Ribbon

    The Find and Select option is not available on the Ribbon make options like Replace difficult to find.

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

    We’ll send you updates on this idea

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

    This is now available in the 16.24 update, which you can get if you opt into the Insiders Program, by going to Help > Check for Updates (not available if you installed from the Mac App Store). If you don’t want to opt into the Insiders program, this will be released in mid-April 2019.

  17. Fix column width dialog box to accept units in points, not inches

    Dear Microsoft. How can I change column width measurements in Excel 2016 for Mac from inches back to characters or points, as in Excel for Windows?

    I recently started using Excel 2016 for Mac to test templates for sharing compatibility between the Windows and Mac platforms.

    After selecting one or multiple columns, and then right-clicking and selecting Column Width, one would normally enter points into the dialog box. But in Excel 2016 for Mac I am forced to enter inches instead of points. Ironically, when I grab a column border in the column heading, I am able to resize the…

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for requesting this update. This has been fixed and you should see the column width shown in characters and row height in pixels in the dialog. Please update to Excel for Mac version 15.34 or greater to see this.

  18. Maintain copied data on the clipboard even if the "dancing ants" aren't shown around the copied range

    I understand that the clipboard can use A lot of memory, but It is sooo frustrating having to re copy everything because I accidently clicked in the wrong cell before pasting.

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

    We’ll send you updates on this idea

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

    The clipboard is now persistent in some cases where it would have been cleared in the past. For example, if you copy some cells, and then insert a new sheet, you can paste the copied cells. In the past, the clipboard would have been cleared when you inserted the new sheet.

  19. Show scroll bars all the time

    I will appreciate the possibility to have the horizontal and vertical scroll bars show all the time

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

    We’ll send you updates on this idea

    21 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Greetings,

    We’ve fixed this issue as of 15.15, and scrollbar visibility should now be respected.

    Enjoy!
    Dan [MS]

  20. 'Select all' in the address bar

    Command+A in the address bar or triple clicking on a cell doesn't select all the text in a cell any more! Can you please put that back? I have a lot of semi-repetitive labels that each need slight editing and the new update has made it hard! Thanks!

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

    We’ll send you updates on this idea

    completed  ·  2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base