Excel Hack

Excel shortcuts for Mac

For ease of viewing, shortcut keys for Excel for Mac are listed by usage. Mac cannot use the access keys available for Windows. Clicking on the To do this link will take you to a detailed page of the selected content.

Shortcut keys for Excel for Windows are available on a separate page.

All shortcut keys for Excel

Mac shortcut key list

To do thisMac key
Fill downcommand + D
Insert cellscommand + shift + + (plus)
Insert cut cellscommand + shift + + (plus)
Cut valuecommand + X
Delete the characters of the active celldelete
Delete character to the leftdelete
Delete character to the rightfn + delete
Shift cells upcommand + – (minus)
Open filecommand + O
Close Excelcommand + Q
Close active bookcommand + W
Row
Insert rowcommand + shift + + (plus)
Insert multiple rowscommand + shift + + (plus)
Insert row abovecommand + shift + + (plus)
Delete rowcommand + – (minus)
Delete blank rowcommand + – (minus)
Get the bottom of current rowcommand + ↓ (down arrow key)
Select by one cell to the left or rightshift + ← (left arrow)
shift + → (right arrow)
Select entire rowshift + space
Extend select to start of rowcommand + shift + ← (left arrow)
Extend select to end of rowcommand + shift + → (right arrow)
Hide rowcommand + 9
Unhide rowcommand + shift + 9
Column
Insert columncommand + shift + + (plus)
Delete columncommand + – (minus)
Select by one cell to the above or belowshift + ↑ (up arrow key)
shift + ↓ (down arrow key)
Select to end of columncommand + shift + ↓ (down arrow)
Select entire column with datacommand + shift + ↑ (up arrow)
command + shift + ↓ (down arrow)
Column selection by one screenfn + ↑ (up arrow key)
fn + ↓ (down arrow key)
Select cells that do not match the active cellcontrol + shift + | (vertical bar)
Hide columncommand + 0 (zero)
Unhide columncommand + shift + 0 (zero)
Unhide data in the same columnoption + ↓ (down arrow key)
Sheet
New sheetshift + F11
Select entire sheetcommand + A
Select the current and previous sheetshift + option + ← (left arrow)
Select the current and next sheetshift + option + → (right arrow)
Switch sheetoption + ← (left arrow)
option + → (right arrow)
Next sheetoption + → (right arrow)
Close all sheetscommand + W
Move
Move to other cells↑ or ↓ or → or ← (Arrow key)
Move to the cell on the edge of the datacommand + ↑ or ↓ or → or ← (Arrow key)
Format
Boldcommand + B
Strikethroughcontrol + 5
Left alignmentcommand + L
Center alignmentcommand + E
Format cellcommand + 1
Font tabcontrol + shift + P
Increase font sizecommand + shift + >
Set any font sizecontrol + shift + P
Bottom bordercommand + option + ↓ (down arrow key)
Top bordercommand + option + ↑ (up arrow key)
Left bordercommand + option + ← (left arrow key)
Right bordercommand + option + → (right arrow key)
No bordercommand + option + – (minus)
Outside bordercommand + option + 0 (zero)
Number formatcommand + shift + 1
Time formatcontrol + shift + @
Current timecommand + : (colon)
Date Formatcontrol + shift + #
Today’s datecontrol + ; (semicolon)
Apply currency formatcontrol + shift + $
Apply percentage formatcontrol + shift + %
Apply scientific formatcontrol + shift + ^ (caret)
Apply general formatcontrol + shift + ~ (tilde)
Superscriptcontrol + shift + P
Subscriptcontrol + shift + P
Format Cells dialog boxcommand + 1
Formula/Function
Cursor to formula barcontrol + U
Setup required
Edit formulacontrol + U
Drag formulacommand + return
Formula bar widercontrol + shift + U
Show formulacontrol + shift + ` (grave accent)
Copy formula downcommand + D
Multiply formulaoption + command + V
Remove formulaoption + command + V
Absolute referencecommand + T
Insert argument names into formulacontrol + shift + A
Select cells that are directly referenced in a formulacontrol + [
Select cells with formulas that directly reference the cellcontrol + ]
Insert functionshift + F3
AutoSumcommand + shift + T
Macro/VBA
Open Macrooption + F8
Open VBAoption + F11
Others
Select all cells from the current cell to A1control + shift + fn + ← (Left Arrow key)
Select only the active cell when multiple cells are selectedshift + backspace

Hide ribboncommand + F1
Unhide ribboncommand + option + R
Get the bottom cellcontrol + end
Searchcontrol + F
Find nextcommand + G
Find previouscommand + shift + G
Remove newlinecontrol + H
Operation required
Select all cells with Notescontrol + shift + O
Insert notesshift + F2
Insert commentcommand + shift + F2
Hide objectcommand + 6
Flash fillcontrol + E

Articles related to Mac & Shortcut

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments