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. Allow edit mode in 'Change PivotTable date source' Location box

    In Excel for windows, when changing the datasource location for pivot tables, you can use F2 to switch to edit mode and move the cursor around the location box to type the datasource location.

    There doesn't appear to be an equivalent edit mode for this dialog box (and presumably others where F2 works in windows Excel) on Excel for Mac.

    This is infuriating - it is often much quicker just to amend the data source location by typing rather than selecting cells. The only solution I've found is to highlight all the text in the location box, paste it to…

    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 →
  2. get rid of the "Data connections have been disabled" error message that appears every time you import anything.

    get rid of the "Data connections have been disabled" error message that appears every time you import anything.

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

    We’ll send you updates on this idea

    6 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  3. Unable to insert pdf files as an objects

    Enabling insert pdf file as an object. Currently only word can be added as an object...

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

    We’ll send you updates on this idea

    3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  4. FIX THE STINKING FILE PATH RESTRICTION OF 255 CHARACTERS!!!!!!!!!!

    INCREASE OR ELIMINATE THE 255 CHARACTER LIMIT ON FILE PATHS.

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

    We’ll send you updates on this idea

    2 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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 →
  6. 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 →
  7. Horizontal scroll is not working.

    When I import a text file and want to select all of the columns as text the horizontal scroll feature does not work and I can only change what ever I can see in the window to text. I use the feature on a weekly basis. This makes excel 2016 unusable for me on a Mc.

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

    We’ll send you updates on this idea

    27 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    By setting your scroll bars to be always shown in your MacOS general settings, you are able to scroll horizontally in the text import wizard.

    We will prioritize this issue accordingly with other issues based on the votes and interest that we see here.

    Steve K [MS Excel]

  8. Bring back the "Paragraph" formatting feature for text boxes (previously available on the menubar)

    Excel for Mac 2011 previously included an option to edit features such as text alignment, indentation, line spacing, and other paragraph-related formatting features from the Format - Paragraph option on the menu bar.

    However, for some reason, this is missing completely from the menu bar on Excel 2016 for Mac. It is now only available when right-clicking inside a text box. Please see the following image for the menu:

    http://www.chapmancreativeworks.com/files/excel2016paragraphmenu.png

    The Paragraph menu items are not available from the new Format Shape - Text Options pane on the right-hand side of the screen, either. There are options for…

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

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow Users to Edit Ranges

    This function has existed in Excel for PC since 2007. Why doesn't it exist for Excel for Mac?

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

    We’ll send you updates on this idea

    8 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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 →
  11. Double clicking a cell with a formula to view the cells in use

    When I double click a cell with a formula in it in order to view which cells i've use in the formula, there is major lag in the highlighting of these cells if you must scroll horizontally to view them. I scroll several columns out of view to see the cells in use and I have to wait for SECONDS before the highlights appear. If you scroll around at all after the highlights appear, they disappear. This is extremely frustrating and wasn't a problem in the old version. This was instantaneous. Please let me know if this is a setting…

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  12. bullet items for words in a cell

    allow items in a cell to be buletted

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

    We’ll send you updates on this idea

    5 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. Excel Uses Incorrect Cursor On Mac

    Please make Excel use the proper carson on the Mac. Here is a video:

    https://gfycat.com/SadPettyKitten

    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 →
  14. Flip feature in Excel filter

    There is no way to flip the filter condition selected for a column.

    Ex. If I have selected 3 conditions for filter out of total 10 there is no easy way to select the remaining 7 without unchecking the 3 and then selecting the 7. It would be great if we can have a flip feature included

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

    Please bring back the drawing toolbar or at least bring back the select object tool. now when i need to delete 30 out of 100 photos. i have to select each object one by one pressing shift+cmd. that is time consuming and easy for errors.

    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  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  16. Number of Decimal Points

    The default way Excel displays numbers after the decimal point needs an update. Right now, here are the results of Excel default formatting settings. (the values in brackets are in different cells)

    A1 = [1.234]
    A2 = [1.234]
    A3 = [A1*A2] displays [1.522756]
    2X increase in values displayed post decimal!
    4 sig figs become 7 sig figs

    A1 = [2]
    A2 = [Log(A1)] displays 0.30103
    5X increase in values displayed post decimal!
    1 sig figs become 7 sig figs

    Excel is clearly just displaying all the digits it calculates. This is not the proper way to account for significant figures,…

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

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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 →
  18. Allow Excel for Mac to run .xll files

    There are many .xll add-ins that work under windows, but none of these can be run natively on Excel for Mac. Using a windows emulator is painful, buggy and sometimes slow.

    16 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 →
  19. It would be nice to be able to add a space after the text or ??? in a cell on AutoFit (kinda like indent) so the columns won't be so bunched

    Add and option to include spaces on the right when you AutoFit in VBA like you do to the left (indent) to keep the columns from getting so tight. I think it would make it a lot easier to read. Not so bunched up.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. Turn off partial column scrolling (bring back snap to grid scrolling)

    In previous versions of Excel, moving the sheet around in the window was done column by column, or row by row. With a MacBook Pro touchpad, I can move the sheet with two fingers, but instead of moving cell by cell, I keep losing half of a cell off the left side of the window. Drives me crazy.

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

    We’ll send you updates on this idea

    6 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base