Mac Excel Shortcuts

Here is the official list from Microsoft

The strange things are they are different. For instance F4 is paste whereas in Windows Excel is it change relative to absolute. And F2 is edit cell whereas it is cut text. And again, there is this strangeness that you use the Option key where you use the Ctrl key in windows even though there is a Ctrl key on new Mac keyboards.

Equivalent of Windows Excel F4 key in Excel 2008 for the Mac

Navigating in Excel
Switch between Worksheets fn-CTRL-PageUp/fn-CTRL-PageDown
Switch between Workbooks fn-`
Select entire worksheet Cmd+A
Move to the beginning of the line. fn+left arrow(home)
Go To fn + F5
Move a Sheet/Copy a Sheet Alt-E-M
Change Zoom Sizing Alt-V-Z

Entering and editing data
Complete a cell entry and select…
Delete cell and then get inside the cell DELETE
Delete cell/selection. fn+DELETE
Edit inside a cell (edit cell mode) CTRL+U
Once inside edit cell mode (F2)…
…Start a new line in the same cell. OPTION+CMD+ENTER
…Delete the preceding character. DELETE
…Delete the character to the right of the insertion fn + DELETE
Spell Check. fn + F7
Insert a comment. fn+SHIFT+ F2
Undo the last action. cmd+z
Redo the last action. cmd + y

Selecting, grouping, inserting, and deleting cell
Group Rows or Columns SHIFT+ALT+RIGHT ARROW KEY
Ungroup Rows or Columns SHIFT+ALT+LEFT ARROW KEY
Clear the contents of the selected cells. DELETE
Delete the selected cells. CTRL+MINUS SIGN SAME
Insert blank cells. CTRL+SHIFT+PLUS SIGN SAME

Copying and Pasting Shortcut
Copy, then Paste Special Formats Alt-E+S+T
Copy, then Paste Special Formulas Alt-E+S+F

Formatting Data Shortcut Example
Display the Style dialog box. CMD+SHIFT+L
Display the Format Cells dialog box. CMD+1
CTRL+SHIFT+! 1,254.34
Currency format: 2 decimal places (negative numbers in parentheses): CTRL+SHIFT+$ $1,254.34
Percentage format with no decimal places. CTRL+SHIFT+% 125434%
Exponential number format with two decimal places. CTRL+SHIFT+^ 1.25E+03
Boldface CMD+B
Italicize CMD+I
Underline CMD+U
Strikethrough CMD+SHIFT+_
Apply the outline border to the selected cells. CMD+Option+Arrow Key
Remove the outline border from the selected cells. CMD+Option+Arrow Key

Enter and calculate formulas Shortcut Example
Start a formula. = (equal sign) =F45*G12
In a formula, display the Insert Function dialog box. fn+SHIFT + F3
Recalculate all worksheets in all open workbooks. F9
Anchoring “Fixing” Cells F4 – must be in edit cell mode (CTRL+U) =$F$4*G125
Go to precedent cell(s) CTRL-[

Naming cells, Hyperlinks, inserting time and dat
Name a cell. fn+CMD+F3
Display a drop-down list of the values in the current cALT+DOWN ARROW

Mac Excel Shortcuts

It turns out that some of the commands in Mac Excel can’t actually be rebound. For instance, Allison, wants to have these work. Here is the list and how to get them Mac Excel. For Mac Excel 2001 we have a list.

Control + page up. This maps to Ctrl-Right which is find the next empty cell. On a Mac laptop there is no Page Up or Page Down keys, they only have arrow keys, so can’t remap these. Need to use an extended 101 keyboard for this to work. The Mac equivalent is Command-F6 and Command-Shift-F6 to go back a worksheet

The function keys are gotten by typing FN-F1 since the Mac uses the function keys for other things:

F2. This is so strange, with the Mac, it maps to Ctrl-U and there is no way to get F2 for EDIT and need a shortcut. You can get this with Quickeys
F4. This is Command-T on the Mac (“techjive”:http://www.techjive.net/2007/02/02/excel-keystrokes/). The only way to get this to work for Excel is some sort of shortcut. You can get this with Quickeys to map it.
F5. This is the Goto function and it works
F9. Recalc which is CMD-W The main issue is that normally Mac Excel makes F9 their own shortcut, so you have to turn off keyboard shortcuts for Expose.

Ctrl-R.Copy from the cell on left into this cell. This works in Mac Excel and is called the Right function
Ctrl-D. Copy from the cell above down to here.
Alt + =. Not sure what this does but on Mac, Alt keys actually puts in special character
Shift+F2. Insert comment. this works in Mac Excel
Alt+E, S, T. Opens the edit menu, then s choose paste specials and then format. You have to get this with Quickeys
Control + 1. Format Cells. Need to change in the Excel Keyboard Shortcuts since it is select object on the Mac and format cells is command-1.

Alt+I+C. Insert Column. Which I actually do as Ctrl-Space and then Ctrl-+, but you need a key remapper to do this.
Alt+I+R. Insert Row. Same thing, but it is actually Ctrl-Shift-Equal
Control+P. Works this is File/Print
Control+Y. This is redo and is mapped to Command-Y on the Mac, but Control-Y is unassigned, so use Excel to map
Control+Tab. This is next workbook. It works in Mac Excel. Note that Alt-Tab on the PC is Command-Taq on the Mac which you need Quickeys can’t remap

Some of my favorites are

Ctrl-$ for currency format. Works on Mac
Ctrl-% for perfentage. Works on Mac
Ctrl-Shift-Arrow. Select to the rigth

Ctrl-PgUp navigates through worksheets
Ctrl-PgDn navigates through worksheets.
Ctrl-Minus is Delect
Ctrl-Shift-Plus is Insert
Ctrl-* is fill in
Shift-Space selects a row
Ctrl-Plus inserts a row
Ctrl-Minus deletes a row