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. auto correct in a text box

    why doesn't auto correct work in text boxes???
    I use text boxes in my quote template and i always have to write everything out. i have created some of my own text replacement inside of the auto correct preference tab so i do not always have to type out common things i write. They will only work in a cell and not a text box.
    this is very annoying and also time consuming. e.g. si = Supply and install.

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  2. Touchbar "edit cell contents" shortcut

    Please put a "edit cell contents" touchbar button roughly where F2 used to be. Would save me hours. Much more useful than the current "Paste" button.

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

    5 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 →
  4. 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 →
  5. 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 →
  6. Bring back the clipboard in version 2016 for mac

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

    15 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 →
  7. 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 →
  8. 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!

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

    We’ll send you updates on this idea

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

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

  13. 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.

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

    We’ll send you updates on this idea

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

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

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

    We’ll send you updates on this idea

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

    7 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 →
  18. 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.

    1 vote
    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 →
  19. customize excel default settings, e.g. for charts

    hi! i want to suggest to you the implementation of a possibility to change excel default settings, e.g. for charts. i’ve talked to your friendly support team about one such example, but they couldn’t help me with something that’s not programmed.

    i’m a chemist. like million other natural scientists, students and experts, i work with lots of complex and diverse data, every day. while the modern versions of excel offer many great and even fancy features, customization possibilities have shriveld. the template feature performs badly and really is only useful if applied to the exact same data set-up.
    what is…

    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 →
  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