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. Navigating To The Next Worksheet After Editing A Worksheet Tab

    When double clicking in a worksheet tab and editing its name etc.., after pressing enter the user cannon press Control or Alt +Pg up or down and move to the next sheet. The user MUST click in the worksheet 1st before using the keyboard shortcut to navigate to the next worksheet. This is not correct behavior and seems to be a bug. Does not work like this in Office 2011 or the Windows version. Can you please fix? Thank you.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  2. Fix data entry

    I'm trying to enter the text "HSA" into an Excel cell. No matter what I do or how many times I type it, Excel changes it to "HAS". What the **** is wrong with you people!?

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

    We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

    This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.

  3. Please allow side by side window view in an excel workbook

    I am so used to being able to alt+tab between two windows in the same Excel workbook. This should be available in Office for Mac 365

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

    We’ll send you updates on this idea

    0 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  4. Bring back CMD-F shortcut for find/replace

    Please . . . bring back this shortcut! I use this frequently. It takes up valuable time to go about it the long way.

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

    We’ll send you updates on this idea

    3 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Since this request was about 2 different features, and the Waterfall chart is complete, I’m marking this suggestion as completed. If you were requesting the Forecast Sheet feature, please feel free to create a new suggestion and specify just that particular item so that we can get an accurate picture of the support for it.

    Steve K [MS Excel]

  6. The CONCAT Function explanation has an incorrect example.

    Example 3, a table of examples has =CONCAT(C2,",",B2) but the result shown is incorrect

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

    Thanks for letting us know, we updated the topic and are publishing it now. Should be live in a few hours (11/22/2016)

    Cheers,
    Dan [MS]

  7. Flash Fill For Mac

    Flash Fill For Mac

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

    We’ll send you updates on this idea

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

    Good news! Flash Fill is now available in Excel for Mac if you upgrade to version 16.13 or greater. To use it, you need to click the Flash Fill button or press CTRL+E, since it won’t happen automatically as it does in Excel for Windows.

    Thanks – Steve K [MS Excel]

  8. Fix the Broken Carat in the Formula Bar

    The formula bar in Excel is horrendously broken. The carat randomly skips around and you cannot highlight text properly which makes it impossible to accurately edit formulas. This is especially heinous with long formulas, however this occurs with formulas OF ANY LENGTH.

    Here is a video of this infuriating behavior:

    https://vimeo.com/165402559

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

    We’ll send you updates on this idea

    12 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Make VBA code designed in Excel 2013 (PC) compatable! Cannot run pivot chart code!

    Make the code that is designed on the PC work on the Mac. Spent a lot of time developing a workbook with code to automate building pivit tables and pivit charts. The pivot table code works. The pivot chart code bombs and am unable to find alternate code!

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

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  10. Fix click-drag to select cells in Mac

    I can't click-drag to select multiple cells with the mouse/trackpad. When trying to do so, it only selects the first cell I click. I can only select multiple cells with the keyboard. I am currently running version 15.25 (160719) - new install on a new Mac running OS X 10.11.6.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Tye,

    This issue only repros on Macs with the new Tracpad (or new MBP with force touch).

    We’ve fixed the issue in build 15.25 (160721) and later.

    Until you get that build (you may be able to update to it now), the immediate workaround is todo the following:

    1. Go to System preference→Track pad→
    2. Disable Force click and haptic feedback

    Cheers,
    Dan [MS]

  11. 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…)
    Sign in with: Facebook Google
    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]

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

    We’ll send you updates on this idea

    12 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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…)
    Sign in with: Facebook Google
    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]

  14. 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…)
    Sign in with: Facebook Google
    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]

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

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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…)
    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 →

    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]

  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. 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…)
    Sign in with: Facebook Google
    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.

  19. 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…)
    Sign in with: Facebook Google
    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

  20. Deselect Cells While Keeping Other Cells Selected

    I would like to be able to deselect cells without having to cancel my whole selection and start over again selecting cells in order to make sure I do not select the offending cell.

    Numbers for mac has this functionality. You can hold down the "Command" key to select non-contiguous cells and then if you make a mistake and want to deselect a cell, you just click on the offending cell while still holding down the "Command" key. I really would like to see this ability come to Excel.

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

    We’ll send you updates on this idea

    12 comments  ·  Flag idea as inappropriate…  ·  Admin →

    You can now deselect cells in Excel for Mac version 16.×. This is only for O365 subscribers. To update to version 16, go to the Help menu and choose Check for Updates.

    To deselect, you can CMD+Click on selected cells. CMD+Click again to reselect.

    Thanks – Steve K [MS Excel]

  • Don't see your idea?

Feedback and Knowledge Base