Feedback by UserVoice

Excel for Mac

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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.

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

    1,431 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thanks for all your votes and comments about enabling support for UserForms in Excel for Mac.

    With emphasis on enabling more and more capability using Office add-ins in Excel that will work across platforms, we don’t expect to add support for creating and modifying UserForms.

    Please see this article for more information about what you can do in Excel with Office add-ins.
    https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-overview

  2. HYPERLINK formula link to local file unreliable

    Bug: The hyperlink formula linking to a local file seems unreliable. there are two issues
    1. Even with "Confirm before opening other applications" preference disabled, clicking on a hyperlink cell seems to always ask for user confirmation with a warning.
    2. Sometimes Excel will "get in a mess" and after the warning has been accepted give a very generic error message of failure. Once this error has occurred, closing and re-opening spreadsheet or any other spreadsheet will suffer same problems and you need to exit Excel and re-run for t to start working again.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  3. Sort Out Scroll Bars

    Sort Out Scroll Bars. Version 15.14 sorted the "respect OSX scroll bar visibility setting", but they are still not initialising/positioning correctly. When visible all the time, often when you grab the vertical slider with the mouse, the worksheet will jump miles (and by that I mean a really really long way) from the current scroll position.

    One aspect of the bug has been fixed, but there are still major problems.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Opening and Saving Files...

    is not allowed in the 2016 Excel for Mac and I'm not sure what happened. Whenever I open an Excel file on my laptop, it always defaults to "15 (read-only) and gets really annoying when I have to open the file, save as "15" or "Copy of 15" just to save it, delete my old file and rename the new file. I can't even save properly named files as a name other than the names listed above. I've strongly considered making the switch to Apple Numbers instead of constantly dealing with how annoying this process has become. Please fix.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  5. Keep format the same when pasting an Excel graph into Word

    When I paste an Excel graph into a Word file (just copy-paste), the color of some of the lines and markers change. I would like to keep the format the same.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow two open spreadsheets to share a search term

    In my previous version of Excel (Excel for Mac 2011), if I had two different spreadsheets open at the same time, and typed something in the search box for one spreadsheet, when I finished that search, all I had to do was click anywhere in the second spreadsheet and my search string would magically appear in the search box in the second spreadsheet! I loved that & it saved me time. I didn't purposely set it up that way & don't know if it was a built-in feature or not.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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.

    14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Handoff

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

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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?

    19 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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).

    18 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

Feedback and Knowledge Base