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. 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add Scope in Define name dialog

    Can we please get a option to change the scope in the define name dialog when you define a name in Mac Excel 2016. Like to change it to sheet sometimes, the only way to do it now is to type the sheet name before the name like 'sheet name'!namerange . I like to see that it is working the same as in all the other Excel versions (Win and Mac)

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  3. Resize columns in multiple sheets at the same time in the same workbook

    In Office 2016 Excel on Windows, when I select multiple sheets, then resize a column in one sheet, that change is applied to all of the other sheets in the workbook. This does not seem to work on Excel 2016 for Mac.

    20 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 →
  4. Add ribbon buttons and keyboard shortcuts for superscript and subsript

    Why is it so much harder to make text superscript or subscript in Excel, both for mac and windows?

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

    We’ll send you updates on this idea

    5 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  5. Make Office Mac simpler.

    I have used various incarnations of Office for years and now have Office 2011 on my Mac running El Capitan. While some of the additions, particularly those in the ribbons, may be useful to some people I'm sure that many could do without most of them. Ability to edit the menus and ribbons would be most useful.

    Some previous functions seem to have been removed completely, including some of the add-ins (Excel) and toolbars such as Drawing (Word). If they are still there I haven't been able to find them.

    I would dearly love to be able to go back…

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow for more than 7 nested IF() logical operators.

    This would be helpful for teaching and assigning letter grades since there are 12 options.

    12 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 →
  7. Dual Monitor Filtering and Scaling

    Using dual monitors the filter option doesn't work properly. When I use my workbook on the secondary screen and try to filter columns filter window displays for a split second on main screen and then disappears. I can't actually filter anything unless I use excel on my main screen which is annoying as I use the secondary (bigger) screen to view large excel files which is difficult on small screen.

    Another issue I have is that if I try to move the excel workbook from larger to smaller screen it doesn't scale down like other applications. It stays the same…

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  8. Cell with a cell (Sub-cell)

    Have the ability to create sub-cells that allow for calculations to appear as values within a cell in brackets: example1- cell: Sales-Less Sales discounts (value) and example2- cell: Confidence interval (1.96)

    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 →
  9. Excel 2016 Please return the "enable: all files" in the text import box so we can import files that have extensions other than .txt

    Excel 2011 had the option at the bottom to switch to "all files" when importing text files so that files that had extensions other than .txt would not be greyed out. This is now gone in Excel 2016 so it is impossible to import text files that have other file extensions unless you rename them (which is very impractical for me).

    Please put the option back! I want to be able to import .dat, .ici, .ocw and so on as I used to on Excel 2011.

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

    We’ll send you updates on this idea

    10 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  10. Scale to Fit

    In Excel 2011 and for Windows you used to be able to scale the spreadsheet when printing by setting the Scale to Fit option on the print menu to 1 page wide and leave the pages tall blank (or vice versa). This will no longer work, setting pages wide or pages tall to blank is no longer allowed, 1 tall or 1 wide is the minimum setting. To get this option to work you have to go to the File Page Setup window and set the scaling on the Page tab. This is clumsy and inconvenient. Please bring back the…

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

    We’ll send you updates on this idea

    1 comment  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  11. I need to be able to include an image/picture/graph -inside- a cell, as cell content and filetype.

    This I need so very often! And so great features would be possible.
    Just to name the most obvious, a sortable list, where one column is for representative images. It would be sortable by the other columns and resize the cells accordingly.

    I know, that pictures are linked with their left top pixel to the respective cell, but that is way too less to be feasible for all the necessary applications.

    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  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  12. Data Validation move after enter

    When an item is chosen form an incell dropdown list from data validation, the cell selection should move in accordance with the preference selection for move after enter. Selecting the item from the list should be the same as typing the value and pressing enter. In the current implementation on all platforms it is not. You need to select the item from the list and then select the next cell. If the selection were to move after the selection, it would make data entry much easier and faster, particularly in Excel on the iPad. (For Bob Greenblatt, former MVP)

    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 →
  13. Reapply Filter

    Add the reapply filter option as seen in the Windows version. If you filter on an item and change the cells value so it no longer meets the filter condition then the reapply action should refresh the filter results based on the current cell value and remove the recently changed cell from view.

    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 →
  14. Add the ability to export high quality graphs like vector images.

    Add the ability to export high quality graphs like vector images and 300 dpi images. I'm running OSX 10.10.5 with Microsoft Excel for Mac 2011 Version 14.5.9. Options available in this software aren't good enough for high quality graphics.

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. We consider this in our next round of planning for a future release. In the meantime, please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  15. Floating, reshapeable, self-customized command toolbars

    Along with Styles, the FLOATING, SELF-CUSTOMIZED TOOLBARS in Word and Excel were among their most valuable features. Performing the usual functions without immediate visual, local access to numerous commands--and, instead, having to go to fantastically time-and-energy wasting pull-down menus, or dreary, multiple tab accessed toolbars anchored at the top of the page--is pathetically absurd. (Just a few examples among maybe 100: in Excel the 4 command icons for Insert Rows and Columns, print area, wrap-text or not. In Word, the several icons for creating or deleting specific borders in tables for cells, columns, and rows.) It would be great to…

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Right Click mini tool bar missing

    Excel for Windows has a great feature of a mini tool bar when right clicking on a cell. This feature is missing from the Mac version.
    Please add this to future releases.

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

    We’ll send you updates on this idea

    7 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  17. Can't get PivotTable time grouping to work..

    In older versions of excel I can easily "group" a time column and summarize it by day, month, etc. In Excel 2016 I can no longer get this to work with any data sets so far. Grouping the data just results in a "dumb" group with no summarization features.

    I've found documentation of the "auto-grouping" feature for time in Excel, but this never seems to function or appear on my Mac....how can I replicate the legacy function??

    8 votes
    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 →
  18. Provide way to avoid automagical field value reformatting when opening CSV files

    Theis is related to the leading zeroes one, but it is at least as bothersome that it tries to format as an excel data anything that looks like a date -- including values that are not dates. And the date formatting means you can't use Excel to open a CSV with dates, edit it, and re-save it without completely changing the way dates are formatted.

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

    We’ll send you updates on this idea

    3 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for all the votes and comments for this suggestion. We are considering improvements to how Excel deals with reformatting (or not) as data is imported and entered from CSV and other sources. Your comments are very helpful.

    Steve K [MS Excel]

  19. Graph Select Data Y -Axis text entry field bad with long text in text box

    In the “Select Data” for a graph, if you are trying to edit an existing “ axis range which has a long text (i.e the range is longer than fits in the edit box) then it is difficult to move the text entry point/cursor to the part outside the edit box. Using the left and right cursor movement keys changes the selection range rather than moving the text entry cursor. the dialog is of fixed size so you cannot widen the dialog/lengthen the text entry box.

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

    Thanks for the great feedback. We’ll consider this for a future release.

    Thanks,
    Scott [MSFT]

  20. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thanks for the feedback. We’ll consider this in the next round of features. Please continue to vote on this feature request which will increase its likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

  • Don't see your idea?

Feedback and Knowledge Base