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 VBA GetFileName work in Mac. It works fine in Windows.

    There is no simple means of selecting a file name from a VBA macro on the Mac platform. The only workaround devised (as far as I know) is incredibly clumsy and does not allow use of the GetFileName or ChDir routines.

    16 votes
    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 →
  2. Unresponsiveness in Excel for Mac

    Using Excel for Mac (v16.9) on desktop from an Office 365 pkg (issues while working with local files - not online).

    Sporadic issues:
    1. Can't select a cell using a mouse (periodically) - forced to navigate via keyboard arrows
    2. Selected cells (when copying) won't un-select even after saving or double clicking in another cell
    3. Drag and drop doesn't always work - sometimes due to lag times
    4. Lag times in responsiveness (overall)

    I've read about these issues related to v15 and saw that they were reported as fixed in v15.20. Why am I still experiencing these issues? Could…

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

    We’ll send you updates on this idea

    5 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  3. Allow users to set the default format to use for cut and paste

    Currently if I paste data into Excel from the internet or another workbook, the default is to use the source format. If I set the preferences to display format options, I can then select an option to display the data in the destination format. I have to do this every time, but I ALWAYS want to display the data in the destination format - so I need to be able to reset the default to use destination format, but I cannot change this. You need to make the default format user-defined.

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

    We’ll send you updates on this idea

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add back the ability to select custom paper sizes

    This is a regression from previous versions of Excel for mac. When doing page layout, it is a requirement for many users to be able to specify the paper size, regardless of what is currently made available by the printer driver. This was possible in previous versions of Excel, but now, the Page Layout / Size menu does not have a Custom option.

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

    We’ll send you updates on this idea

    3 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow data connection between data tables

    In windows version the data connection is possible, but in OSX version not working.
    Pls add this feature in osx version too!

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

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  6. 15 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 →
  7. 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 →
  8. 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 →
  9. copy a table from Excel and paste it a Mail message keeping all original formats

    with 2011 version I am obliged to copy a table from Excel and paste it to Word, then copy from Word to Mail, in order to keep all original formats. Very slow and frustrating procedure. I hope the 2016 Excel version allows direct copy/paste of a table from Excel to a Mail message with all its original formats.

    15 votes
    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 →
  10. Add Excel Data Model for Mac users

    Allow mac users to work with Excel Data model.

    Now it is only avaiable for PC users.

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  11. power view and power maps for MacBook

    Why isn't power view and powermaps as a add in for Mac available?

    14 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 →
  12. Excel for Mac v15.23 scrolling still broken

    Just updated to v15.23 for Excel on Mac today hoping to see scrolling fixes, but nothing seems to have changed. When scrolling up in Page Layout view, the entire page above blanks out for several seconds before filling in the data on the page. Other Mac apps handle scrolling just fine and seamlessly show pages in real time as they are scrolled up/down. Excel on Mac still seems to not understand scrolling and showing data scrolling at same time!

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

    We’ll send you updates on this idea

    9 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  13. After upgrade to Office 365, "cut and paste" does not work correctly.

    In Excel 2011, if I cut or copied a cell to Clipboard and then inserted a row, I could paste the item in Clipboard into a new cell. With Office 365, if I cut or copy a cell and then do anything such as inserting a row, the Clipboard is erased. This is such a fundamental action in Excel - cutting and pasting - that the "improvement" should be undone. I'd like to know when this fix is accomplished. Thank you.

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

    We’ll send you updates on this idea

    26 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  14. watch window - to watch the value of cell in excel

    Can we please have a Watch Window where we can see / monitor when the value in the cell which is being watched is changed. This functionality is available in Excel for windows under Formula's Ribbon under Audit formula section

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Fix Comments in Excel

    The comment box in Excel is broken, it often results in Excel crashing.

    1) It's laggy
    2) It opens with the words "Microsoft Office". THIS IS SO BIZZARE WHEN YOU THINK ABOUT IT! Why not just leave the comment empty? There's no point in advertizing Microsoft Office IN the comment, when the comment feature is not as beautiful yet as the rest of the suit, and causes an otherwise wonderful program to CRASH rather often.

    A new comment should be empty, or PERHAPS have a greyed out phrase "enter comment here...", which dissapears the moment you click on the new…

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

    We’ll send you updates on this idea

    8 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Enable english formulas in Excel with any other predefined language

    I have been teaching Excel and it would make it a lot easier if same formulas and functions would work in everyones computers regardless of the language they have chosen for their own excel. The translations cannot be guessed, so at least there need to be translations available, e.g. in these web pages. So, that I could search for example for "VLOOKUP" and I could get it in any language I want.

    It could be preference where you could choose whether you want to write the formulas in your predefined language or in english.

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

    14 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. Remove all subtotals on pivot tables

    Add a checkbox for removing all subtotals on a Pivot Table like Windows Excel. It's frustrating to remove subtotals from each item individually.

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

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  20. Make it easier to find external links

    Make it easier to find external links, like the windows request, but please give us this before you give it the windows clan

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base