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.

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.

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?

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…

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

When a macro is added to the QAT, it displays as a circle in the toolbar. Add another, you get another circle. Unless you memorize what you added and the order you added them, you don't know what you're selecting. The list for customizing the QAT shows them as <<No label>>. You can name them with the Rename option on gear at the bottom of the dialog, but they revert back to no label after you exit the dialog.