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.

Take a look at the feedback that we are currently working on and what feedback we have already completed.

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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      28 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]

    • Bring back keyboard shortcut customization

      Believe it or not, what the vast majority of Mac users of Office are looking for is not compatibility with Windows versions of the software, though keeping the features up to date is nice. After having been able to customize keyboard shortcuts for (how many?) years, we are told that Mother Microsoft thinks its better for us to use Windows Control shortcuts that don't do the job we're used to being able to do. Why would you want to make the software _less_ useful?

      I believe this represents a small software development savings relative to the number of customers it…

      15 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

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

        217 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          164 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…

        • Cursor not properly positioned when editing directly inside cell

          I found out that if you have longer texts (>20 chars) inside an Excel Cell and you try to edit them the more you get to the right of the text the more the cursor is drawn off to the left of the characters it is actually between. Cursor Position seems to be calculated wrong. I am using Standard Calibri Font. This problem occurs on all Excel Zoom-States except for 200%. Using a non Retina Mac with latest Yosemite.

          95 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            57 comments  ·  Flag idea as inappropriate…  ·  Admin →

            Hi all – this update is very long overdue, but I wanted to let you know that this issue has been fixed. The update was release in July 2016. You should now see that if you click into a long formula or text value in a cell or formula bar, the cursor shows up where you clicked.

            Thanks for supporting Excel and please keep sending your feedback and suggestions. I know it took too long to update this issue, but we are listening. If there are other issues you discussed in the comments here, you may want to move those comments to an open issue that is more relevant to what you’re seeing.

            Thanks,
            Steve K [MS Excel]

          • Allow users to turn off cursor "glide" animation (cell selection animation)

            l find the silly animation that "glides" the cursor from cell to cell to be distracting. That's bad. But the fact that there is no way to turn it off is absolutely infuriating. Let me turn it off.

            959 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              459 comments  ·  Flag idea as inappropriate…  ·  Admin →

              Good morning (5 April, 2016),

              I’m happy to be able to update that we’ve released an update for this issue in Mac Excel 15.21, which has rolled out to Office Insiders today and pending any blocking issues we find there should start rolling out to everyone in a week or so.

              In order to turn off this animation once you have the updated build, you’ll want to go to Excel > Preferences > Edit and uncheck the “Provide feedback with animation” checkbox.

              Hope that helps,
              Dan [MS]

              =========

              Greetings and happy Friday (2.26),

              Good news – based on the feedback here, we’re going to hook up all of the new animations – including this cursor glide animation – to a setting in Excel > Preferences so that you can turn them off.

              Cheers,
              Dan [MS]

            • 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
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                16 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]

              • 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
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  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

                • 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
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    37 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • 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
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      19 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • 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
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                      • Make the solver work! (Input boxes should use the reference/range picker)

                        Fix the solver so that fields that take range references as inputs have the reference picker control (RefEdit), which you can click on and then select the range to use. Today, you have to manually type in the range, and it's super frustrating.

                        [Note: Title and Description updated on 10/19/2015 by Dan [MS]. Original description follows:)
                        just make it work!

                        123 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          70 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                        • Support UTF-8 for .csv import/export

                          UTF-8 is the dominant character encoding in the Western hemisphere.

                          At present when importing and exporting .csv files UTF-8 is not supported and non-standard characters become garbled!

                          This is a massive wtf!

                          P.s. regex support in find and replace would also be super useful!

                          137 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            10 comments  ·  Flag idea as inappropriate…  ·  Admin →

                            = 2016-12-12 =
                            Hi all,

                            Just wanted to share the news that we’ve added support for UTF-8 encoded CSV files to Mac Excel.

                            Once you install Excel 2016 build 15.29 or later (which hit’s the streets shortly), you should have a working UTF-8 CSV option as one of the file types (and of course, we load them too).

                            Cheers,
                            Dan [MS]

                            PS – You may notice the option in Save As UTF-8 CSV in 15.28 as well. We had a couple bugs in it then, which is why we didn’t announce it. Please wait for 15.29 before using it.

                            = 2015-11-26 =

                            Thanks for the suggestion Matt. We’ll be taking a look at CSVs all up (there’s been a number of requests around them) and we’ll make sure we consider Mac as well. As always, to help us prioritize, keep the votes coming! We’ll be factoring those…

                          • 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
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                            • Quick access toolbar

                              The quick access toolbar is only really useful when it is bespoke. We need the ability to add or remove icons in this toolbar.

                              32 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                11 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                Feb 26 – Even more good news – we’ve completed work on this feature and you can now add/remove commands from the QAT as of Mac Excel 15.19.1. Do note that the set of commands you can add/remove is still limited, but we’re working on enabling full customization, like in Windows Excel.

                                (older) Great news folks – we’ve started work on this feature.

                                Cheers,
                                Dan [MS]

                              • 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!

                                6 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  2 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
                                • No more warnings about saving as CSV, especially when I didn't change anything

                                  I don't know how many hundreds (thousands?) of times I've told Excel that, yes, I really truly do mean to save this file as a CSV. I recognize that not all users will understand that CSV doesn't do cool formulas or formatting, etc., but I do and I still want to do it. And I want to do it a lot. Please, give me a way to opt out of these useless warnings!

                                  9 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

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

                                    2016-09-07

                                    We’re done – you should no longer get a warning dialog about data loss when saving a file as CSV, as long as the file was originally opened as a CSV file.

                                    Instead, we’ve added a non-intrusive business bar (that you can ignore if you choose) that let’s you quickly Save As the file if you have made changes that are not savable in CSV; if you ignore it and just Save, we’ll just save out the CSV values as you’d expect.

                                    We actually rolled this out starting on August 22, 2016 with build 15.25 for O365 users. Later builds have this update as well of course.

                                    Thanks for participating in UserVoice – we definitely value your input. You can now use whatever votes you’d allocated for this idea for other ideas.

                                    Cheers,
                                    Dan [MS]

                                  • 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
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Application Errors  ·  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]

                                    • 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
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        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]

                                      • Support for right to left languages

                                        We are tired of waiting for a real multilingual Office package for Mac. Please bring right to left languages support to Office

                                        24 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          9 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                          Hi all,

                                          As of Mac Excel 15.20, we now support RTL languages – Hebrew and Arabic. We’ll also be adding Thai in the next several months.

                                          As such, I’m marking this as completed.

                                          Cheers,
                                          Dan [MS]

                                          ====older=====
                                          Great news – we’re working on this feature request!

                                          Cheers,
                                          Dan [MS]

                                        • 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
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          Feedback and Knowledge Base

                                          How it works

                                          • Create a user account if you want to add a new suggestion or vote on existing suggestions.
                                          • Select one of the feedback forums listed.
                                          • Check out the ideas others have suggested and vote on your favorites.
                                          • Be sure to search for your suggestion but if you can’t find something similar enough, you can submit your own.
                                          • Keep suggestions focused on a single idea per post and limited to 25 words or less.
                                          • When you post an idea to our forum, others will be able to subscribe to it and make comments.