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

      7 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    • Add PowerPivot to Mac excel

      is it possible to open an existing Windows Power Pivot Excel on Mac?

      I have already created a Power Pivot Excel report on Excel 2013.
      Now i want to use that report on mac.Is there any way to do so?

      1,404 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

        327 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
      • Restore data form functionality (different from VBA UserForms)

        I miss the data form feature available in previous versions of Excel and would like to see it restored in Excel for Mac. Note that the Data Form feature is not the same as VBA UserForms. There's a separate suggestion if you want to vote for VBA UserForms.

        198 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

          29 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

          We will still accept votes on this suggestion. Please note that this suggestion is not for VBA UserForms. There’s a separate suggestion you can vote for if that’s most important to you.

          Some comments on the other suggestion indicate that clarification was needed, so I’ve updated the titles and description to be clearer.

          Steve K [MS Excel]

        • Median function on Pivot Tables

          Please add a median function for Pivot Tables. It is mind boggling how Google Sheets has this capabilities but the much more powerful MS Excel does not

          122 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

            4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
          • Please Add Quick Analysis for Formatting

            Quick Analysis is available on Windows Excel 2016, but not Mac 2016 - please add.

            153 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

              25 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
            • Allow Ribbon AUTOHIDING in Mac Excel

              The idea is simple.

              IF AUTOHIDE RIBBON is turned on,

              THEN the Ribbon collapses into the TITLES OF THE RIBBON TABS automatically as your mouse moves off it. The Ribbon re-expands when your mouse hovers over the Title Tabs that the Ribbon collapsed into.

              The whole key to this is to have NO DELAY between when you hover on it and the Ribbon Autoexpands, and NO DELAY when you hover off it and the Ribbon Autocollapses.

              Please Don't even put in a 0.1ms delay for aesthetics. Default to 0.00ms delay, so that it SNAPS OPEN AND CLOSED. If you want…

              29 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

                0 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
              • Allow exporting of Sharepoint lists

                It would be great if you could export a Sharepoint list to Excel for Mac. At present you have to use Excel on a PC - as I believe this requires some kind of ActiveX component.

                77 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

                  6 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

                  Thanks for the suggestion and the votes. We will continue to monitor the votes to help prioritize this along with other data connection requests. You may want to add a comment about connecting to SharePoint in the thread discussing PowerQuery.

                  Steve K [MS Excel]

                • Trend line to cell

                  Function that references a chart and gives trendline parameters.

                  73 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

                    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                  • F11 shortcut for charts

                    Cannot understand why this shortcut is not included.

                    41 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

                      0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                    • Improve the Help

                      I am a former PC user now with the Mac version. Some of the graphics functions I have been doing for years on the PC (e.g., plot data on two vertical scales, put a title on the vertical scale), I cannot find on the Mac version. Surely there is a way. HELP in Excel in the Mac is NO HELP. (True also for WORD--HELP is NO HELP).

                      26 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                      • Enable VBA Support for creating and editing UserForms (not the Data Form)

                        In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.

                        (March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)

                        587 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

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

                          Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.

                          I updated the title and description for this one and we’ll continue to monitor for comments and votes.

                          Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality

                          Steve K [MS Excel]

                        • Allow for personalised data labels in XY scatter plots

                          In Excel 2016 for Mac there is no way to (easily) insert personalised labels to an XY scatter plot (like in the 2013 version for Windows, for instance...). In the Windows version (which I know best) there was the possibility to choose values for the labels that were not part of the XY plot itself but that option does not exist for the (2016) Mac version I can modify a few labels manually but with hundreds of point it is very complicated...
                          I believe this feature is of utmost relevance!!

                          140 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

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

                            Thanks for all the support and comments for this suggestion. We will continue to monitor this and prioritize it along with all the other suggestions. We’ve been working to make Excel more consistent between Mac and Windows, as can be seen by the updates over the past several months, which have satisfied several thousand votes on this forum (multi-thread calculation, PivotCharts, modern chart types, new functions, slicers for tables). We are listening to the suggestions, comments and votes, and we will continue to make improvements.

                            Steve K [MS Excel]

                          • Bring back the "option-click" shortcut to insert column(s), row(s), or cell(s).

                            Please reinstate the option+click shortcut or at least a way to customize for it. It makes my work much easier and is the only reason I've yet to upgrade. Thanks a lot!

                            38 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

                              24 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                            • Add the ability to export high quality graphs like vector images.

                              Add the ability to export high quality graphs like vector images and 300 dpi images. I'm running OSX 10.10.5 with Microsoft Excel for Mac 2011 Version 14.5.9. Options available in this software aren't good enough for high quality graphics.

                              36 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

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

                                Thanks for the feedback. We consider this in our next round of planning for a future release. In the meantime, please continue to vote on this feature idea.

                                Thanks,
                                Scott [MSFT]

                              • Make available the forecast tool since that is needed for several statistical analysis

                                The forecast tool is fully available in the Windows version. Its absence actually limits various processes that are so important from financial and statistical point of view. Please look into this and try including it in the future.

                                109 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

                                  Thanks for this suggestion. The FORECAST.ETS functions are available in version 16.x of Excel for Mac. We will continue to monitor this suggestion and prioritize it as appropriate with the other suggestions here.

                                  Steve K [MS Excel]

                                • For charts link a color to a series name so that we don't have to worry about changing its colour anymore.

                                  I've been waiting for this for ages. Why is the color scheme linked to a given order of series? We need to set once and for all a series name to set colour.

                                  30 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

                                    Thanks for the further details and example. We’ll definitely consider this in the context of our future planning. Please continue to vote on this idea.

                                    Thanks,
                                    Scott {MSFT]

                                  • Improve graph performance with plots containing >1000 datapoints in Excel 2016

                                    Excel 2016 chokes when handling plots containing many data points. Copying these plots from Excel to Word or Powerpoint causes issues in those applications as well.

                                    23 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

                                      0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Printing vertical and horizontal worksheets

                                      When printing within a workbook that has both vertical and horizontal work sheets the page orientations all become vertical or horizontal rather than maintaining the original orientation.

                                      70 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

                                        27 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Ability To Change Shape and Picture Names

                                        From what I can tell, it is impossible to change the reference name of a created Shape or a pasted-in picture. It appears you can only rename cell ranges....which seems very odd to me.

                                        Thanks for taking this into consideration!

                                        44 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

                                          1 comment  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →

                                          Thanks for the feedback. We’ll consider this in the next round of features. Please continue to vote on this feature request which will increase its likelihood of getting in the product.

                                          Thanks,
                                          Scott [MSFT]

                                        • Support multi-row worksheet tabs, or vertical tabs (some way to see more sheet tabs at a time)

                                          The workbooks I work with often have 10+ tabs. This makes it very hard to navigate as you don't get a good overview.

                                          Why not introduce a feature in which the tab list can be viewed in a vertical mode, either to the right or the left side of the actual spreadsheet? This would make navigation much easier.

                                          (2015-11-05 Dan [MS] - recategorized and clarified idea title)

                                          56 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

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

                                            Thanks for the suggestion and the votes about ways to make it easier to work with sheet tabs. We will continue to monitor the suggestion and prioritize it accordingly.

                                            Currently, you can CTRL+Click or right-click on the sheet navigation buttons to the left of the sheet tabs to see the complete list of sheets, which can help you quickly find and navigate to a desired sheet.

                                            Steve K [MS Excel]

                                          ← Previous 1
                                          • Don't see your idea?

                                          Feedback and Knowledge Base