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.
-
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,526 votesHi all,
We are glad to announce that the first phase of the project is available for Insiders Fast. At this stage we support refresh from text, CSV, XLSX, JSON and XML files.
Refer to the following blog post for more details:
https://blog-insider.office.com/2019/05/30/you-asked-for-it-a-journey-to-power-query-in-excel-for-mac-starts-now/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.
We have exciting times ahead of us!
Guy Hunkin
- Excel Team -
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?2,399 votesThanks for all the votes and comments on this suggestion. We know this is important and it’s a big undertaking. Please continue to show your support for this.
Steve K [MS Excel]
-
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)
758 votesThanks 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 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.
379 votesThanks for all your comments and votes supporting this suggestion. We are in the planning stages for this feature to be added to Excel for Mac.
Thanks – Steve K [MS Excel]
-
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.
349 votesUpdate – 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…
-
Consolidate Multiple Data Sources in a Pivot Table
Allow users to aggregate data in a pivot table from multiple worksheets.
279 votesHi 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]
-
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.
255 votesWe will still accept votes on this suggestion. Please note that this suggestion is not for VBA UserForms. There’s a separate suggestion you can vote for if that’s most important to you.
Some comments on the other suggestion indicate that clarification was needed, so I’ve updated the titles and description to be clearer.
Steve K [MS Excel]
-
Please Add Quick Analysis for Formatting
Quick Analysis is available on Windows Excel 2016, but not Mac 2016 - please add.
235 votesThanks for all your comments and votes supporting this suggestion. Please keep generating support for this.
Thanks – Steve K [MS Excel]
-
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.
217 votesThanks for your comments and votes supporting this issue. We will continue to monitor this topic.
Thanks – Steve K [MS Excel]
-
214 votes
Thanks for the suggestion and the votes about 3D maps. We will continue to monitor the suggestion and prioritize it accordingly.
Steve K [MS Excel]
-
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!
206 votesThanks for all your comments and votes supporting this suggestion. Please keep adding votes. We are considering this for a future update.
Thanks – Steve K [MS Excel]
-
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!!186 votesThanks 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]
-
fuzzy lookup for Mac
Fuzzy lookup for Mac
It would be great to have fuzzy lookup add-in for Mac.
153 votesThanks for all your comments and votes supporting this suggestion. It would be very helpful if you would add more information about how you’d like to use fuzzy lookup in Excel.
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.
152 votes -
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.
145 votesThanks 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]
-
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
143 votesThanks for the suggestion and the votes. We’ll keep monitoring this so that we can prioritize it along with the other suggestions here.
Steve K [MS Excel]
-
EXCEL For Mac needs a XML import data
There is not way to import and map XML data to excel for mac,
133 votes -
Provide all the options that are available to Windows users
MAC users are severely limited with what they can do in Excel compared to Windows users. I am doing an Excel course and creating a Pivot Chart is not an option for me nor do I have the option to create a PowerPivot as my classmates who use Windows PCs. All that needs to be done is to make things comparable. What you do for one- Windows PC users, you do for the other- Mac users. Level the playing field so to speak.
It's not only about Pivot Tables. All Mac Excel applications and features need to be updated and…
122 votes -
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.
120 votesThanks 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]
-
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.115 votesThanks for all your comments and votes supporting this suggestion. We will continue to monitor this forum.
Thanks – Steve K [MS Excel]
- Don't see your idea?