#Mac shortcuts for excel how to
#Mac shortcuts for excel mac

That will “redo” a recently-reversed action. To reapply the last action or formula you undid in Excel, press Command + Y or Ctrl + Y. Undo Changesĭid you enter invalid or incorrect data in your worksheet? Or, do you simply want to reverse a recently-executed action? Whack Command + Z or Ctrl + Z on your Mac’s keyboard to undo the most recent action applied to the worksheet. That explains why they’re on this list as some of the best Excel keyboard shortcuts. You probably already use them every day, and they sure help you get things done faster. Some hotkeys in this section are system-wide keyboard shortcuts that work in every app on your Mac. Press Command + 1 to open the dialog box. Say you want to change Excel’s date format or currency format, you do so in the Format Cells dialog box. In the Format Cells dialog box, you get access to extensive formatting options for numbers, alignment, fonts, etc. You can also use these shortcuts to undo or remove the respective formatting you applied to a cell. Command + I and Command + U will apply the “italic” and “underline” formatting to the selected column, rows, or cells. Select the cell(s) you want to modify and press Command + B to apply the bold formatting. These are commonly used text formatting attributes in Excel and other Microsoft tools. Select the cells, rows, or columns whose font sizes you want to reduce and press Shift + Command + < (the Left angle bracket key). This is equally as easy as increasing font sizes. Simply select the cell, row, or column and press Shift + Command + >. * The filter sub menu * The sort sub menu this is particularly useful for a quick keyboard based ascending or descending sort.You can also increase the font size of a specific cell, row, or column. 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. Anything in the menu can efficiently be triggered using Cmd+Shift+ / followed by a simple help search down and enter. # Customised menus You can customise Excel menus using `View - Toolbars - Customize Toolbars and Menus.`. 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.

Navigate to the `Go` dialog box and type the name of the sheet followed by `!a1` * 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. * Navigate to worksheet by name: In addition to Ctrl+Page Up/Page Down there is another option.

#Mac shortcuts for excel how to

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

I needed to look up the following shortcut keys: * Delete row or column: Highlight rows or columns and Ctrl + - * Insert cells: Ctrl + I This also works to insert columns and rows by first highlighting either columns (ctrl+space) or columns (shift+space) * Zoom in and zoom out I just added the shortcut keys Cmd + = for zoom in and Cmd + - for zoom out.

#Mac shortcuts for excel mac

For general lists of Mac Excel shortcuts, see (), and (). However, some interface elements are not listed in menus. 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.