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. Add webdav support

    Hi,

    I recently discovered that saving files to a webdav volume with Word, Excel or PowerPoint 2016 wouldn't work. I thought it was a bug and I opened a case at the support who explained to me that saving files to webdav volumes was not supported in Office for Mac 2016.

    I think it would be a great feature to re-introduce webdav support in Office 2016 as it is a very good way to access your files from a network drive that works anyware, while keeping your content hosted corporately.

    Best regards

    12 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  ·  Flag idea as inappropriate…  ·  Admin →
    • Multiple selection list boxes in 2016 (Mac) or even latest Win version

      Can we finally have multiple selection list boxes (easily) via data validation (if not at least via VBA User forms)? Also you can create a multiple selection list control that allows this, but the control can't auto dimension to each cell's size. (Say like a pop-up.

      Point: many people would like to be able to make a simple, multiple selection list box that can be easily copied to a column of cells (not just within an Excel form). It doesn't matter how it's done, as long as it's easy.

      11 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  ·  Flag idea as inappropriate…  ·  Admin →
      • Import XML Files

        Excel 2013 for PC has the ability to import XML. I'm SHOCKED that a product 3 years ahead doesn't. Not asking for a lot here - just functional parity for Excel on the PC.

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

          It would be great if you can provide more detail about the scenarios that you’re trying to solve with XML in Excel, so that we have a better understanding of this suggestion.

          Steve K [MS Excel]

        • Calculator

          I miss the integrated calculator from Excel 2008 and 2011. My duties have been made more difficult because you of arcane reasons have removed this feature from Office 365. I ask you to reintroduce the calculator application.

          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  ·  Flag idea as inappropriate…  ·  Admin →
          • Condense the icon spacing on the Quick Access toolbar

            I understand that while Excel 2016 has been upgraded to allow customization of the Quick Access toolbar, the icon spacing only allows about half the number as Excel 2011. A couple of months ago I cancelled my Office365 subscription after discovering that the Quick Access toolbar couldn't be customized. I won't be a subscriber until I learn that this productivity problem is solved.

            6 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  ·  Flag idea as inappropriate…  ·  Admin →
            • Paste a PDF-File in an Excel-Sheet

              Paste a PDF-File in an Excel-Sheet with menu Paste/Text/Object like Office for Windows.

              3 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  ·  Flag idea as inappropriate…  ·  Admin →
              • 20 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  ·  Flag idea as inappropriate…  ·  Admin →
                • Make opening files from disk as fluid as opening from OneDrive

                  Opening from disk takes longer than opening from OneDrive

                  That's a really cheesy move to increase OneDrive usage, please stop it

                  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

                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Regression Data Must Be In Columns

                    Regression models generated from data in rows are incorrect. Additional independent variables are added with zeros for there parameters. The last two independent variables are populated incorrectly. To get a correct regression model solution I must arrange the data in columns.

                    Same thing happens with Excel 2015 for Windows. Data must be in columns. This was not the case with the previous release of Excel 2013.

                    It is a real pain to have copy and transpose the data into columns to get the correct regression model.

                    What will it take to get this fixed?

                    Donald Barar

                    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

                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • copy a table from Excel and paste it a Mail message keeping all original formats

                      with 2011 version I am obliged to copy a table from Excel and paste it to Word, then copy from Word to Mail, in order to keep all original formats. Very slow and frustrating procedure. I hope the 2016 Excel version allows direct copy/paste of a table from Excel to a Mail message with all its original formats.

                      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

                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Handoff

                        You should add handoff support for both word, excel, powerpoint and outlook on mac and iOS.

                        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  ·  Flag idea as inappropriate…  ·  Admin →
                        • Pivot table sort totals column

                          Include capability to sort pivot tables by Totals columns/rows. This has been in the Windows version since 2010 at least. Why not include this basic feature in the Mac version?

                          18 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  ·  Flag idea as inappropriate…  ·  Admin →
                          • GUI Query Builder

                            The lack of the GUI Query Builder makes Excel 2016 for Mac Useless for our organization.

                            14 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  ·  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.

                              312 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

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

                              • Keep graph format the same when scrolling to other data

                                When I scroll down to a next set of data to produce line graphs for several items, the format of lines and markers changes, which I do not want (the idea is to produce multiple graphs with identical formats). I can overcome this by copying the graph- paste special-format (onto this graph) before I start scrolling, but I have to do this again each time I re-open the excel file. Very annoying.

                                19 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                                • Asian fonts inconsistent in sheet name tabs on redraw

                                  There seems to be a problem with the display of Asian fonts.

                                  When I first type the names of the sheets, it works perfectly and displays with the expected font:
                                  http://i.imgur.com/AXxAqN5.png

                                  When I change something in one of the sheets, however, and the names of the sheets are redrawn, the font for the Japanese and Chinese characters becomes bolder and harder to read, while the Korean script simply doesn't display at all:
                                  http://i.imgur.com/wGHWQsl.png

                                  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  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Function highlighting in formula bar

                                    Additional to
                                    https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/9580005-adjust-font-size-of-formula-bar

                                    Syntax coloring / Highlighting would be of great use.

                                    One should be able to toggle different highlighting (applying a colored background to certain parts of the expression) modes for the function bar.

                                    For instance:
                                    – a mode that highlights the current function
                                    – a mode that highlights all functions in different colors

                                    7 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  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Adjust font size of formula bar

                                      I have been struggling with ultra-tiny characters in the formular bar when editing complex formulas. One should be able to increase the font size within the formular bar in order to better grasp complex formulas and color coding (colored brackets).

                                      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

                                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Just One opening/start Dialog And my Own Cloud service and one more thing...

                                        Hi,
                                        1.) When opening Excel, you get the nice, open/recent/new dialog, ( Okay, its is New, recent then Open ;p ) then f.e. you choose open, then you got two choices OneDrive and On My Mac. If we choose MyMac then it close the dialog and then wait, wait, it opens a new file browser. Why?, why not open the file browser in the dialog itself? Much more smooth and logical.
                                        2) Would be nice if we could add( or an API for developers to write other or our own cloud services at the top left icon.
                                        3) Please give…

                                        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  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Distribute Office 2016 apps via the Mac App Store

                                          Receiving updates would be easier avoiding the malfunctions of the AutoUpdate app.

                                          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

                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          Feedback and Knowledge Base