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. Mac excel two finger touchpad right click is not working.

    Mac excel two-finger touchpad right-click is not working.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  2. Intermittent problem with "Rows to repeat at the top" under Page Setup

    I work on my Excel spreadsheets in Page Layout view and have being using the "rows to repeat at the top" command in Page Setup for years without any problem when using Office 2011. After switching to Office 365, I am now having intermittent problems with the cell reference on page 2 of a spreadsheet if I have used the "rows to repeat at the top" command. When I click on a cell on page 2, the cell reference intermittently goes out of sync with the cursor by the number of rows that I have repeated at the top of…

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

    Thanks for your feedback. This issue has been fixed and will be available in the next monthly release of Excel for Mac. Once you have version 16.30 or greater, you should no longer have this issue. If you want to get the fix sooner, you can opt into the Insiders program and choose the Fast updates. To do so, just go to Help > Check for Updates. Then check the box to join the Office Insider Program and choose Office Insider Fast. Then press Check for Updates and install version 16.30×.

  3. Bug: Print sets page layout to the same across all worksheets on Excel for Mac

    To reproduce the issue, setup two sheets with different page layout (e.g. fit to pages, orientation etc). Select both and press print, then press cancel. Both sheets will now have the same print layout. This seems like a bug because:


    • This is not expected behaviour as it directly contradicts the documentation for Excel for Mac (see link below)

    • Pressing print shouldn't change the design of the spreadsheet and destroy painstakingly setup per-sheet page layout settings that take a long time to fix after this bug has paved over them

    • The Windows version does not have this problem

    • It is highly…
    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    This issue has been fixed and the fix will be available in version 16.35 or greater. Go to the help menu and choose Check for 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 for each specific worksheet.

    Please send feedback by clicking the feedback button in Excel if you notice any issues with this or anything else in 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. 'Select Objects'

    How about giving the option 'select objects' for users to highlight which objects they want to delete? My only option on iMac is to press F5, special, then select objects which deletes all objects. Please address this issue as quickly as possible.

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

    We’ll send you updates on this idea

    1 comment  ·  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.

    To select objects, you can click the Find & Select button on the Home tab of the ribbon, and choose the Selection Pane… or Select Objects.

  6. Pls add draw or ink option on Excel for Mac

    I would like to use the draw or ink tool on Excel for Mac.

    1 vote
    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 →
  7. Fix cell selection misalignment (likely out of memory) issues on High Sierra

    I have High Sierra and Excel version 16.14.1. The issue I describe below has been there in Sierra, and prior versions of Excel - at least last 6 months.

    Basically, sometimes after just a few new entries, sometimes after multiple entries, I'm unable to select and enter data/edit the cell I want. The cursor lands on another cell, typically one or two above.

    The only way to recover is to quit Excel, not just close and reopen file. That's why I think it's a memory leak...

    The file is less then 200 rows with 15 columns. Most cells have a…

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

    We’ll send you updates on this idea

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

    Thanks for your feedback. Several issues have been fixed with regard to cell selection. Some have already been released and one fix will be available in the Oct. 2019 monthly release of Excel for Mac. Once you have version 16.30 or greater, you should no longer have an issue if you are using repeated rows at the top of your sheet and using Page Layout View. If you want to get the fix sooner, you can opt into the Insiders program and choose the Fast updates. To do so, just go to Help > Check for Updates. Then check the box to join the Office Insider Program and choose Office Insider Fast. Then press Check for Updates and install version 16.30×.

  8. Excel for Mac should have the new Stocks functionalty

    It would be great if Excel for Mac (Insiders) is able to have the new Stocks functionality currently used by Excel for PC (Insiders)

    This functonality is described in https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

    In respect of this particular capability, it would bring Excel for Mac more in line with Apple Numbers which currently offers something similar.

    Thank you for considering this addition.

    60 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 →
  9. 209 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Good news. In the next monthly update of Excel for Mac, when you open an XML file, it will be imported as a table. In addition to that, if you have more complex needs and you have access to Excel on Windows, you can set up a query using Power Query, and you can refresh the query in Excel for Mac. You can find more about Power Query in Excel for Mac here – https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840

    The XML import capability is included in Excel for Mac version 16.31 (191022) or greater. If you want to get version 16.31 sooner than waiting for the next monthly release, you can opt into the Insiders Program by going to Help > Check for Updates. Choose the Fast updates to get the update faster. You can opt out of the Insiders Program if you want to go back to the next regular monthly update cycle.

  10. ExportAsFixedFormat xlTypePDF

    the function ExportAsFixedFormat xlTypePDF does not print images, charts or graphs.

    For example

    Sub PrintReport()
    Dim sPath As String
    sPath = "/path/to/myreport.pdf"
    Sheet1.ExportAsFixedFormat xlTypePDF, sPath
    End Sub

    will produce a PDF file, but if the print range contains images ,graphs, etc. they will be omitted.

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

    We’ll send you updates on this idea

    5 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Relative hyperlinks broken for Office 365 Excel

    The newest two updates to Office 365 (16.9 & 16.10) broke the way that relative hyperlinks work in Excel for Mac.

    As an example, if you have documents located in a folder called "Documents" and try to create a relative path hyperlink "Documents/some document", Excel can no longer follow the hyperlink path, and returns "Cannot open the specified file"

    This does not happen on older versions of Excel for Mac, or on Excel for PC. This has created a huge problem in my office, where we have hundreds of Excel documents with thousands of PDF links connected this…

    8 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 →
  12. Enable Axis Format For New Chart Types in the Excel 2016 for Mac 16.9 Release

    In Excel 2016 for Mac, new chart types were introduced, including Histogram, Tree Map, Sunburst and Box and Whisker. When attempting to format the X & Y Axes, either the Format box appeared with no parameters, or no Format box shows at all. This is critical, core functionality and is needed ASAP, for example a 16.10 update. With my specific case, /i was trying to adjust Bin parameters on a Histogram, and the Format Axis box never appeared.

    91 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 →
  13. 26 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →

    This issue was fixed in 2018, so this status should have been updated much earlier than now, but the marching ants will go away if you take some other actions, including double-clicking to start editing a single cell, or typing in a cell.

    This change was made directly in response to feedback that we received in this forum and by using the Send-a-Frown button in Excel. We encourage you to send feedback about any issues or suggestions, because we actively take feedback into account when making updates to Excel.

  14. Bring back all the macro features lost in 2011 and 2016

    With 2011 and especially 2016 many of the vital functions in VBA recording and editing were lost making the writing of VBA macros impossible. User forms, debugging and relative referencing were three such features lost.

    I used VBA to add features not available in Excel. As a transcriber of old church records I enter a lot of pre 1900 dates. These must be in a special dd mmm yyyy format which used to be checked by macro. I also check other fields for CAPITALISATION and Proper Case. None of this is now possible.

    The advanced issue of a new version…

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

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Beginning with the release of version 16.x in early 2018, we have aligned the VBA capabilities of Excel on Mac and Windows to a much greater extent than in the past. Hopefully this has addressed all the needs of this suggestion.

    If there are specific issues that are not addressed, please update to the current version of Excel by going to Help > Check for Updates. If the issue persists, then please send feedback using the Send-a-frown button in the top corner of the app.

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

  16. 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    The IFS function is now available for O365 subscribers with version 16.×. The SWITCH function is also available in version 16.×. To update, go to the Help menu and choose Check for Updates.

    Thanks – Steve K [MS Excel]

  17. Add sun-burst chart

    cannot use Sun-burst chart with Excel 2016

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

    We’ll send you updates on this idea

    1 comment  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →

    Sunburst charts (also treemap, waterfall, and histogram charts) are now available in Excel for Mac version 16.×. To update, go to the Help menu and choose Check for Updates.

    For O365 subscribers, there are also Funnel charts and 2D Map Charts available with version 16.×.

    Thanks – Steve K [MS Excel]

  18. 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  ·  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]

  19. Give tree map on Mac excel

    Give new maps in excel on Mac application. this is unfair.

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

    We’ll send you updates on this idea

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

    Good news. The Tree Map chart is available in Excel for Mac v16. There are still some finishing touches to come in the coming months. Some formatting options are not yet available, but you can do the basics now.

    Steve K [MS Excel]

  20. Navigating To The Next Worksheet After Editing A Worksheet Tab

    When double clicking in a worksheet tab and editing its name etc.., after pressing enter the user cannon press Control or Alt +Pg up or down and move to the next sheet. The user MUST click in the worksheet 1st before using the keyboard shortcut to navigate to the next worksheet. This is not correct behavior and seems to be a bug. Does not work like this in Office 2011 or the Windows version. Can you please fix? Thank you.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5
  • Don't see your idea?

Feedback and Knowledge Base