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.

  • or
  1. Enable capability to create add-in menu via VBA (as with PC)

    In the PC version of Excel one can create an Add-In menu via a VBA module that executes when a workbook is opened and adds a ribbon tab that displays a drop-down box where the selections link to macros which implement custom-developed capabilities. Why hasn't this been done for the Mac?

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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]

  4. Customisable filter

    It would be great to customize the size of the filter box in excel. At present I can only manually resize it, and each time I reopen the filter, I have to resize it again. It would be great if the default opened to whatever size you made it the previous time. Also would be great if the text size could be enlarged.

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  5. Cell formats in Excel for Mac

    When modifying the format of a cell in Excel for MAC, one should be able to either save a custom format (currently it disappears when you shut Excel) or edit a default style or add a style to the drop down list. I have a date format I like and have to re-create if every time I want to apply it.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Desperately need to make Excel for Mac the same as Windows version

    Taking business classes that require me to bring my laptop to class and use my own computer to do assignments. It's inconvenient that I have to use public computers or buy a Windows computer simply to do homework. If you truly valued your customers, Mac and Excel need to be as compatible as it is on the Windows operating system.

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

    We’ll send you updates on this idea

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

    We have been working to make Excel for Mac closer to the Windows version, and we will continue to do so. It can’t all be done at once, so we use the votes on UserVoice to help us prioritize.

    You can see the completed features here: https://excel.uservoice.com/forums/304933-excel-for-mac/filters/top?status_id=1406092

    Since this suggestion is not asking for a specific feature, it doesn’t help us prioritize, so we are closing it.

    Please vote for the specific suggestions on the UserVoice site that are most important to you.

  7. Customization of status bar (show multiple aggregates - SUM, COUNT, MIN, MAX, etc) like Windows Excel

    In Excel for Windows the status bar can show multiple information of the selected cells (sum, count, min, max etc.), which is extremely useful. This feature would be nice to have in Excel for Mac as well.

    5 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 →
  8. Extend Support to VB.NET on Xamarin

    This will support cross-platform addins, native custom worksheet controls, an existing cross-platform IDE, and, especially, an easier migration for current VBA coders than moving to the javascript API.

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

    We’ll send you updates on this idea

    8 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  9. Conditional Formatting (Blink/Flash) when value is TRUE

    Hi.. Wouldn't be it great to when we apply any condition formatting to any cell or a row/column instead of having a still color we can make it flashing/blink color. This can easily allow the user to identify the records.
    Criteria for flashing/blinking
    1. Number of Blinks/Flash
    2. Recurrence Blink/Flash
    3. Customize blink or not to blink upon opening the workbook

    Regards, Faraz Shaikh

    8 votes
    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 →
  10. Allow the user to clear all unpinned documents from the start-up window

    This applies to all the programs in Office 2016 for Mac. Unlike the previous versions from 2011, in the newer and "improved" applications it is no longer possible to clean unpinned documents from the list that shows when Excel/Word/PowerPoint is launched. It's also impossible to clear the recent documents that show under File > Open Recent. This clearly reflects Microsoft's new and disrespectful stance on the privacy of their customers.

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

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  11. Insert Sheet Row As Default Instead of Insert Copied Cells

    When data is on the clipboard, clicking "Insert" in the Ribbon automatically inserts that data, again and again and again. I'd rather disable this "feature" or enable inserting blank rows/columns instead of the clipboard data.

    I often insert the data and then two or three blank rows after it, but this keeps on pasting the data on the clipboard. It's a huge pain.

    Let us customize how Insert works (Ribbon button).

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

    We’ll send you updates on this idea

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  13. Signature line needed in Excel 2016 for MAC

    I have several customers that would like to see the Signature line functionality that is available in the Windows version, also become available in the MAC version. This is needed for a variety of reasons, but the number 1 reason I hear, is so they can have employees 'sign off' on their timesheets, without having to print them or export to PDF. They have also called it 'Inking', where you can sign off with your fingertip.

    18 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 →
  14. support searching on Mac OS for unicode characters e.g. 0x000D carriage return

    support searching for unicode characters e.g. 0x000D carriage return.

    Many data sources use 0x0D for a carriage return.

    There are times where it needs to be replaced with something else, like a tab character.

    "Carriage return" is often present in imported text.
    Also it can be created by Option-Command-Enter (useful in making a list within a cell), or
    using the Apple Unicode Hex Input keyboard by holding option and typing the 4 digit hex code Option-000D

    When searching for this character in Excel 2011 (or Word 2011) for Mac, Microsoft instead finds the space character.

    In the attached file (the…

    2 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 →
  15. Ability to name and place icons on macros added to the Quick Access Toolbar

    When a macro is added to the QAT, it displays as a circle in the toolbar. Add another, you get another circle. Unless you memorize what you added and the order you added them, you don't know what you're selecting. The list for customizing the QAT shows them as <<No label>>. You can name them with the Rename option on gear at the bottom of the dialog, but they revert back to no label after you exit the dialog.

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

    We’ll send you updates on this idea

    3 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. Enable Basic Diagnostic Data button

    The diagnostics permission window popped up upon launch and I dutifully read that I could choose between BASIC and FULL permission from that app. So I clicked ok -- BAD IDEA! In the app (Preferences>Security & Privacy) THERE IS NO BUTTON FOR BASIC PERMISSION. It is now stuck on sharing full access which I did NOT want; apparently no way to change/deselect it. I tried online chat and they said all I could do was offer this suggestion. This is definitely not the outcome I was seeking. BAD CUSTOMER EXPERIENCE!

    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  ·  Product Setup and Activation  ·  Flag idea as inappropriate…  ·  Admin →
  17. Allow attaching symbols to quick-access toolbar buttons (as is the case in Excel for Windows)

    For many years I had a customized set of buttons in the toolbar at the top of Excel spreadsheets. Some of these were standardized commands (splitting the worksheet); others were macros I had created. These sped up my work significantly. I had hoped to use the Quick Access Toolbar in Excel for Mac 2016 to recreate the most important of these. I can do this, but they all have the same button symbol!! Could you allow me to replace the buttons with symbols, as I could in Excel for Mac 2011 and apparently could if I used Excel 2016…

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

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow users to define Programmable Hotkeys for any Simple or Advanced Functions!

    You don't need to break Excel's hotkeys to do this! You can keep your shortcut key TOTALLY INTACT!

    Here's how you do it: Give us programmable hotkeys, for example Option 1 - 9 Can be user-programmable hotkeys.

    For any given user, there are 10 involved tasked that they most commonly perform, for which there are no hotkeys.

    For example, for a user they might be:

    1) Drawing a box around a cell

    2) Converting a Number to a Percent

    3) Creating a line graph specifically out of two columns (which normally requires 2-3 clicks - the hotkey will enable the…

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

    We’ll send you updates on this idea

    1 comment  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  19. Fix the scatter plot bug where 60=6.0

    I have come across this strange bug/feature a few times in Excel, scratched my head and exported my data to Kaleidagraph in order to make a plot that's correct, but this time I drilled a bit deeper:

    https://www.youtube.com/watch?v=3tOO6dJx6v0

    It seems that if you make a scatter plot (perhaps other plots as well?) using data created with the function "indirect" Excel chooses "Custom" as the number format for the graph and the format "0.0" which for some inexplicable reason displays 60 as 6.0. I have found a workaround (shown in the video clip above), but surely Excel is not…

    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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  20. I guess you aren't reading the comments and suggestions or...

    ....you simply DON'T GIVE A **** about your customers who continue to suffer crashes out of NOWHERE!

    Autorecovery - not ONE single time has this alleged function worked for me when a crash occurs.

    Autosave - see above! Why have the feature if it simply creates a FALSE HOPE that it can assist when one of your frequent crashes occur on my computer.

    BEFORE you offer some egg head, dipshit comment like "you should just save your work frequently as you move along" I'll throw it back at you and say "WHY WOULD I NEED TO IF YOU WOULD…

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

    We’ll send you updates on this idea

    0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base