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

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

    • Add a dot plot as native graph option. This is a simple graph that shows position of datapoint on a single axis for data visualization.

      Dot plots are simple graphs that show distribution of values along a single axis. This can be faked using a scatterplot, but the y-axis is unused (and people always ask what that axis is...) Programs like Minitab allow for this graph to help visualize the data without any statistical assumptions.

      2 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  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
      • Selecting a cell with Mouse doesn't always work

        I have a great deal of trouble with the mouse click in Excel (Version 15.22). I have to move the mouse out of the cell I'm working in, click on a cell far away from it several times, and then come back and try it again.

        This is never an issue with Excel (Version 14.6.4). I'd like to use the later version but it's too difficult to use with the cell selection issue.

        35 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

          We are working on a known issue where selection is not aligned correctly if you are using Page Layout View and you have some rows set to repeat on all pages. If you scroll down beyond page one, sometimes the selection becomes misaligned. If you are seeing problems in other scenarios, it would be helpful to provide a more detailed description of what you’re seeing and the steps that lead up to the issue.

          You can submit feedback including screen shots by clicking the Smiley face button near the top right corner of the Excel window. You could also ask a question on https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel, which may help determine exactly what steps cause the issue.

          Steve K [MS Excel]

        • Mac numeric keyboard changing from dot to comma

          Dear sir or madam,
          As soon as I upgraded to office 365 on my MAC, I have this really irritated problem:
          When I input numbers as accounting or currency in the sheet, I usually use the numeric keyboard (which is on the right side of the keyboard). Beforehand I use the dot (.) as the comma (,) in this numeric keyboard in the oud version excel (2011). But with the new excel 2016, the dot (.) appears to be the dot (.). So I have to use the comma key on the other side of the keyboard, which is near…

          2 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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
          • touch bar - highlighting

            In the touch bar for Mac make that the function highlight "remember" the last color, like in the ribbon. Specially because the usual bright yellow does not appear in the touch bar menu of colors! Same for font color in touch bar.
            This would make a lot easier and helpful to use the touch bar to format cells

            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

              1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
            • Bring back Relative References in Macro Recording

              In Mac XL 2011 You had ability to create Macros that made use of Relative References in a addition to absolute references. In the Excel Mac 2016 Answers forum this is vitally important.

              Any possibility of returning this to Excel Mac 2016

              [10/22/2015 - Dan [MS]: Added image to show where this feature used to exist in older versions of Mac XL]

              299 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

                125 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
              • Just click individual cells to sum

                Excel 2011 had the possibility to sum individual cells by typing "=", and then just clicking on individual cells across the workbook that you want to sum, and "return" when done. This functionality is no longer available in Excel 2016 (you have to type "=sum(", then clicking on the individual cells while holding down the command key, "return". I would be happy if the old functionality is brought to Excel 2016.

                290 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

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

                  Update – thanks for the continued support of this feature. We’ll keep this request open for voting, but we’ll need to consider modifying the behavior slightly if it is to be brought back. For this suggestion, we would want to enable such behavior on both Mac and Windows, but we would need to do it in a way that does not cause problems for people who don’t want this behavior. For example, it may be that you would type =, then hold the CMD key as you click the cells to be added. Or perhaps you would need to enable a preference to get the old behavior. Please comment on these options or offer other ideas.

                  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…

                • Make autosave work correctly. Also provide adequate help info.

                  Autosave does not work correctly -- autosaved versions are corrupt
                  and no warnings are issued
                  (A) Make autosave work correctly
                  (B) Issue some warning online that it is not working correctly
                  (C) Existing online help from Microsoft does not even tell you the
                  correct folder where the autosaved files reside -- causes
                  big waste of user time trying to diagnose problem

                  Excel for mac 2011 Version 14.6.9
                  OS X El Capitan 10.11.6 (15G1004)

                  The correct folder in which files are autosaved:
                  /Users/username/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery
                  (Online help from Microsoft is totally wrong on this, as are suggestions
                  on many online…

                  9 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

                    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                  • Text import Wizard

                    The font used in the text import wizard really needs to be changed. 1. The preview window is to small and the font used in the preview window is to small and should be like Helvetica or something so the text is much easier to read. The zero's wth slashes is awful. please fix this so it is as nice as the windows version. Thank you.

                    4 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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                    • 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!!

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

                      • Consolidate Multiple Data Sources in a Pivot Table

                        Allow users to aggregate data in a pivot table from multiple worksheets.

                        227 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

                          50 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

                          Hi all – we are evaluating this request, but we want to find the best solution for your data analysis needs. It would be helpful if you would describe what you are trying to accomplish with your data so we can understand whether there’s a better way than by using the PivotTable Wizard to consolidate multiple ranges.

                          Please add your comments to the suggestion in Excel.UserVoice.com.

                          Thanks – Steve K [MS Excel]

                        • Please add a function to insert .pdf documents into excel speadsheets

                          I'd like to be able to add embed a .pdf document in a spreadsheet, and view it as either an icon or a link to the embedded document.

                          Thanks.

                          75 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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.

                            111 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  ·  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]

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

                              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

                                24 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add ribbon buttons and keyboard shortcuts for superscript and subsript

                                Why is it so much harder to make text superscript or subscript in Excel, both for mac and windows?

                                16 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                • Pls remove the upgrade 'nag' ribbon from Office 2011

                                  Since the introduction of Office 2016 all of my Office apps give me an upgrade 'nag' ribbon on first opening.
                                  I tried 2016. It is terrible. Many apps are missing critical features that make them useless for my work.
                                  I don't need regular nags to harass me into updating to an inferior version.
                                  Please get rid of these annoying things please. I didn't pay this much for Office to be subjected to annoying in-app advertising.

                                  2 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Saving a file in new folder

                                    while saving the opened file through 'save as' option, it does not give option for 'new folder'

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

                                        7 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Bring VBA on Excel for Mac to parity with Excel for Windows

                                        Bring VBA on Excel for Mac to parity with Excel for Windows.
                                        Currently, there are too many missing VBA elements missing. It is a major problem for those of us with mixed environments. Many things that worked under Excel 2011 no longer work in 2016.

                                        Why is the not being addressed?

                                        46 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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                        • 31 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          Feedback and Knowledge Base