Keyboard shortcuts worth learning in Grid by Zaweba
The keyboard shortcuts in Grid by Zaweba follow spreadsheet standards: Ctrl+arrows, F2, F4, Ctrl+1, Alt+= and more, all listed under Help.
Reaching for the mouse a few hundred times a day adds up. Grid by Zaweba uses the spreadsheet-standard keyboard shortcuts, so if you've learned them elsewhere they work here, and if you haven't, a handful will make a real difference. Help, then Keyboard Shortcuts, lists them all.
Moving around
The arrow keys move one cell. Ctrl with an arrow jumps to the edge of the data in that direction, which is the fastest way to reach the bottom of a long list or the last column of a wide one. Ctrl+Home goes to the top left of the sheet and Ctrl+End to the last used cell. PgUp and PgDn move a screen at a time.
Ctrl+A selects all, which is the starting point for formatting or copying a whole block at once.
Editing
F2 edits the current cell without retyping it, which is the quick way to fix one character in a long formula. F4, while you're typing a reference, cycles the dollar signs: fixed row and column, fixed row, fixed column, neither. Getting this right is the key to formulas that fill down properly, and F4 is far quicker than typing the dollar signs by hand.
Ctrl+Z undoes and Ctrl+Y redoes, with 100 steps of history for every kind of change. Ctrl+B, Ctrl+I and Ctrl+U set bold, italic and underline. Ctrl+1 opens Format Cells, the door to number formats, alignment, fonts, borders, fills and protection.
Formulas and finding
Alt+= inserts an AutoSum below a column or beside a row. F9 works the sheet out again. Ctrl+F opens Find, Ctrl+H opens Replace and Ctrl+G or F5 opens Go To, which jumps to a cell address or a name.
F11 makes a chart from the selected data in one keystroke. Select a small table with headings and press it to see the figures as a chart straight away, then adjust it from there.
AI, when you want it
If you've connected your own AI account, Ctrl+Shift+I opens the Ask AI panel. Nothing is sent until you ask a question, and the AI actions stay greyed out until an account is connected.
Shortcuts in a typical session
It helps to see how a few of these chain together. Say you've pasted a month of bank transactions into a sheet. Ctrl+Home takes you to the top. Ctrl with the down arrow takes you to the last row, so you can see how many lines arrived. In the empty cell below the amounts, Alt+= adds a total. Back at the top, you write a formula for a running balance, using F4 to fix the reference to the opening balance cell, and fill it down. Ctrl+1 gives the amount columns a currency format. Ctrl+F finds the transaction you were looking for in the first place. Not one trip to the mouse, and the whole job takes a couple of minutes.
The same handful of keys covers most everyday work, whether it's a budget, a register of names or a list of stock.
Learning them without trying too hard
Don't try to learn every shortcut at once. Pick the three that fit what you do most: perhaps Ctrl+arrows for moving, F2 for editing and F4 for references. Use them for a week until they're automatic, then add three more. Ctrl+1 and Alt+= are good second choices for most people.
Keep Help, Keyboard Shortcuts in mind for the rest. When you catch yourself doing something repeatedly with the mouse, look it up there.
On a Mac, Grid by Zaweba uses Cmd shortcuts in place of Ctrl, so the same habits carry across.
