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. 1,734 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      708 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →

      Excel for Mac now has multi-threaded calculation, as of the release of version 16.9 on 18-Jan-2018. To update, go to Help > Check for updates. Thanks for all of your comments and support for this feature.

      As mentioned in earlier comments, if you encounter any issues, please send the details to us by clicking the smiley-face button in the top right corner of the Excel window.

      Thanks – Steve K [MS Excel]

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

        We’ll send you updates on this idea

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

        958 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          485 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 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
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            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]

          • Enable pictures or photos to be inserted into the header of an excel sheet

            Enable pictures or photos to be inserted into the header of an excel sheet

            712 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

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

              Thanks to all who made their voice heard on this one. In the July 11, 2017 update (version 15.36), you can insert images in headers and footers on Excel for Mac.

              Steve K [Microsoft Excel]

            • Modern Charts for Excel

              Make the Modern Charts (Treemap, Sunburst etc) that are available on the Windows version of Office also available on the Mac version

              327 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                67 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

                Hi All – the new version of Excel for Mac (version 16.x) includes the modern chart types. There are TreeMap, Sunburst, Waterfall, and Histogram charts now available. Office 365 subscribers also get Funnel and Map charts (as on Excel for Windows). There are some improvements coming for all these chart types in the next few months.

                To update to the latest version of Excel, go to the Help menu and click Check for Updates.

                Thanks – Steve K [MS Excel]

              • Flash Fill For Mac

                Flash Fill For Mac

                304 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  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]

                • Bring back REAL keyboard customization!

                  It is completely not true, that keyboard customization through OS X keyboard preferences really works. Tell me how to make a shortcut to fill cell with color: for instance CTRL+2? Or how to paste values (without any mid-steps)? Or even do something more advanced than copy/paste with my own combination of inputs.

                  The fact is that office 2016 for mac lacks this feature and this "workaround" is NOT a replacement. Please bring back the option that was SO USEFUL!

                  287 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    62 comments  ·  Editing  ·  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

                    215 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      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…

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

                        We’ll send you updates on this idea

                        88 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Support slicers for tables

                        Only pivot table slicers are supported in Excel 2016 for Mac

                        195 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          60 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

                          I’m happy to report that Slicers for tables are now supported in Excel for Mac. Just check for updates and make sure you have version 16.×. Timelines are coming soon for filtering date fields in PivotTables.

                          Thanks for all your votes.
                          Steve K [MS Excel]

                        • Add recent Excel Windows functions to Mac version

                          A bunch of great new functions just went into the Windows version of Excel: https://blogs.office.com/2016/02/23/6-new-excel-functions-that-simplify-your-formula-editing-experience/

                          Please add them to the Mac version ASAP!

                          172 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            37 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

                            Hi All – with the latest update to Excel for Mac (version 16.x), there are new functions, including IFS and SWITCH, to go along with CONCAT, TEXTJOIN, MAXIFS, and MINIFS. These new functions are available to Office 365 subscribers.

                            Thanks – Steve K [MS Excel]

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

                            • 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
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

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

                                Great news – as of Mac Excel 15.19.1 this should be fixed – the reference picker in Solver is back!

                                Thanks,
                                Dan [XL]

                              • 108 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

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

                                  Good news. This has been fixed and will be available in the 16.12 update. If you get monthly updates, you should be able to update in April. To get the update sooner, you can opt into the Insiders program by going to Help > Check for updates and opt to get the Fast Insider updates.

                                  Thanks – Steve K [MS Excel]

                                • 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
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

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

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

                                      • Excel for Mac (2016) is very unstable and I often loose work and have to restart.

                                        Unless Excel for Mac becomes stable, I will only use it on Windows and revert to other sw on the mac such as google docs, etc.

                                        67 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          22 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →

                                          We’ve been working on numerous fixes for specific crashes, and we monitor for crash reports so that we can continue to make improvements over the coming releases.

                                          Thanks – Steve K [MS Excel]

                                        • 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
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            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]

                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base