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.How to remove all formatting from cells: (1) Select cells (2) Edit - Clear - Formats. 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 changed.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.Insert cells: Ctrl + I This also works to insert columns and rows by first highlighting either columns (ctrl+space) or columns (shift+space).Delete row or column: Highlight rows or columns and Ctrl +.I needed to look up the following shortcut keys: However, some interface elements are not listed in menus.įor general lists of Mac Excel shortcuts, see shortcutworld, and Microsoft. Learning shortcut keys in OSX applications is straight forward when the relevant key is displayed in the menu. This post discusses learning and configuring shortcuts in Mac Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |