Feedback by UserVoice

Excel for Mac

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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. Add scrolling arrows at bottom to allow easy viewing

    Some arrows on the scroll bars would be nice to navigate individual cells without using the mouse scroll or shift+mouse scroll to view Excel sheets.

    Becomes rather tedious working on large sheets and is quite clunky.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  3. SImple way to toggle OSX Excel keyboard shortcuts so that they mimic those in Excel Windows

    Add a simple Excel option toggle that allows OSX users to mimic keyboard shortcuts from Window (F2 = edit, Ctrl+z = undo etc etc).

    Many users tend to user windows Excel in a corporate environment and find it frustrating that their hard learned shortcuts don't work on OSX. Needs to be a simple way to turn on and off (c.f. the Lotus 123 navigation compatibility switch in advanced settings on Windows Excel)

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  4. Reinstate ability to temporarily evaluate part of a formula in the formula bar

    In all previous versions of Excel for Mac, it was possible, while building a complex formula in the formula bar, to temporarily evaluate part of the formula by highlighting it and then using Cmd-= (Command & <equal sign>). To return the highlighted expression to what it was before evaluating, you then used Cmd-. (Command & <period>).

    In Mac Excel 2016, the first part of this works fine, but the second part doesn't work at all - you are stuck with the evaluation, and there is no way to return to the expression that gave rise to it. In other words,…

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  5. Excel 15.16 crashes each time I want to save

    I updated to 15.16 this morning, and now I can't work any more; Excel 15.16 crashes each time I want to save. Me too, I'm back to excel 2011, so frustrating.......

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  6. Ability To Change Shape and Picture Names

    From what I can tell, it is impossible to change the reference name of a created Shape or a pasted-in picture. It appears you can only rename cell ranges....which seems very odd to me.

    Thanks for taking this into consideration!

    50 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →

    Sorry to hear your having trouble changing shape and picture names. If I understand the request correctly, this feature is supported. You can rename a shape or picture a few ways…

    1) Select the shape (or picture) and go to the “Name Box” on the upper left side of the screen (above the column label headers “A”, “B”,“C”…. and below the ribbon). The name box will have the default name of the shape (like “Rectangle 1”) but you can type over this default value to rename your shape.
    This article shows how to use the name box for cells, but it can also be used to change the name of a shape
    https://support.microsoft.com/office/4d0f13ac-53b7-422e-afd2-abd7ff379c64

    OR

    2) Select the shape (or picture) and go to the “Shape Format” ribbon and click the “Selection Pane” button. This will open a pane on the right side of your screen with all the shapes on…

  7. Open files with alternative extensions

    I'd like to be able to open files with arbitrary file extensions.

    Many files I have or work with are tsv files, but don't always have that extension, and it's not even an option to open them in Excel!

    26 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. Fix PageUp/Down Left/Right key functions that were broken by 15.16.0 Update

    If you are in the middle of a large spreadsheet, these keys apparently move the cursor off screen, but the display does NOT move. They seem to work OK if you start from the R1C1 cell, but not otherwise. It all worked fine before the 15.16.0 update on 11/10/15.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  10. Checkboxes double print when printing or save to pdf making them unreadable

    When adding checkboxes to a sheet, then trying to print that sheet, print to PDF or Save as PDF, the checkboxes appear "double printed" making it very difficult to tell their checked state on the printed version. This bug has existed since the early betas.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. Fix ODBC and/or JDBC Connectivity in Excel for Mac 2016

    Currently Excel for Mac 2016 fails to connect to our system using a JDBC connector provided by OpenLink. This could be brushed off, however Excel for Mac 2011 works perfectly on the same system.

    The connection is made and data is correctly imported using 2011, but not 2016 on the same system. It fails with the following pop-up error via 2016:

    [OpenLink][ODBC][JDBC Server]java.lang.NoClassDefFoundError: com/ibm/as400/access/AS400JDBCDriver

    This would appear to be an OpenLink or Java error, however this is consistently reproducible on the same system with 2016 and works fine on the same system with 2011 via the same file.

    14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  12. Toggle / Switch option under filtering

    If we have large number of data in table and we want to see data belongs to few filters and then rest of the data. Say I have data for 100 cities and wanted to see data of 30 cities first and then rest of 70 cities. In first filter action I can select 30 cities and can look for its data and for rest I can just use toggle option to select rest 70 and unselect earlier selection of 30.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    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. Make available the forecast tool since that is needed for several statistical analysis

    The forecast tool is fully available in the Windows version. Its absence actually limits various processes that are so important from financial and statistical point of view. Please look into this and try including it in the future.

    191 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    25 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  14. Saving file after crash and no internet connection

    After Excel for Mac crashes while the computer is not on an internet connection, it fails to verify that the software is authenticated and thus disables the 'save' function. This has been very problematic especially in areas without internet connection/ during exams!

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  15. Needed to fix copy paste the tables from excel to outlook

    Needed to fix copy paste the tables from excel to outlook without border issue

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add feature to list all functions and include all functions offered on PCs

    Add feature to list all functions and include all functions offered on PCs

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Grand totals at top of pivot table columns

    Scrolling to the bottom of a huge pivot can be prohibitive. Give us the option to show grand totals for columns as the zeroth row !!

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add real subdivisions for logarithmic plots!

    In college I've had so many lab assignments where we were required to submit a semilog or log-log plot that only spanned one or two decades, but still needed subdivision gridlines (e.g. gridlines at {10, 20, 30, 40, etc.}, not just at {10, 100}). I end up finding an image of graph paper with the subdivisions I need and just dragging that underneath the plot and moving and resizing it to match the plot. I don't have to explain how much a pain that is. It would be so much better if Excel could add these subdivision gridlines automatically!

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  19. A way to disable "Some files can contain viruses or otherwise be harmful to your computer" each time I click on a linked file

    If that notification could be disabled that would be great. I use excel a lot to keep a long list of powerpoints organized as we get them in med school and each one I click on I have to grant permissions for that file and then I also get the other pop-up about that it can contain viruses. I understand it's important to be there but I would really like a way to turn it off or a "do not ask me again"

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Improve Graph Drawing Performance

    When scrolling (e.g. with mousewheel) and a graph that was previously outside the view area moves into the view area there is a significant delay before the graph is drawn (1+ sec). If there are several graphs there is an even worse delay.

    The workbook is not complex and the same spreadsheet in Excel (for Mac) 2008 did not suffer such delays i.e. nothing to do with the volume of data or the spreadsheet - something to do with Excel 2016.

    I've not tried different styles or types of graph, mine are just simple line plots based in data in…

    111 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base