You can drive TukeySheets entirely from the keyboard, and it is faster than the mouse. Everything you need reduces to three groups of motions: move the cursor, select a region, and build formulas by pointing. Learn the small set of keys below and you will rarely reach for the mouse again.
A grid is just a coordinate system, and your keyboard already knows how to address it. Reaching for the mouse every time you want to move is the fastest way to feel slow. The rest of this post is the antidote: a hands-on tour organized around those three groups. Open a sheet and do each motion as you read. Like vimtutor, the point is the muscle memory, not the prose.
Set up the practice data
We will use the classic iris dataset: 150 flowers, five columns (sepal_length, sepal_width, petal_length, petal_width, and species). It does not ship with TukeySheets, but it is one of the most widely available public datasets and downloadable as a CSV from many sources. Grab a copy, then open the CSV in TukeySheets. You should see a header row and 150 rows of data below it.
Press Cmd+Up then Cmd+Left to jump to cell A1, then put the mouse away.
This walkthrough is for macOS with the default keybindings. The jump keys use Cmd, because macOS reserves
Ctrlplus the arrow keys for Mission Control and Spaces. Every binding is remappable in your config, so if you have changed them, your bindings win.
Move the cursor: nudge with arrows, travel by landmarks
The fastest navigation is not about steps, it is about jumping to landmarks. Arrows handle the small nudges; the Cmd jumps handle everything else.
Arrow keys move the active cell one step at a time. This is the foundation, and everything else is a faster version of it. From A1, press Down a few times to walk down the first column, then Right to step across. One cell at a time is fine for nudging, but you would be here all day scrolling to row 150.
Cmd+Arrow jumps to the edge of a contiguous block of data, which is the landmark that matters most. From A1, press Cmd+Down and you land on A151, the last flower in the column, in one keystroke instead of 150. Press it again to shoot past the data to the bottom of the sheet; Cmd+Up brings you back. This is how you traverse a large table: edge to edge, not cell by cell. It is also why the jump is Cmd and not Ctrl: on macOS Ctrl plus an arrow triggers Mission Control and switches Spaces, so the keystroke would never reach the grid.
Cmd+Arrow combinations reach the corners:
- Cmd+Up then Cmd+Left lands on
A1, the top-left of the sheet. Your reset button. - Cmd+Down then Cmd+Right lands on the bottom-right corner of the used range. For iris that is the last
speciescell, which answers "how big is this thing?" at a glance.
Practice the loop: trace the perimeter with Cmd+Down, Cmd+Right, Cmd+Up, Cmd+Left. That is the whole table under four fingers.
F5 opens Go To when you already know the address. Type a cell like D120 and press Enter to land there, or type a range like A2:E10 to select it. For a 150-row sheet this is a nicety; for a 100,000-row sheet it is essential.
Select a region: movement with Shift, plus three shortcuts
Selection is the same movement vocabulary with Shift held down: the active cell stays anchored and a highlighted range grows from it. Three shortcuts cover the cases where plain Shift is too slow.
Shift plus any motion extends the selection:
- Shift+Arrow extends one cell.
- Cmd+Shift+Arrow extends all the way to the data edge.
Try it: put the cursor on B2, the first sepal_width value, and press Cmd+Shift+Down. The entire sepal_width column is selected, from B2 to B151, in one move. Glance at the status bar: TukeySheets shows a live count, sum, and average of the selected numbers, so you just summarized a column without typing a formula. Add Shift+Right a couple of times and the stats expand to cover the wider block.
Shift+Space and Ctrl+Shift+Space grab a whole row or column, header and all, regardless of where the data ends. Click into any species cell and press Ctrl+Shift+Space for the full column, or Shift+Space for the full row. These pair naturally with insert and delete. The column shortcut keeps Ctrl here because macOS reserves Cmd+Space for Spotlight, so the extra Shift sidesteps the clash.
F8 and Shift+F8 let you stop holding Shift, a trick borrowed from the old keyboard-driven spreadsheets:
- F8 toggles Extend Selection mode, so plain arrows and Cmd jumps extend the selection as if Shift were held. Press F8 again to release.
- Shift+F8 toggles Add to Selection mode, which freezes the current selection and starts a second, separate one, so you can select three non-adjacent columns and stat them together.
Try it: press F8, then Cmd+Down, Right, Cmd+Up. You drew a rectangle with no Shift involved. Press F8 to release.
Build formulas by pointing: point mode
When you are typing a formula, the same navigation keys stop moving the cursor and start pointing: each move inserts a cell reference into the formula. This is point mode, and it is where the navigation keys pay off twice. You build a formula by hand-eye instead of by spelling out coordinates.
Compute the average petal length by pointing:
- Navigate to an empty cell below the data. Cmd+Down to the bottom of column A, then Right twice and Down once to land just under
petal_length. - Press F2 to start editing, then type
=MEAN(. - Press the arrow keys. The cursor now points at a cell and its reference appears in the formula. Move to the top of
petal_lengthatC2, then hold Cmd+Shift+Down to point at the whole column. The formula now reads=MEAN(C2:C151. - Type the closing
)and press Enter.
You built and confirmed =MEAN(C2:C151), which is about 3.76, without typing a single cell address by hand. Point mode even works across sheets: mid-formula, switch to another tab, point at a range there, and the reference comes back qualified with the sheet name.
The whole vocabulary on one card
| Goal | Keys |
|---|---|
| Move one cell | Arrow keys |
| Jump to data edge | Cmd+Arrow |
| Top-left of sheet | Cmd+Up, then Cmd+Left |
| Bottom-right of sheet | Cmd+Down, then Cmd+Right |
| Go to an address | F5 |
| Extend selection | Shift+Arrow, Cmd+Shift+Arrow |
| Whole row / whole column | Shift+Space / Ctrl+Shift+Space |
| Selection mode (no Shift) | F8, Shift+F8 |
| Begin editing a cell | F2 |
| Point at refs while editing | Arrow keys mid-formula |
None of it is exotic. It is the same handful of motions a touch typist uses in any serious spreadsheet, grouped into move, select, and build. Spend ten minutes doing laps around the iris sheet and the mouse will start to feel like the slow option it is.