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. Make autosave work correctly. Also provide adequate help info.

    Autosave does not work correctly -- autosaved versions are corrupt
    and no warnings are issued
    (A) Make autosave work correctly
    (B) Issue some warning online that it is not working correctly
    (C) Existing online help from Microsoft does not even tell you the

      correct folder where the autosaved files reside -- causes
    
    big waste of user time trying to diagnose problem

    Excel for mac 2011 Version 14.6.9

    OS X El Capitan 10.11.6 (15G1004)

    The correct folder in which files are autosaved:
    /Users/username/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery
    (Online help from Microsoft is totally wrong on this, as are suggestions
    on many online…

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

    We’ll send you updates on this idea

    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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.

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

    We’ll send you updates on this idea

    37 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add Scope in Define name dialog

    Can we please get a option to change the scope in the define name dialog when you define a name in Mac Excel 2016. Like to change it to sheet sometimes, the only way to do it now is to type the sheet name before the name like 'sheet name'!namerange . I like to see that it is working the same as in all the other Excel versions (Win and Mac)

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  4. The Undo button should only effect the spreadsheet window it is at the top of. I have 2 spreadsheets open, I found hitti

    The Undo button should only effect the spreadsheet window it is at the top of. I have 2 spreadsheets open, I found clicking undo on one was actually changing the other. This is stupid.

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

    We’ll send you updates on this idea

    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  5. Cell with a cell (Sub-cell)

    Have the ability to create sub-cells that allow for calculations to appear as values within a cell in brackets: example1- cell: Sales-Less Sales discounts (value) and example2- cell: Confidence interval (1.96)

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  6. RemoveDuplicates in VBA not working properly

    When dealing with multiple columns, i.e.

    CODE: range.removeduplicates columns:=array(1,2)

    A prompt showed up and ask user whether or not delete duplicate values

    It causes problem because without confirming deletion, the code won't run correctly. and what make the whole thing worse is that the code finishes running before I had a chance to confirm the deletion.

    Please help

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

    We’ll send you updates on this idea

    4 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  7. Return features from Office 2010

    When copy and pasting, in Office 2010 you get a veriety of options when you right click, but in Excel 2016, it does not, you have to click on Paste Special and then choose from only 2 options! - Thos feature in excel 2010 is brilliant and gives so many useful options for paste special.
    In excel 2010, you can create your own personalised menu with shortcuts to the icons that you use most often... This I can not find how to do in 2016. It makes working in Excel so much easier and quicker.
    Unfortunately, I can not see…

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

    We’ll send you updates on this idea

    5 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  8. Pls remove the upgrade 'nag' ribbon from Office 2011

    Since the introduction of Office 2016 all of my Office apps give me an upgrade 'nag' ribbon on first opening.
    I tried 2016. It is terrible. Many apps are missing critical features that make them useless for my work.
    I don't need regular nags to harass me into updating to an inferior version.
    Please get rid of these annoying things please. I didn't pay this much for Office to be subjected to annoying in-app advertising.

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  9. Fix Numeric Keypad on Excel 2016 for Mac

    I love the NumPad.

    Who doesn’t? It’s the fastest way to enter numbers. It’s even been used to support specialised input methods.

    But I’m not loving the numerical keypad on Excel 2016.

    I currently use a Chinese Input software called Q9, which uses the 9 number keys on the NumPad as a method to input Chinese. On Excel 2016 for Mac, every time I hit a number key on the NumPad, Excel interprets it as me entering a number, even though I am just trying to use the NumPad to interact with my input software.

    European users are experiencing a…

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

    We’ll send you updates on this idea

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

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

  11. Costumize the background

    How about give the possibility to change the color of the background (under the sheet), instead the classic grey?

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  12. Fix https link resolution in Office

    The Office 2011 external-link-checking function needs either:
    - To be less restrictive with https links by resolving them even if the linked website does not present an Excel-readable SSL certificate (in my case, this is because the linked page redirects the browser to a login service).
    or
    - To offer the option of disabling the link checking function on Mac, as is already (partially?) possible on Windows: https://support.microsoft.com/en-us/kb/218153

    A Microsoft Communities feed describing this lack of support for https links on Office 2011 can be found here:
    http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/excel-2011-hyperlinks-not-working-error-unable-to/eac46a95-8fcf-43a1-8e69-4e8dc3da9461

    Thank you,
    Kurt

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  13. AppleScript to save as PDF not working

    This script no longer works.

    tell application "Microsoft Excel"

    save as active sheet filename "test.pdf" file format PDF file format with overwrite
    

    end tell

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

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  14. Fix the forms functions (combo boxes etc.) that were broken in the upgrade from version 17 to 18.

    In the upgrade from version 16.17 to version 16.18 of Excel, the operations available under the Developer tab were broken. The setup of operations like "Combo Box" works, but the process will not execute. This is a capability in Excel that I use literally every second day. I have solved my problem by downgrading to version 16.17, but anxiously await a patch that will restore their functionality.

    3 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. Please support Excel for Mac on the current plus 2 previous macOS operating systems

    https://support.office.com/article/upgrade-your-macos-to-access-new-office-365-for-mac-features-f6efc6b6-90f8-4e69-82dd-d0de32a111aa

    There is some indication that Office for Mac 2019 will only support the latest current release of macOS plus the previous operating system. This is a formal request from an Enterprise admin to have Microsoft provide support for the current macOS operating system plus the two previous operating systems.

    Apple has been absolutely horrendous in documenting and providing the appropriate management tools to deal with major restrictions they've been adding to macOS. This makes it much more difficult to deploy the latest macOS release on day 1. As an example, the majority of our users are still on macOS…

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  16. The next version for the Mac should compensate 2016 users

    Those people who have bought Excel 2016 for the Mac should be compensated for lack of functionality (VBA, UserForms etc) when the new version comes out in 2019. We should get a FREE upgrade and an assurance that these issues have been sorted.

    4 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 →
  17. 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  18. Is it possible to install Excel 2011 and Excel 2016?

    Is it possible to install Excel 2011 and Excel 2016? I was forced to upgrade to Office 2016 because Office 2011 is no longer supported. However, I have found Excel 2016 to be so buggy and unreliable that I need to go back to Excel 2011.

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. I need a way to insert multiple rows & columns in excel

    Please create a way to insert multiple rows & above or below other rows when I right click on a row. Also if you could do that for columns as well.

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base