a corridor is a handful of flights, not a hundred steps — and a range is one press, not a hundred cells.
Solid walls carve one long switchback corridor from your empty corner to the model block. Ride the straightaways, turn at the corners and collect every checkpoint on the way. Land on the block and the walls come down: a regional sales table stands in the corner and a memo names four ranges to capture — one region across the quarters, one quarter down every region, the whole table, and every typed figure on it (one FY figure was keyed by hand and hides among the formulas). Then copy the table, bring it home to the marked room at A1 and save.
Ctrl+→⌘→ on macJump to the edge of the data region
Edge-jumping crosses a wide page in two keystrokes — the horizontal version of the same move.
Ctrl+↓⌘↓ on macJump to the edge of the data region
Edge-jumping crosses a 500-row tape in two keystrokes instead of a held-down arrow key.
Ctrl+←⌘← on macJump to the edge of the data region
Edge-jumping crosses a wide page in two keystrokes — the horizontal version of the same move.
Shift+Space⇧Space on macSelect the entire row
Select the whole row — pair it with Ctrl+Shift+= to insert, Ctrl+- to delete.
Ctrl+Space⌘Space on macSelect the entire column
Select the whole column — the setup move for inserting, deleting, or formatting column-wide.
Ctrl+A⌘A on macSelect the current region, then the whole sheet
F5fn F5 on macGo To — jump anywhere by reference
Go To jumps to any reference on the tab — long-distance travel on big pages.
Ctrl+C⌘C on macCopy
Copy starts almost every hand-off — grab a finished block once, then place it in the summary, the deck, or next quarter’s column.
the par-setting sequence, straight through:
ride each straightaway with ctrl+arrows → the row shift+space · the column ctrl+space · the table ctrl+a · every typed figure f5 s o → ctrl+c → ctrl+home → ctrl+v → ctrl+s