Keyboard Shortcuts

Row Zero supports standard keyboard shortcuts for common spreadsheet actions to help you work more efficiently.

Row Zero also supports many chord-based shortcuts for more granular actions. These work similarly to Excel's KeyTips ("alt shortcuts").

Missing a shortcut you wish we had? Submit a request.

Shortcut keys separated by plus signs (+) must be pressed at the same time.
Shortcut keys separated by commas (,) must be pressed one after another in sequence.

Shortcut type
Platform

Editing shortcuts

Add commentCtrl+Alt+MAlt, N, C, 2
Clear allAlt, H, E, A
Clear commentsAlt, H, E, M
Clear contentsAlt, H, E, C
Clear formatsAlt, H, E, F
CopyCtrl+C
CutCtrl+X
Delete cellsCtrl+-Alt, H, D, D
Delete columnsAlt, H, D, C
Delete rowsAlt, H, D, R
Fill downCtrl+D
Fill rightCtrl+R
Find and replaceCtrl+H
Insert bar chartAlt, N, C, 1
Insert cellsAlt, H, I, I
Insert columnsAlt, H, I, COption, I, C
Insert current dateCtrl+;
Insert current date & timeCtrl+Shift+Alt+;
Insert current timeCtrl+Shift+;
Insert histogramAlt, N, S, A
Insert line chartAlt, N, N, 1
Insert pivot tableAlt, N, VOption, D, P
Insert rangeCtrl+=
Insert rowsAlt, H, I, ROption, I, R
Insert scatter plotAlt, N, D
PasteCtrl+V
Paste formatsCtrl+Alt+VAlt, H, V, R
Paste formulasAlt, H, V, F
Paste valuesCtrl+Shift+VAlt, H, V, V
Paste values (transposed)Alt, H, V, T
RedoCtrl+YCtrl+Shift+Z
Rename sheetAlt, H, O, R
Resize columnAlt, H, O, W
Resize column (auto-fit)Alt, H, O, I
Resize rowAlt, H, O, H
Resize row (auto-fit)Alt, H, O, A
UndoCtrl+Z

Navigation shortcuts

FindCtrl+F
Focus name boxCtrl+J
Go to next Find resultF3
Go to next sheetCtrl+Shift+PageDown
Go to previous Find resultShift+F3
Go to previous sheetCtrl+Shift+PageUp

Data shortcuts

Clear filtersAlt, A, C
Recalculate allCtrl+Alt+Shift+F9
Recalculate this sheetShift+F9
Remove duplicatesAlt, A, M
SortAlt, A, S, S
Split text to columnsAlt, A, E
Toggle filtersCtrl+Shift+LAlt, H, S, FOption, A, T
Trace dependenciesAlt, M, D
Trace precedentsAlt, M, P

Selection shortcuts

Select allCtrl+A
Select columnCtrl+Space
Select rowShift+Space

Formatting shortcuts

Advanced formattingAlt, H, O, E
Align bottomAlt, H, A, B
Align centerAlt, H, A, C
Align leftAlt, H, A, L
Align middleAlt, H, A, M
Align rightAlt, H, A, R
Align topAlt, H, A, T
All bordersAlt, H, B, A
Bottom borderAlt, H, B, O
Decrease precisionAlt, H, 9
Format boldCtrl+BAlt, H, 1
Format fill colorAlt, H, H
Format font sizeAlt, H, F, S
Format italicCtrl+IAlt, H, 2
Format painterAlt, H, F, P
Format underlineCtrl+UAlt, H, 3
Increase precisionAlt, H, 0
Left borderAlt, H, B, L
Merge & centerAlt, H, M, C
Merge cellsAlt, H, M, M
No bordersAlt, H, B, N
Number format: accountingCtrl+Shift+4Alt, H, A, N
Number format: dateCtrl+Shift+3
Number format: numberCtrl+Shift+1Alt, H, K
Number format: percentCtrl+Shift+5Alt, H, P
Number format: timeCtrl+Shift+2
Outer borderAlt, H, B, S
Right borderAlt, H, B, R
Thick bottom borderAlt, H, B, H
Thick outer borderAlt, H, B, T
Top & bottom bordersAlt, H, B, D
Top borderAlt, H, B, P
Unmerge cellsAlt, H, M, U
Wrap textAlt, H, W

View shortcuts

Freeze first columnAlt, W, F, C
Freeze top rowAlt, W, F, R
Toggle frozen panesAlt, W, F, F
Toggle gridlinesAlt, W, V, G

Help shortcuts

Submit feedbackAlt, 9

Formatting

Previous Page

Pivot Tables

Next Page