#Excel Shortcuts 2011 Mac Excel Shortcuts

Learning shortcut keys in OSX applications is straight forward when the relevant key is displayed in the menu. Note: Sometimes a shortcut requires pressing two or more keys at the same time. Keys for other layouts will not correspond exactly to the keys as on a US keyboard. All the shortcut keys in this article refer to the US keyboard layout.

Excel Shortcuts 2011 Mac Excel Shortcuts

Delete row or column: Highlight rows or columns and Ctrl + - Apologize for this inconvenience, I hope you are able to find the correct page in the menu on macexcel.com or use the Search on the site.For general lists of Mac Excel shortcuts, see shortcutworld, and Microsoft.I needed to look up the following shortcut keys: Note: On I moved all my Mac Excel content to a new website named macexcel.com.

Navigate to worksheet by name: In addition to Ctrl+Page Up/Page Down there is another option. Make Ctrl + left and Ctrl + Right be a synonym for Cmd + left and Cmd + Right this works if the global shortcut key for moving between spaces is turned off or changedHow to remove all formatting from cells: (1) Select cells (2) Edit - Clear - Formats. Admittedly this conflicts with calculate now, but Control + = also works for calculate now, and I rarely use spreadsheets that are so large that I need to delay computation. Zoom in and zoom out I just added the shortcut keys Cmd + = for zoom in and Cmd + - for zoom out.

The sort sub menu this is particularly useful for a quick keyboard based ascending or descending sort.

Excel For Mac Shortcuts 2011