File this under the 'so I remember it later' department. Tonight I was working on a large financial model and banging my head against the fact that all my old Excel keyboard shortcuts don't work on the Mac. So I dug around and pulled together the list of ones that I commonly use:
Excel keyboard shortcuts (Windows and Mac) File. Create new workbook. Window users are screwed when it comes to keyboard shortcuts in Excel for Mac. Remember that well. Edit the Active Cell in Excel for Mac. CONTROL+U is the new F2 when you're using Excel with a Mac. If you want to edit the active cell use the keyboard shortcut CONTROL+U. If you use F2 to edit a cell on a Mac, remember your screwed, and think FU. Excel keyboard shortcuts (Windows and Mac) File. Create new workbook. Sometimes you need a linebreak in an Excel spreadsheet cell, but when you hit return or enter it always jumps you to a new cell. On Windows, you can just hit alt-return (or maybe alt-enter; if one doesn't work, try the other). On Mac, you'll need to hit control-option-return.
MAC EXCEL 2016
Define a name: Ctrl + L
Enter edit mode on a cell: Ctrl + U
Toggle cell anchoring: Command + T
Format as percentage: Ctrl + Shift + % (% = 5)
Format as number with commas: Ctrl + Shift + ! (! = 1)
Add an outline border around a cell: Command + Option + 0
Add a border at top: Command + Option + up arrow
Add a border at bottom: Command + Option + down arrow
Remove outline borders: Command + Option + hyphen
Select entire column: Ctrl + spacebar
Select entire row: Shift + spacebar
Insert a row: Ctrl + spacebar, then Ctrl + Shift + =
Insert a row: Shift + spacebar, then Ctrl + hyphen or Command + hyphen
Delete a row: Ctrl + spacebar, then Ctrl + hyphen
Delete a row: Shift + spacebar, then Ctrl + hyphen
Fill down: Ctrl + D or Command + D
Fill right: Ctrl + R or Command + D
Ctrl On Mac For Excel Spreadsheet
Switch between open workbooks: Ctrl – tab
Paste Special: Command + Command + V or Control + Option + V
Increase font size: Command + Shift + >
Decrease font size: Command + Shift + <
Next worksheet: Ctrl + pagedown
Previous worksheet: Ctrl + pageup
Auto-sum: Command + Shift + T
Ctrl On Mac For Excel Shortcuts
Goto / insert name / find special: Control + G or F5
:no_upscale()/cdn.vox-cdn.com/uploads/chorus_asset/file/6452585/excel-2016.0.png "Ctrl On Mac For Excel")
Define a name: Ctrl + L
Enter edit mode on a cell: Ctrl + U
Toggle cell anchoring: Command + T
Format as percentage: Ctrl + Shift + % (% = 5)
Format as number with commas: Ctrl + Shift + ! (! = 1)
Add an outline border around a cell: Command + Option + 0
Add a border at top: Command + Option + up arrow
Add a border at bottom: Command + Option + down arrow
Remove outline borders: Command + Option + hyphen
Select entire column: Ctrl + spacebar
Select entire row: Shift + spacebar
Insert a row: Ctrl + spacebar, then Ctrl + Shift + =
Insert a row: Shift + spacebar, then Ctrl + hyphen or Command + hyphen
Delete a row: Ctrl + spacebar, then Ctrl + hyphen
Delete a row: Shift + spacebar, then Ctrl + hyphen
Fill down: Ctrl + D or Command + D
Fill right: Ctrl + R or Command + D
Ctrl On Mac For Excel Spreadsheet
Switch between open workbooks: Ctrl – tab
Paste Special: Command + Command + V or Control + Option + V
Increase font size: Command + Shift + >
Decrease font size: Command + Shift + <
Next worksheet: Ctrl + pagedown
Previous worksheet: Ctrl + pageup
Auto-sum: Command + Shift + T
Ctrl On Mac For Excel Shortcuts
Goto / insert name / find special: Control + G or F5
MAC EXCEL 2011
Define a name: Ctrl + L
Enter edit mode on a cell: Ctrl + U
Toggle cell anchoring: Command + T
Save As
Format as percentage: Ctrl + Shift + % (% = 5)
Format as number with commas: Ctrl + Shift + ! (! = 1)
Add an outline border around a cell: Command + Option + 0
Add a border at top: Command + Option + up arrow
Add a border at bottom: Command + Option + down arrow
Remove outline borders: Command + Option + hyphen
Select entire column: Ctrl + spacebar
Select entire row: Shift + spacebar
Insert a row: Ctrl + spacebar, then Ctrl + i
Insert a row: Shift + spacebar, then Ctrl + i
Delete a row: Ctrl + spacebar, then Ctrl + hyphen
Delete a row: Shift + spacebar, then Ctrl + hyphen
Ctrl On Mac For Excel Spreadsheets
Fill down: Ctrl + D
Fill right: Ctrl + R
Switch between open workbooks: Ctrl – tab
Paste Special: Ctrl + Command + V
Increase font size: Command + Shift + >
Decrease font size: Command + Shift + <
Save Workbook
Next worksheet: Ctrl + pagedown
Previous worksheet: Ctrl + pageup
Auto-sum: Command + Shift + T
Excel Mac Ctrl Shift Enter
Goto / insert name / find special: F5
