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?

Enter your idea

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

Excel had the screen updating ability when running a VBA code, and with the latest update (early 2020) it is now gone? the VBA on the excel is rather incomplete and should work like the Windows version. When developing new macros, it is critical to be able to stop the code execution with "esc" and see the screen updating/refresh in order to assess whether the code is running. In addition, the Name Ranges manager is incomplete and should be improved in terms of ability to update names and manage a list. Again the Windows version is like how this should work.

Excel had the screen updating ability when running a VBA code, and with the latest update (early 2020) it is now gone? the VBA on the excel is rather incomplete and should work like the Windows version. When developing new macros, it is critical to be able to stop the code execution with "esc" and see the screen updating/refresh in order to assess whether the code is running. In addition, the Name Ranges manager is incomplete and should be improved in terms of ability to update names and manage a list. Again the Windows version is like how this should…

In the PC version of Excel one can create an Add-In menu via a VBA module that executes when a workbook is opened and adds a ribbon tab that displays a drop-down box where the selections link to macros which implement custom-developed capabilities. Why hasn't this been done for the Mac?

Rather than make Macro behavior global, give us the ability to Enable them within individual Workbooks so we don't have to see the alert dialogue each time that Workbook is opened. I would suggest putting a setting in the Properties and adding a button/link to the dialogue options.

The visual basic for applications editor for the Mac does not have the ability to edit keyboard shortcuts. The most common editing shortcut used is to step through code while debugging. In windows VBE this is F8, and those of us who are familiar with the windows version would like to have the same experience on the Mac. The current keyboard shortcut requires two hands and makes it very awkward to step through and debug your code.

According to Madoc Huang MSFT in the Microsoft community forum, I should post this here because this feature is not available on the Mac.

FF8 is not possible because I know it is special, then you should allow F7 or F6 or F5.

The visual basic for applications editor for the Mac does not have the ability to edit keyboard shortcuts. The most common editing shortcut used is to step through code while debugging. In windows VBE this is F8, and those of us who are familiar with the windows version would like to have the same experience on the Mac. The current keyboard shortcut requires two hands and makes it very awkward to step through and debug your code.

According to Madoc Huang MSFT in the Microsoft community forum, I should post this here because this feature is not available on the…

There appear to be critical compatibility issues between 2011 and 2016 for Mac.
I've written a lot personal finance code. I need to load externally generated tab separated data and expressions into excel cell ranges. I export named range tables so my external code can inter-operate with Excel 2011. The macros I wrote to do all this in Excel 2011 don't run correctly in Excel 2016. I need a comprehensive Macro/VBA migration guide. I can't switch to 2016 until these macros have been ported.

I would like to enter a customized footer for each excel sheet that I print. For example page 1 footer is different that page 2 but I still able to keep the feature of all of them having a consistent page number.

I recently notice that files saved with Office 2016 do not work on Office 2019 (16.26) and vice et versa. Either crash or showing compilation error or internal errors with librairy. It was not the case with Office 2019 (16.25).
Please fix...