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.

How can we improve Excel for Mac?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Freeze Panes broken in 15.19.1

    Frozen rows and columns scroll into the unfrozen area at the top and left when scrolling to the top row or leftmost column. After scrolling into the frozen cells, clicking the the top or leftmost unfrozen cell selects multiple cells equal to the number of frozen rows and columns.

    39 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    30 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    This is fixed as of 15.20, which was released in May (so if you haven’t updated, please do!)

    Cheers,
    Dan [MS]


    older—————————————-

    Hi all,

    We know that this broke in 15.19.1, and we’ve got a fix that will be in 15.20.

    Sorry for the inconvenience. It should be that once you scroll down, so that the duplicated rows are no longer shown, they won’t be shown again.

    Cheers,
    Dan [MS]

  2. Fix Solver after update 15.19.1

    After the update 15.19.1 the picking problem is fixed. But now solver don't work anymore. When you try to solve a problem nothing happens.
    Please fix this!!

    24 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    19 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Several issues with Solver have been fixed since this suggestion was posted, so I am marking this post as completed. If specific issues are noticed, please post the details about what you are seeing. More detail is better, so that we can try to reproduce and investigate the issue.

    Steve K [MS Excel]

  3. 'Select all' in the address bar

    Command+A in the address bar or triple clicking on a cell doesn't select all the text in a cell any more! Can you please put that back? I have a lot of semi-repetitive labels that each need slight editing and the new update has made it hard! Thanks!

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  4. Fix navigation arrows for worksheet tabs in full screen view

    When using excel on a mac in full screen view the arrows that appear to the very left of the first tab name do not work. This is super frustrating when you are using workbooks with many tabs that overflow the width of the screen. Switching through them with keyboard shortcuts to get to a tab that is off screen is very tedious.
    This functionality returns in non-full screen views.

    47 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  5. Page Break Preview view

    Please implement the "Page Break Preview" view like in Excel 2016 (Windows Version)

    42 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    36 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →

    This request has been completed. You can now find the Page Break Preview button next to the Page Layout View button on both the ribbon and in the status bar. Thanks again to everyone who asked for and voted for this suggestion.

    Steve K [MS Excel]

  6. I would like to have the formula bar as a Mac user

    Please add the formula bar for Mac users to increase the font size

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    We have this functionality already – the formula bar exists on all versions of Excel.

    Cheers,
    Dan [MS]

  7. Proper compatibility with 2011, scaling and sizes all over the place

    Each time I open a 2011 file in 2016 the cell and page sizes are all wrong and previously well presented documents look terrible. Each time I open it I have to waste time resizing everything to work in 2016

    65 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thanks for all your comments and votes supporting this suggestion. There are some differences which have been introduced so that Excel for Mac can align closer with Excel for Windows, so in some cases you will need to adjust your documents. One reason for the differences is how Excel determines the column width in your spreadsheets, which you can read more about here – https://support.microsoft.com/en-us/help/214123/description-of-how-column-widths-are-determined-in-excel.

    Thanks – Steve K [MS Excel]

  8. Fix broken scrolling in Excel for Mac *** IN NORMAL VIEW *** (see other idea for Page Layout View)

    Vertical mouse scrolling in Excel is laggy and jumpy in Normal View.

    I've posted (and may others have posted) about this actress all of Microsoft's forms for months. This issue has existed since the first betas.

    Here are some links:

    https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/9194508-erratic-mouse-scrolling-in-excel-15-2-3

    https://answers.microsoft.com/en-us/mac/forum/macofficepreview-macexcel/excel-2016-on-mac-jumpy-scrolling/391412e8-6c18-4796-b757-3a6613995306?auth=1

    https://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/excel-2016-mac-jumpy-scrolling/22583584-7b3a-4817-b401-f7267868adb2

    Today's update, 15.15, did not fix this issue. I'm afraid we are still stuck on 2011 from a usability standpoint. This is awful.

    I've uploaded a video of 15.15 here: https://twitter.com/rxcs/status/654031164001247232

    215 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    184 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Update 2016-06-30:
    Hi all,

    I’m marking this idea as completed, as we’ve determined that scrolling in “Normal view” is working correctly on various monitor types/Mac hardware.

    Note 1: We do know that scrolling in Page Layout View (where you see page margins, like Word) is slower. If you are experiencing slow/laggy scrolling there, please go add your vote to this idea and *include a video if you can – that really helps us!*

    https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/15044469-scrolling-is-slow-laggy-in-page-layout-view-where

    Note 2: You can tell if you are in Page Layout or Normal View by clicking on the View Ribbon, and then checking the two left-most buttons. The view you are in will be “selected” there.

    Cheers,
    Dan [MS]

    =========

    Update 2016-04-13:
    We rolled out more scrolling fixes in 15.21, and we think this fixes most of the remaining issues of scrolling in Normal View. (At least internally for us, it seems to have fixed…

  9. default workbook

    Please tell us where (and how, if necessary) we can change the default workbook.

    If that is not currently accessible to users, please add it.

    I have tried to create my own default workbook in the Templates and Startup folders, both with and without a file extension, but all to no avail.

    Word allows us to create our own Normal.dotm in the Templates folder and that gets used for word defaults. Be nice if Excel did it in a similar way.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  10. Maintain copied data on the clipboard even if the "dancing ants" aren't shown around the copied range

    I understand that the clipboard can use A lot of memory, but It is sooo frustrating having to re copy everything because I accidently clicked in the wrong cell before pasting.

    22 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    The clipboard is now persistent in some cases where it would have been cleared in the past. For example, if you copy some cells, and then insert a new sheet, you can paste the copied cells. In the past, the clipboard would have been cleared when you inserted the new sheet.

  11. Introduce an equivalent to F2 on PC to edit and F4 to make cell references absolute

    Introduce a shortcut to make cell references absolute like F4 on PC version (F2 edit equivalent would be helpful too)

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    If a function key doesn’t work as you expect it to, press the FN key in addition to the function key. If you don’t want to press the FN key each time, you can change your Apple system preferences:

    Go to Apple > System Preferences > Keyboard.

    On the Keyboard tab, select the check box for Use all F1, F2, etc. as standard function keys.

    Cheers,
    Dan [MS]

  12. Navigation of Tabs - Use Ctrl+Tab to tab between Sheets

    Is it possible to use a simple key combination to switch tabs? Like <CMD><TAB> to switch between windows... Maybe make it an option to change the <CTRL><TAB> function which switches through worksheets. When I'm in a single worksheet I often want to <TAB> through the tabs!

    5 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  13. Include PivotCharts as a feature for Excel for Mac.

    This feature has been available for Windows users for years. I have Excel 2011 and just can't see the value of upgrading without this feature (as it is, I already have to use a Windows version of Excel to do data analysis).

    1,239 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

  14. Bring back a fully functional VBE (Visual Basic Editor for VBA)

    Please bring back the full editor capability of VBE to Mac Excel 2016, like we had in Mac Excel 2011. As it is, the "slimmed down" editing experience of VBA is more like a notepad experience than anything - making it basically impossible to
    * edit VBA from scratch,
    * get syntax highlighting
    * see a watch window
    * etc.

    (Note: this title and description updated by Dan [MS] on 10/19/2015)

    855 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    261 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Hi All – The Visual Basic Editor was greatly improved in an update several months ago. If you don’t have the latest version of Excel for Mac, please go to Help > Check for Updates and update to the latest version to check it out. Thanks for all your comments and support for this feature.

    If you notice issues as you are using the latest VBE, please let us know by clicking the smiley-face feedback button near the top-right of the Excel window.

    Steve K [MS Excel]

  15. Show scroll bars all the time

    I will appreciate the possibility to have the horizontal and vertical scroll bars show all the time

    21 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    20 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Greetings,

    We’ve fixed this issue as of 15.15, and scrollbar visibility should now be respected.

    Enjoy!
    Dan [MS]

  16. Bring back parentheses in Accounting number format

    Bring back parentheses for negatives in Accounting number format. These were lost in Excel Mac 2011. They're a common standard.

    21 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    17 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi everyone,
    This has been fixed for a while now, and the root cause was actually a change in OS X’s handling of number formats. If you update to OS X version 10.11 or higher, and a sufficiently recent version of Excel 2016 for Mac (15.10 or higher) you will see these restored.

    Julie – if you are unable to update your OS or version of Excel, you should be able to use the following custom format code to add parentheses to for negative formatting.
    #,##0_);(#,##0)

    Cheers,
    Dan [MS]

  17. 1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. Font smoothing

    Please enable the font smoothing on Mac Book pro (not retina display).
    The fonts look horrible on non-retina displays.
    Moreover, I read a lot of complaints about this missing feature.
    Thanks.

    211 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    88 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow Toolbar / Ribbon customization

    the possibility to customize the toolbar or ribbon and adding custom buttons that start macros is vital for a efficient workflow when processing big amount of data tables.

    92 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    42 comments  ·  Flag idea as inappropriate…  ·  Admin →

    June 16, 2016
    Great news, with Mac Excel 15.23 you can now customize the Quick Access Toolbar (QAT) and Ribbon. This version started rolling out on June 14th, so look for an update if you don’t have it already.

    https://support.microsoft.com/en-us/kb/3165798

    Cheers,
    Dan [MS]

    Oct 31, 2015———————
    Thanks for your feedback! Just a note to let you know that we’re building your suggestion now.

  20. 64-bit Version

    Please release a 64-bit version of Office 2016 for Mac. Please. I have to have a Windows partition on my Mac just so I can boot into Windows and use Office 2013 64-bit. The workbooks I encounter are often 800,000+ lines and nothing Microsoft could do would make me happier than releasing a 64-bit version of Office 2016 for Mac. Please.

    92 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all – this is a few months late, so many of you may already be aware, but the 64-bit version of Mac Office was released in Sept. 2016. Thanks for your support and keep talking on UserVoice. We are paying attention, despite the slow update on this issue.

    Thanks,
    Steve K
    Microsoft Excel

  • Don't see your idea?

Feedback and Knowledge Base