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. Please allow to disable the GetPivotData function as is the case in Excel for Windows

    Excel for Windows allows you to disable this function.
    Most users don't need the GetPivotData function and keep forgeting that the behavior of Pivot Table cells is different: you have to erase the function, carefully find out which column and row belong to the cell and manually type them in: Time wasted aplenty plus frustration

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

    We’ll send you updates on this idea

    4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Just as in Excel for Windows, the “Generate GetPivotData” option is a mode that you can turn on or off. It affects the behavior of what happens when you’re creating a formula and you select a cell in a PivotTable to create a reference to it. If you enable the Generate GetPivotData option, it will create a formula that will calculate the value of the PivotTable cell. If you disable the Generate GetPivotData option, it will create a plain reference to the cell.

    This option is not a setting for each PivotTable. It is an application setting that you can turn on or off at any time.

    To enable/disable the Generate GetPivotData option, select a cell in any PivotTable, then click PivotTable Analyze > Options, and then check or uncheck the option.

  2. Ability to reorder chart series

    In previous versions, you were able to rearrange the order in which series appeared in a chart or graph by reordering them in the "Select Data source" box. There doesn't appear to be a way to change the order of series without just recreating it in a different order.

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

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  3. Mac Excel 2016 VBA

    Mac Excel 2016 runs the Macros I wrote with 2011, but it won't refresh charts with the macro-altered data.

    42 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 →
  4. Introduce "Offline Mode" to Reduce Latency and Improve Performance

    Please create an "Offline Mode" feature for Office 365 to reduce overhead and improve performance when network connections are not required for one's basic Office app use.

    While using Excel (Office 365 for Mac) there is too much latency in the most simple tasks. Additionally, the application(s) attempt to make multiple network connections to various sites for subscription, sharepoint, and other apps connectivity. All of these actions reduce performance and create an overhead which impacts the users' experience (one only needs to google the feedback to date on the latest Office for Mac issues). Additionally, there are times when traveling…

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

    We’ll send you updates on this idea

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

    I’m marking this one as already supported, and closing the suggestion, because there has been significant work done since this suggestion was opened to improve the experience and performance related to offline and low bandwidth situations. There is no switch that puts Excel or Office into an offline mode, but you can work offline, such as in airplane mode. If you encounter specific issues, we recommend sending feedback via the Send-a-frown button within Excel.

  5. F11 shortcut for charts

    Cannot understand why this shortcut is not included.

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

    We’ll send you updates on this idea

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

    This is already supported, but you may need to change your Mac keyboard preferences so that F11 is not used by the Mac. Typically, pressing F11 will show the desktop on your Mac (it might be Fn+F11 depending on the state of your Fn key preference).

    To use F11 for inserting a chart sheet, go to your Mac preferences > Keyboard > Shortcuts, and make sure that no commands are using F11 as the shortcut. You can either disable the command or you can set it to a different key.

  6. Support SQL parameter queries

    Parameter Query support is broken. Almost all our queries are parameter queries.

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

    We’ll send you updates on this idea

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

    This is already supported. To use parameters in your SQL query, simply go to the properties for your connection, then click on the Definition tab. Then click Edit Query to open the query editor. In the editor, create your query and type ? where you want to use a parameter. When you click Return Data to go back to the properties dialog, the Parameters button should be enabled and you can click it to configure the parameters.

    Here’s an example:
    SELECT * FROM ContosoRetailDW.dbo.DimEmployee
    WHERE FirstName like ?
    OR EmployeeKey>?;

    When you look at the connection properties dialog and go to the Definition tab, you can click the Parameters button and set the parameters to refer to cells on the worksheet, as described here – https://support.office.com/article/customize-a-parameter-query-addf7cb7-ddf0-442f-a60c-cd7280e201bd#bm2

  7. Combination Charts

    There is a difference in trying to create COMBO charts on the Mac. In windows, you can change the CHART TYPE and select Combo. In Mac you are unable to do that and have to follow a convoluted means to add a second axis. The windows version is very intuitive, Mac not so much.

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

    We’ll send you updates on this idea

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

    Thanks for the suggestions and support for combo charts. You can create a wide variety of combo charts already on Mac, even if only a few are available on the menus.

    Here’s how:
    1. Create any chart that shows 2 series of data, such as one of the Line charts or combo charts.
    2. Click on the series that you want to change to a different type, so that the series is highlighted.
    3. Click the Change Chart Type button and pick a new chart type.

    The new type will only be applied to the selected series, so you end up with whatever combination you want.

    Some chart types can’t be used in Combo charts, and you’ll see that if you pick one that won’t work. We will take this feedback into consideration and perhaps make combo charts easier to discover.

    Thanks – Steve K [MS Excel]

  8. Command+Shift+[right arrow/down arrow] does not work in Excel 2016 for mac

    If I want to select all the rows from a certain row, I can no long use command+shift+ [down arrow] to select rest of the rows. the selection does not move at all. (The purpose is that I want to hide all the rows below a certain row)
    The same goes for column selection too.
    Can you please tell me how to do it in Excel for mac?

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

    We’ll send you updates on this idea

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

    Please find all the keyboard shortcuts here – https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd#bkmk_movescroll

    Note that in some cases, a key combination may be used by Mac OS for some purpose and therefore not work as expected in Excel. An example is when you have more than one keyboard input source added to your Mac, and then press CTRL+Space, it may switch input sources rather than selecting the entire column. You can turn off this shortcut in the Keyboard preferences > Shortcuts > Input Sources of your Mac so that the key combination will work as expected in Excel.

  9. Please add ALL of the functionality in Windows Excel and make Mac Excel to be the same


    1. In Windows Excell you can search for data in one tab or in all tabs in the workbook.

    In Mac Excel the functionality exists to search for the positioned to tab only.

    To search all, user will have to select each tab and search on that tab.

    If you have 255 tabs, you have to repeat that search 255 times.

    That is an inconsistent functionality.


    1. In Windows Excel, user can utilise keyboard to toggle between several open workbooks. In Mac excel, user cannot do same.

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

    We’ll send you updates on this idea

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

    Thanks for posting this suggestion. This request is already supported in Excel for Mac. You can search the workbook and if you click Next/Previous in the search field, it will take you to the sheets where the search result is found. You can also go to Edit > Find > Find…, and choose the option to find “Within” the workbook or the sheet.

    With regard to switching between open workbooks, you can press CMD + ` (the key above the TAB key on US keyboard). This switches between windows in Excel.

    Steve K [Microsoft Excel]

  10. Excel QueryTable does not work on Excel for Mac in Version 16.9.

    Excel QueryTable does not work on Excel for Mac in Version 16.9.
    See example from Microsoft here: https://msdn.microsoft.com/en-us/library/office/aa203721(v=office.11).aspx
    Section "Using a Static Web Query" describes a way to get data from a webserver.
    If you Change the used link from http://quote.money.cnn.com/quote/quote?symbols=msft
    to https://go.microsoft.com/fwlink/?linkid=859725
    the example loads a web table and displays it in a Excel worksheet.
    This example does not work on Mac with Excel Version 16.9. With Version 15.X on Excel the query executes successfully like on Windows.
    Here is the Code snippet for reproducing the bug:

    Sub RunWebQuery()
    With ActiveSheet.QueryTables.Add(Connection:= _

      &quot;URL;<a rel="nofollow noreferrer" href="https://go.microsoft.com/fwlink/?linkid=859725&quot;">https://go.microsoft.com/fwlink/?linkid=859725&quot;</a>, _
    
    Destination:=Range(&quot;a1&quot;))

    .BackgroundQuery…

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

    We’ll send you updates on this idea

    already supported  ·  13 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  11. Chart titles linked to spreadsheet cells

    In the Excel for Mac 2011 version you could link a chart title to a spreadsheet cell. Chart title would update if content of spreadsheet changed. While this still works in existing files you cannot link chart titles in Excel for Mac 2016 to spreadsheet cells. – Pls enable again. Data input field is grayed out…

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

    We’ll send you updates on this idea

    3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  12. Please add a Print icon to the Excel Quick Access toolbar!

    It would be a lot more efficient if there was a simple Printer icon in the Quick access toolbar of Excel.

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

    We’ll send you updates on this idea

    2 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  13. Make it so that anowner of a Mac and a PC can have the app on both machines with one license.

    I use both the Mac(mainly) and sometimes Windows 10 PC. I would like to use Excel on both machines with one license.

    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 →
  14. Make Formulas EASIER TO READ with Visual Links!

    When I double click a cell, and get a formula, ex) =M1+M2, If my CURSOR HOVERS over any one of the boxes referenced for a split second or longer, the reference in question should appear visually as a COLOURED LINE CONNECTING THE BOX BEING EDITED TO THE BOX BEING REFERENCED.

    So if I'm like, Hmmm which box is M2? And I don't want to go through the labourious process of finding M2 in a forest of cells, the cell I'm editing will magically have a line in the same colour as the M2 reference within the cell appear, which connects…

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    This is already supported. When you have a cell that contains a formula, you can click on the cell, then on the Formulas Ribbon, click “Trace Precedents” or “Trace Dependents.”

    Excel will draw arrows for you to the cells that contribute to the cell value, or that it affects, depending on which button you click

    Hope that helps,
    Dan [MS]

  15. Excel for Mac 2016 lots of bugs

    Need the ability to turn off Glide/Cell animation.

    There is a glitch in the Formula Bar when changing formulas (cursor position off when clicking)
    The "transpose" in paste special has been removed.
    You can no longer paste from one excel file into the cell of another file with a formula already in there. 

    4 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 →
  16. Bring back 30 years of Keyboard Shortcuts

    Keyboard shortcuts remained fairly standard from Excel's earliest days (I started using it with version 2.2a, don't know if they go back further) until Excel 2001 when somethings like, for example command-b was moved to bold text instead of clear text, but those changes were remapped onto the control key for those of us that had been using them for a long time.

    Now they have mapped BOTH to bold, and removed the keyboard shortcut for clear altogether. Likewise fill down no longer has a keyboard shortcut.

    I was excited to hear that keyboard customization was returning, but neither of…

    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 →

    The clear text (clear contents) command can be assigned to a key combination. Just go to Tools > Customize Keyboard, click on the Home Tab category, and select the “Contents” command.

    For Fill Down, it is assigned to CMD+D and CTRL+D (same as Excel 2011). You can also assign a custom key combination by choosing the “Down” command in the Customize Keyboard dialog in the Home Tab category.

  17. Keyboard shortcut keys Command and Ctrl should not be used interchangeably

    The keyboard shortcuts in Mac does not necessarily tie with the Command key. Most shortcuts work with Command key, but some works with the control key. For eg. the filter shortcut works with Ctrl + shift + L which is the same as in Windows. If Command is the equivalent of Ctrl in Mac, it should be applied across.

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    Thanks for your valuable input. You may find a list of shortcut supported in Mac Excel here: https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f#PickTab=macOS

    In Mac Excel most command we support both cmd and ctrl, with a few exceptions. The purpose of keeping some shortcuts not aligned between Mac and Win32 Excel (like the filter shortcut you mentioned) is to have backward compatibility, so people with experience using prior versions of Mac Excel may find it less confusing when using these shortcuts.

    Please let us know if you have further questions regarding this topic.

    Thanks!

  18. Column and row numbers invisible when I use Mac Mojave "Dark" mode

    Column and row numbers invisible when I use Mac Mojave "Dark" mode.

    Excel v16.20
    macOs Mojave Version 10.14.2 (18C54)
    MacBook Pro (Retina, 13-inch, Mid 2014)

    Screenshot here: https://twitter.com/scottcale/status/1077891096439476226?s=19

    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 →
  19. Sort by manual in the Pivot Table

    Ability to manually sort columns or rows is missing. This feature is available in other versions. See attached screenshot where the "Manual" feature should be. Thanks in advance!

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    This is already supported in Mac Excel. To manually sort items in a PivotTable (within their parent), you can:

    1. Select the “entire” item by moving to the left third of the cell containing the item label (the left- or top-most) until you see an arrow, and then click. This will select the item and it’s data.

    2. Move your mouse slightly right or down until it becomes a hand. You can now drag that item to the location where you want it to manually sort.

    Hope that helps,
    Dan [MS]

  20. Make file names longer than 31 characters

    Be able to save file names that are longer than 31 characters.
    Very annoying.

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Mac Excel already supports file names longer than 31 characters, and has for a long time. Perhaps you have a long path, or you are referring to sheet names?

    Cheers,
    Dan [MS]

← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base