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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add support for Get & Transform (formerly Power Query)

    Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)

    3,789 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.

    Refer to the following blog post for more details:
    https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840

    I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.

  2. 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?

    3,413 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    760 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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,135 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

  4. Add Evaluate Formula to Mac app

    Please add the evaluate formula dialogue box to the mac app. With it you can evaluate a formula step by step and see which part of the formula works and where the problem is.

    670 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    121 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Consolidate Multiple Data Sources in a Pivot Table using the PivotTable wizard

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

    452 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

  6. 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!!

    313 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  7. Please Add Quick Analysis for Formatting

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

    294 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    57 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add Find all in the Mac app

    IN the windows version you can click on the button find all when you are in a search box. This then shows you all cells which contain your search criteria in a list. Please add this feature to the Mac app, too!

    287 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    92 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  9. 284 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    249 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    112 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. ALT key ribbon access

    The ability to utilize the ALT keys to access any button or command on the ribbon greatly improves productivity on the PC versions of excel. Implementing this feature on the Mac version of excel would be greatly appreciated.

    232 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    214 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

  13. fuzzy lookup for Mac

    Fuzzy lookup for Mac

    It would be great to have fuzzy lookup add-in for Mac.

    169 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    159 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    156 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  16. A better Name manager

    Dear all,
    What I love, please read this a need, is a better Name manager.
    The size of the list is way to small. If you work a lot with names, then you get longer names which are not easy to select.
    Also would like to see an easier way to replace, rename and exchange Names and references. When I make a Template sheet with names/reverences and want to make multiply copies bij code or manualy, its a crime to change or update the Name.

    155 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    39 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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?

    106 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. Improve Graph Drawing Performance

    When scrolling (e.g. with mousewheel) and a graph that was previously outside the view area moves into the view area there is a significant delay before the graph is drawn (1+ sec). If there are several graphs there is an even worse delay.

    The workbook is not complex and the same spreadsheet in Excel (for Mac) 2008 did not suffer such delays i.e. nothing to do with the volume of data or the spreadsheet - something to do with Excel 2016.

    I've not tried different styles or types of graph, mine are just simple line plots based in data in…

    100 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  19. Support Internet Query Connection (.iqy files)

    It would be helpful for Excel to Mac to support internet query connections.

    When exporting a list from Sharepoint, the .iqy file is downloaded, which I subsequently can't open in Excel for Mac.

    90 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    16 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  20. Horizontal scroll is not working.

    When I import a text file and want to select all of the columns as text the horizontal scroll feature does not work and I can only change what ever I can see in the window to text. I use the feature on a weekly basis. This makes excel 2016 unusable for me on a Mc.

    74 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    By setting your scroll bars to be always shown in your MacOS general settings, you are able to scroll horizontally in the text import wizard.

    We will prioritize this issue accordingly with other issues based on the votes and interest that we see here.

    Steve K [MS Excel]

← Previous 1 3 4 5 65 66
  • Don't see your idea?

Feedback and Knowledge Base