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

    4,323 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

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

    Thanks for supporting this suggestion with your votes. It’s unlikely that we’ll be able to bring PowerPivot to Excel for Mac, because it relies on features of the operating system that don’t exist on Mac OS. We’ll keep tracking votes, since we know that the scenarios made possible by PowerPivot are important, even if the solution will need to be something else.

  2. Add support for Get & Transform (formerly Power Query)

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

    4,029 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

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

    Hi all! We are happy to let you know that in addition to refreshing your data from supported sources, you can now import data from local files such as Excel workbooks, and Text and CSV files with Power Query in Excel for Mac. This new functionality is available to Beta channel users running version 16.50 (build 21050400) or later.
    You can check out the blog for this new feature here: https://insider.office.com/en-us/blog/import-data-from-local-files-with-power-query-in-excel-for-mac
    For more information about Power Query features that are currently supported in Excel for Mac, please take a look at the following support article: https://support.microsoft.com/office/7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5

    Inbar Privman
    Product Manager, Excel Team

  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,460 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

    422 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

  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.

    945 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

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

    458 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

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

    Thanks for the suggestion about the Data Form. We don’t have plans to implement this in the near future, so we’re marking it “Not at this time”.

    We recommend using Tables to make data entry easy. To create a table, just press CMD+T. With a table, you can press TAB to move across the fields and then it will automatically go to the beginning of the next line if you’re at the last field. If you’re on the last record in the table, it will add a new record to the end of the list.

    Please comment to let us know what other reasons you’re using the Data Form that make it easier/better than using a Table.

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

    375 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

    116 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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.

    352 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

    151 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  8. Please Add Quick Analysis for Formatting

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

    346 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

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

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

    290 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

    40 comments  ·  Data Import  ·  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.

    250 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

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

    202 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

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

    193 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

    26 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  14. fuzzy lookup for Mac

    Fuzzy lookup for Mac

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

    174 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

    50 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  15. Make quick access toolbar for Mac. same as in Windows, colored icons and option to move the QAT below the ribbon

    Make quick acces toolbar for Mac. same as in Windows, colored end option tu use bellow the ribbon

    134 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

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

    127 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

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

    Thank you for taking your time to suggest and vote for IQY support on Mac. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. Worth noting however that we are working to bring Power Query to Mac which will enable you to connect, load and shape data from multiple data sources, including SharePoint.

    You may review the latest status of what Power Query functionality is currently supported on Mac here:
    https://support.microsoft.com/office/7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5

    Guy Hunkin
    Principal PM, Excel Team

  17. 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…

    113 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

    10 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  18. Trend line to cell

    Function that references a chart and gives trendline parameters.

    90 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  19. Bring filtering charts to Excel for Mac

    Bring filtering charts to Excel for Mac.

    I read about this feature here: https://blogs.office.com/en-us/2014/02/04/filtering-charts-in-excel/

    But I couldn't find how to use them in Excel for Mac (16.12).
    I found https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/chart-filter/e5e49410-6ffc-499f-bdeb-e6f8a151bd4c which claims they are not supported. This would be a useful feature to bring Excel for Mac closer to Excel for Windows.

    77 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  20. Gradient Cell for Excel Mac

    To have compatibility for Windows & Mac suggested to have gradient fill for Excel Mac as well.

    73 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

    17 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 95 96
  • Don't see your idea?

Feedback and Knowledge Base