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

      We’ll send you updates on this idea

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

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

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

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

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

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

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

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

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

                            0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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 →
                            • 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

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

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

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

                                          We’ll send you updates on this idea

                                          15 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        1 3 Next →
                                        • Don't see your idea?

                                        Feedback and Knowledge Base