Microsoft Excel Commands For Mac
50 time-saving Excel shortcuts for Mac. Save time and conquer the spreadsheet with these 50 Excel keyboard shortcuts. Get the most out of Excel with these pro tips. The keyboard shortcuts make your work easier, faster and more efficiently. This list covers 224 shortcut keys you can use for Windows and Mac. It’s organized by 13 categories which you experience in Excel 2016.
- Most familiar Office Fluent Control Identifiers are compatible with Office for Mac. Some might not be available. For commands that are compatible with Office 2016 for Mac, see idMSOs compatible with Office 2016 for Mac. Support for COM add-ins that use custom ribbon controls: Available: Office 2016 for Mac doesn't support third-party COM add-ins.
- Keyboard Shortcuts for Excel on Windows and Mac One way of speeding up Excel is to integrate keyboard shortcuts in your workflow. Excel experts hardly use a mouse at all, because using a mouse takes more time and is often not precise.
使用您为 office for Mac 中的 office for Windows 开发的 VBA 外接程序和宏。Use VBA add-ins and macros that you developed for Office for Windows with Office for Mac.
适用于: Excel for Mac PowerPoint for Mac Word for Mac 适用于 Mac 的 Office 2016Applies to: Excel for Mac PowerPoint for Mac Word for Mac Office 2016 for Mac
如果要为 office for Mac 创作宏, 则可以使用 VBA for office 中提供的大部分相同的对象。If you are authoring Macros for Office for Mac, you can use most of the same objects that are available in VBA for Office.有关 Excel、PowerPoint 和 Word 的 VBA 的信息, 请参阅以下内容:For information about VBA for Excel, PowerPoint, and Word, see the following:
备注
Outlook for mac 和 OneNote for mac 不支持 VBA。Outlook for Mac and OneNote for Mac do not support VBA.
Microsoft office mac free full version. Yet there are changes with the design and features interface, although it doesn’t really of much difference.
Office 2016 for Mac 已沙盒化Office 2016 for Mac is sandboxed
与支持 VBA 的 office 应用程序的其他版本不同, office 2016 for Mac 应用程序是沙盒中的。Unlike other versions of Office apps that support VBA, Office 2016 for Mac apps are sandboxed.
沙盒将限制应用程序访问应用容器外部的资源。Sandboxing restricts the apps from accessing resources outside the app container.这会影响涉及跨进程的文件访问或通信的任何加载项或宏。This affects any add-ins or macros that involve file access or communication across processes.您可以通过使用下一节中介绍的新命令来最大限度地减少沙盒的影响。You can minimize the effects of sandboxing by using the new commands described in the following section.
创建安装程序或放置用户内容Creating an installer or putting user content
有关为你的外接程序创建安装程序的说明, 请参阅以下文章:在 Office 2016 for Mac 中安装用户内容For instructions on creating an installer for your add-in, please refer to the article here: Installing User Content in Office 2016 for Mac
适用于 Office 2016 for Mac 的新 VBA 命令New VBA commands for Office 2016 for Mac
以下 VBA 命令是 Office 2016 for Mac 的新的和唯一的。The following VBA commands are new and unique to Office 2016 for Mac.
| CommandCommand | 用于Use to |
|---|---|
| GrantAccessToMultipleFilesGrantAccessToMultipleFiles | 请求用户一次访问多个文件的权限。Request a user's permission to access multiple files at once. |
| AppleScriptTaskAppleScriptTask | 从 VB 调用外部 AppleScript 脚本。Call external AppleScript scripts from VB. |
| MAC_OFFICE_VERSIONMAC_OFFICE_VERSION | 在编译时, 在不同 Mac Office 版本之间的 IFDEF。IFDEF between different Mac Office versions at compile time. |
Office for Mac 中的功能区自定义Ribbon customization in Office for Mac
适用于 Mac 的 Office 2016 支持使用功能区 XML 进行功能区自定义。Office 2016 for Mac supports ribbon customization using Ribbon XML.请注意, office 2016 for Mac 和 office for Windows 中的功能区支持存在一些差异。Note that there are some differences in ribbon support in Office 2016 for Mac and Office for Windows.
| 功能区自定义功能Ribbon customization feature | Office for WindowsOffice for Windows | Office for MacOffice for Mac |
|---|---|---|
| 能够使用功能区 XML 自定义功能区Ability to customize the ribbon using Ribbon XML | 可用Available | 可用Available |
| 支持基于文档的外接程序Support for document based add-ins | 可用Available | 可用Available |
| 使用自定义功能区控件调用宏的能力Ability to invoke Macros using custom ribbon controls | 可用Available | 可用Available |
| 自定义菜单的自定义Customization of custom menus | 可用Available | 可用Available |
| 能够在自定义功能区选项卡中加入和调用 Office 熟知控件Ability to include and invoke Office Fluent Controls within a custom ribbon tab | 可用Available | 最熟悉的 office 熟知控制标识符与 office for Mac 兼容。Most familiar Office Fluent Control Identifiers are compatible with Office for Mac.有些可能不可用。Some might not be available.对于与适用于 mac 的 office 2016 兼容的命令, 请参阅与 office 2016 for mac兼容的 idmso。For commands that are compatible with Office 2016 for Mac, see idMSOs compatible with Office 2016 for Mac. |
| 支持使用自定义功能区控件的 COM 加载项Support for COM add-ins that use custom ribbon controls | 可用Available | 适用于 Mac 的 Office 2016 不支持第三方 COM 加载项。Office 2016 for Mac doesn't support third-party COM add-ins. |
与 Office 2016 for Mac 兼容的 idmsoidMSOs compatible with Office 2016 for Mac
有关与适用于 Mac 的 Office 2016 兼容的 idmso 的信息, 请参阅以下内容:For information about the idMSOs that are compatible with Office 2016 for Mac, see the following:
另请参阅See also
支持和反馈Support and feedback
有关于 Office VBA 或本文档的疑问或反馈？Have questions or feedback about Office VBA or this documentation?请参阅 Office VBA 支持和反馈，获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
-->Is microsoft keyboard 4000 mac os x 10.9.5 9 5 update. Use VBA add-ins and macros that you developed for Office for Windows with Office for Mac.
Applies to: Excel for Mac PowerPoint for Mac Word for Mac Office 2016 for Mac
If you are authoring Macros for Office for Mac, you can use most of the same objects that are available in VBA for Office. For information about VBA for Excel, PowerPoint, and Word, see the following:
Note
Outlook for Mac and OneNote for Mac do not support VBA.
Office 2016 for Mac is sandboxed
Unlike other versions of Office apps that support VBA, Office 2016 for Mac apps are sandboxed.
Sandboxing restricts the apps from accessing resources outside the app container. This affects any add-ins or macros that involve file access or communication across processes. You can minimize the effects of sandboxing by using the new commands described in the following section.
Creating an installer or putting user content
For instructions on creating an installer for your add-in, please refer to the article here: Installing User Content in Office 2016 for Mac
New VBA commands for Office 2016 for Mac
The following VBA commands are new and unique to Office 2016 for Mac.
| Command | Use to |
|---|---|
| GrantAccessToMultipleFiles | Request a user's permission to access multiple files at once. |
| AppleScriptTask | Call external AppleScript scripts from VB. |
| MAC_OFFICE_VERSION | IFDEF between different Mac Office versions at compile time. |
Ribbon customization in Office for Mac
On Command
Office 2016 for Mac supports ribbon customization using Ribbon XML. Note that there are some differences in ribbon support in Office 2016 for Mac and Office for Windows.
| Ribbon customization feature | Office for Windows | Office for Mac |
|---|---|---|
| Ability to customize the ribbon using Ribbon XML | Available | Available |
| Support for document based add-ins | Available | Available |
| Ability to invoke Macros using custom ribbon controls | Available | Available |
| Customization of custom menus | Available | Available |
| Ability to include and invoke Office Fluent Controls within a custom ribbon tab | Available | Most familiar Office Fluent Control Identifiers are compatible with Office for Mac. Some might not be available. For commands that are compatible with Office 2016 for Mac, see idMSOs compatible with Office 2016 for Mac. |
| Support for COM add-ins that use custom ribbon controls | Available | Office 2016 for Mac doesn't support third-party COM add-ins. |
idMSOs compatible with Office 2016 for Mac
For information about the idMSOs that are compatible with Office 2016 for Mac, see the following:
See also
Microsoft Excel Commands For Mac 2017
Support and feedback
List Of Excel Commands
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.