The sort sub menu this is particularly useful for a quick keyboard based ascending or descending sort.I created a separate new menu so that it didn’t distract in the GUI. I found it useful to add the following commands just for that purpose. You can customise Excel menus using View - Toolbars - Customize Toolbars and Menus.Īnything in the menu can efficiently be triggered using Cmd+ Shift+ / followed by a simple help search down and enter. So it’s good to know that F14 also de-activates scroll-lock. The result is that the cursor keys annoyingly scroll the window rather than moving the focal cell. I occasionally accidentally press F14 when intending to press Home. F14 is equivalent to scroll lock on Windows.
![microsoft excel 2011 mac keyboard shortcuts microsoft excel 2011 mac keyboard shortcuts](https://i.pinimg.com/originals/7d/28/5b/7d285b5e24b8646b45c48fbc0d8943da.jpg)
Paste Special: Ctrl+ Cmd+ V opens the paste special dialog box then: Cmd+ A is all, Cmd+ V is values, Cmd+ T is formats, Cmd+ E is transpose.
![microsoft excel 2011 mac keyboard shortcuts microsoft excel 2011 mac keyboard shortcuts](https://i0.wp.com/www.informationq.com/wp-content/uploads/2016/05/18-Workbook-Microsoft-Excel-keyboard-shortcuts-for-PC-and-Mac.jpg)
Navigate to the Go dialog box and type the name of the sheet followed by !a1 Navigate to worksheet by name: In addition to Ctrl+Page Up/Page Down there is another option.
#Microsoft excel 2011 mac keyboard shortcuts how to#
How to remove all formatting from cells: (1) Select cells (2) Edit - Clear - Formats.
![microsoft excel 2011 mac keyboard shortcuts microsoft excel 2011 mac keyboard shortcuts](https://ictacademy.com.ng/wp-content/uploads/2020/01/short-480x295.png)
However, some interface elements are not listed in menus.įor general lists of Mac Excel shortcuts, see shortcutworld, and Microsoft. Choose View > Toolbars > Customize Toolbars and. Learning shortcut keys in OSX applications is straight forward when the relevant key is displayed in the menu. Drag the command out of the minimenu or drag the icon off the toolbar. This post discusses learning and configuring shortcuts in Mac Excel.