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 include the ability to modify the ribbon for Excel 2016 outright purchased Mac edition

    I have purchased the 2016 Mac edition of Office and have noticed that Microsoft has dropped the option to modify the ribbon for the outright purchased edition. This has caused me problems as I am unable to do the work required for my course on how to use Excel. I have attached what my Excel looks like compared to what is on you support sight (https://support.office.com/en-us/article/Customize-the-Ribbon-and-the-Quick-Access-Toolbar-in-Office-2016-for-Mac-26911d4c-4971-41cd-b606-5fbc0318f499), as it is only available for those that subscribe. Can you please add this feature for the outright purchased editions. I really do need it.

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

    We’ll send you updates on this idea

    2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  2. Bring back keyboard shortcut for align right!

    Am I missing something or are we no longer able to align right a group of cells using command+R? Looking at the list of shortcuts provided by Microsoft, "align right" is not there. This is very basic excel functionality. How could it have been removed??

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

    We’ll send you updates on this idea

    4 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  3. Close this file

    When you are done editing a file, you should be able to "close" the file and be returned to the default Excel Online screen which shows templates or recent files. This would prevent the locking issue we keep running into when Excel desktop continues to think you or another user is still logged into Excel online. Once the "locked" issue happens, it seems no combination of closing, restarting browser, or even rebooting machine will unlock a "locked for editing" situation. Only time seems to fix it at this point. A "close this file" button would remove all the uncertainty over…

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  4. Bring back the clipboard in version 2016 for mac

    Bring back the clipboard. It makes copying and pasting so much easier.

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

    We’ll send you updates on this idea

    11 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  5. support searching on Mac OS for unicode characters e.g. 0x000D carriage return

    support searching for unicode characters e.g. 0x000D carriage return.

    Many data sources use 0x0D for a carriage return.

    There are times where it needs to be replaced with something else, like a tab character.

    "Carriage return" is often present in imported text.
    Also it can be created by Option-Command-Enter (useful in making a list within a cell), or
    using the Apple Unicode Hex Input keyboard by holding option and typing the 4 digit hex code Option-000D

    When searching for this character in Excel 2011 (or Word 2011) for Mac, Microsoft instead finds the space character.

    In the attached file (the…

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

    We’ll send you updates on this idea

    2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  6. Fix missing Outline dialog box ("Summary rows below detail")

    The button 'Outline Dialog Box' is missing from Data tab > Outline group, hence the options for 'Summary rows below detail" etc. are unavailable (only in Excel fo Mac, confirmed by MS support). This is essential functionality to enable optimal compatibility with Windows version.

    9 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 →
  7. Bring back the "option-click" shortcut to insert column(s), row(s), or cell(s).

    Please reinstate the option+click shortcut or at least a way to customize for it. It makes my work much easier and is the only reason I've yet to upgrade. Thanks a lot!

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

    We’ll send you updates on this idea

    34 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  8. Pasting multiple cells into single cell (text)

    Excel for Mac text editing needs to be improved.

    It used to be possible to highlight one or more cells (e.g. A1:B1), then double-click a THIRD cell (e.g. C1) and paste the merged contexts of A1 & B1 into C1. Now that is no longer possible.

    This is a step backwards compared to Excel 2011, and both LibreOffice and Google Sheets also supports this functionality.

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  9. Revert the ungodly change to make the first key press open a cell instead of type into it

    Why did Excel 15.22 change to make the first key press open a cell instead of immediately typing into it? That hasn’t changed that since the 90s and is makes Excel incredibly frustrating to use.

    This behavior ONLY occurs on the Mac version and NOT the Windows version.

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

    We’ll send you updates on this idea

    4 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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 →
  11. Allow Users to Edit Ranges

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

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

    We’ll send you updates on this idea

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

    14 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 →
  13. 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]

  14. 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 →
  15. Show number of cells selected

    I would like the screen to somewhere show a readout of how many cells are selected. Whether I'm selecting a group of cells to either paste to, or copy from (or even just select to get a manual count, without copying or pasting), I'm amazed that a program as mature as Excel does not have the simple, basic functionality of showing how many cells are selected. Please implement this!

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  16. Find & Replace - Look In Dropdown Missing

    Please bring the Find & Replace Windows Functionality to the Mac version. You can't Find & Replace items in Formulas.

    8 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 →
  17. Make boxes like 'define name' box and define data for charts resizable.

    Not sure if this is editing Make the floating boxes like 'define name' and specify data for charts resizable. They are very difficult to use if names are longer than just a few characters. e.g. when defining a name from a different work book.

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

    We’ll send you updates on this idea

    2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  19. Edit cell shortcut should be one click of the "return/enter" key like Google Sheets - two clicks for next cell

    Edit cell should be one click of the "return/enter" key like Google Sheets - two clicks for next cell

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  20. Use enter rather than escape to accept a dropdown entry

    Currently in XL2016, if you're using a cell that has access to a dropdown list and, in the midst of typing an entry decide to use a selection from the dropdown list, to ACCEPT the entry you've chosen, you have to press ESCAPE, whilst the ENTER button results in an error message. That seems counter-intuitive, since everywher else escape means "no", "reject" or "leave", whilst enter/return is equivalent to "yes" or "accept". Please adjust this so it is more in accord with the User Interface.

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base