Use keyboard shortcuts
- Helen Gosper
- Denise McGettigan
Save time by using these common keyboard shortcuts in the budget and forecast worksheets, whether you're using Windows or Mac.
General
Shortcut (Windows) | Shortcut (Mac) | Action |
|---|---|---|
Ctrl + C | Command (⌘) + C | Copy selection |
Ctrl + X | Command (⌘) + X | Cut selection |
Ctrl + V | Command (⌘) + V | Paste selection |
Ctrl + Z | Command (⌘) + Z | Undo |
Ctrl + Y | Command (⌘) + Y | Redo |
Cell navigation
Shortcut (Windows) | Shortcut (Mac) | Action |
|---|---|---|
Arrow Keys (All) | Arrow Keys (All) | Move one cell |
Ctrl + Arrow Key (Up, Down, Left, Right) | Command (⌘) + Arrow Key (Up, Down, Left, Right) | Move to edge of budget |
Page Up | Function + Up Arrow Key | Move one screen up |
Page Down | Function + Down Arrow Key | Move one screen down |
Ctrl + Home | Function + Ctrl (^) + Left Arrow Key | Move to first cell in worksheet |
Ctrl + End | Function + Ctrl (^) + Right Arrow Key | Move to last cell in worksheet |
Home | Function + Left Arrow Key | Move to beginning of row |
End | Function + Right Arrow Key | Move to end of row |
Cell selection
Shortcut (Windows) | Shortcut (Mac) | Action |
|---|---|---|
Shift + Arrow Key (Any) | Shift + Arrow Key (Any) | Extend selection range by one cell |
Ctrl + Shift + Arrow Key (Any) | Ctrl (^) + Shift + Arrow Key (Any) | Extend selection range to edge of budget |
Shift + Home | Function + Shift + Right Arrow Key | Extend selection range to start of row |
Ctrl + Shift + Home | Function + Ctrl (^) + Shift + Left Arrow Key | Extend selection to first cell in budget |
Editing and entering data
Shortcut (Windows) | Shortcut (Mac) | Action |
|---|---|---|
Enter | Enter | Enter and move down |
Shift + Enter | Shift + Enter | Enter and move up |
Tab | Tab | Enter and move right |
Shift + Tab | Shift + Tab | Enter and move left |
F2 | Function + F2 | Enter edit mode for selected cell |
Esc | Esc | Cancel cell edit |
Delete | Function + Delete | Delete contents of selected cell |
Backspace | Backspace | Enter edit mode for selected cell, deleting cell contents |