Methodox Formula answers the keys below. The first tables are the menu commands that have a key, generated from the window itself, and the other keys the window binds; the later ones are the keys of the grid, the cell being edited and the sheet tabs. Every menu shows its item's key beside it, and hovering over a toolbar button shows its name. F10, or Alt and a menu's underlined letter, opens the menus from the keyboard.
Menu commands
File
| Key |
Command |
Ctrl+N |
File ▸ New |
Ctrl+O |
File ▸ Open… |
Ctrl+S |
File ▸ Save |
Ctrl+Shift+S |
File ▸ Save As… |
Ctrl+P |
File ▸ Print… |
Ctrl+W |
File ▸ Close |
Ctrl+Q |
File ▸ Exit |
Edit
| Key |
Command |
Ctrl+Z |
Edit ▸ Undo |
Ctrl+Y |
Edit ▸ Redo |
Ctrl+Shift+Y |
Edit ▸ Repeat |
Ctrl+X |
Edit ▸ Cut |
Ctrl+C |
Edit ▸ Copy |
Ctrl+V |
Edit ▸ Paste |
Ctrl+Shift+V |
Edit ▸ Paste Special ▸ Paste Special… |
Ctrl+Alt+Shift+V |
Edit ▸ Paste Special ▸ Unformatted Text |
Ctrl+F |
Edit ▸ Find… |
Ctrl+H |
Edit ▸ Find and Replace… |
F3 |
Edit ▸ Find Next |
Shift+F3 |
Edit ▸ Find Previous |
Ctrl+A |
Edit ▸ Select All |
F5 |
Edit ▸ Go To… |
Ctrl+; |
Edit ▸ Insert Current Date |
Ctrl+Shift+; |
Edit ▸ Insert Current Time |
Backspace |
Edit ▸ Delete Contents… |
View
| Key |
Command |
Ctrl+Shift+U |
View ▸ Expand Formula Bar |
| `Ctrl+`` |
View ▸ Show Formula |
Ctrl+Shift+J |
View ▸ Full Screen |
Insert
| Key |
Command |
Ctrl+T |
Insert ▸ Table… |
Ctrl+F2 |
Insert ▸ Function… |
Ctrl+Alt+C |
Insert ▸ Comment… |
Ctrl+K |
Insert ▸ Hyperlink… |
Sheet
| Key |
Command |
Ctrl+Keypad + |
Sheet ▸ Insert Cells… |
Ctrl+Keypad - |
Sheet ▸ Delete Cells… |
Ctrl+D |
Sheet ▸ Fill Down |
Ctrl+R |
Sheet ▸ Fill Right |
Data
| Key |
Command |
Ctrl+Shift+L |
Data ▸ AutoFilter |
Ctrl+Shift+Q |
Data ▸ SQL Workbench |
Alt+F5 |
Data ▸ PivotTable ▸ Refresh |
Ctrl+Alt+F5 |
Data ▸ PivotTable ▸ Refresh All |
F9 |
Data ▸ Calculate ▸ Recalculate |
Ctrl+Shift+F5 |
Data ▸ Refresh Data |
| Key |
Command |
Ctrl+B |
Format ▸ Bold |
Ctrl+I |
Format ▸ Italic |
Ctrl+U |
Format ▸ Underline |
Ctrl+Shift+P |
Format ▸ Text ▸ Superscript |
Ctrl+Shift+B |
Format ▸ Text ▸ Subscript |
Ctrl+] |
Format ▸ Text ▸ Increase Font Size |
Ctrl+[ |
Format ▸ Text ▸ Decrease Font Size |
| `Ctrl+Shift+`` |
Format ▸ Number Format ▸ General |
Ctrl+Shift+1 |
Format ▸ Number Format ▸ Number |
Ctrl+Shift+4 |
Format ▸ Number Format ▸ Currency |
Ctrl+Shift+5 |
Format ▸ Number Format ▸ Percent |
Ctrl+Shift+3 |
Format ▸ Number Format ▸ Date |
Ctrl+Shift+2 |
Format ▸ Number Format ▸ Time |
Ctrl+Shift+6 |
Format ▸ Number Format ▸ Scientific |
Ctrl+9 |
Format ▸ Rows ▸ Hide Rows |
Ctrl+Shift+9 |
Format ▸ Rows ▸ Show Rows |
Ctrl+0 |
Format ▸ Columns ▸ Hide Columns |
Ctrl+Shift+0 |
Format ▸ Columns ▸ Show Columns |
Ctrl+1 |
Format ▸ Cells… |
| Key |
Command |
F7 |
Tools ▸ Spelling… |
Shift+F7 |
Tools ▸ Automatic Spell Checking |
Shift+F9 |
Tools ▸ Detective ▸ Trace Precedents |
Shift+F5 |
Tools ▸ Detective ▸ Trace Dependents |
Alt+F11 |
Tools ▸ Scripts |
Document
| Key |
Command |
Ctrl+F6 |
Document ▸ Next Document |
Ctrl+Shift+F6 |
Document ▸ Previous Document |
Help
| Key |
Command |
F1 |
Help ▸ Documentation |
Other keys
| Key |
Command |
Ctrl+G |
Edit ▸ Go To…, a second key for it |
Ctrl+L |
Insert ▸ Table…, a second key for it |
Alt+= |
Data ▸ AutoSum |
F4 |
Repeat the last action on the selection |
Shift+F2 |
Insert ▸ Comment…, a second key for it |
Ctrl+Shift+7 |
Outline the selection with a border |
Ctrl+Shift+- |
Remove the selection's borders |
Ctrl+- |
Sheet ▸ Delete Cells… |
Ctrl+Shift+= |
Sheet ▸ Insert Cells… |
Shift+F11 |
Insert a sheet |
Ctrl+' |
Copy the formula from the cell above |
Ctrl+Shift+' |
Copy the value from the cell above |
Ctrl+Shift+O |
Select the cells with comments |
Ctrl+PgDn |
Next sheet |
Ctrl+PgUp |
Previous sheet |
Ctrl+Tab |
Next open document, while the document has the keyboard |
Ctrl+Shift+Tab |
Previous open document, while the document has the keyboard |
Moving and selecting in the grid
| Key |
What it does |
← → ↑ ↓ |
Move the active cell |
Ctrl+← Ctrl+→ Ctrl+↑ Ctrl+↓ |
Jump to the edge of the block of data |
Shift with any movement key |
Extend the selection |
Enter Shift+Enter |
Move down or up (or as set in Edit ▸ Options ▸ Formula); inside a selection, to the next or previous cell of it |
Tab Shift+Tab |
Move right or left; inside a selection, to the next or previous cell of it |
Page Up Page Down |
One screen up or down |
Home |
Column A of the row |
Ctrl+Home |
Cell A1 |
End |
The last used column of the row |
Ctrl+End |
The end of the used range |
Ctrl+Space |
Select the column |
Shift+Space |
Select the row |
F2 |
Edit the active cell, with the arrows moving the caret |
| Any character |
Start typing over the active cell, with the arrows confirming and moving |
Delete |
Clear the contents of the selection |
Alt+↓ |
Open the cell's validation list |
Delete Backspace with a chart, picture or shape selected |
Delete it |
Esc with an object selected |
Deselect it; with the format painter armed, put it down |
Editing a cell
| Key |
What it does |
Enter |
Confirm and move down (or as set in Edit ▸ Options ▸ Formula); after a run of Tab, back to the column the run started in |
Shift+Enter |
Confirm and move up |
Tab Shift+Tab |
Confirm and move right or left |
← → ↑ ↓ |
Confirm and move, in a cell opened by typing; move the caret, in a cell opened with F2 or a double click |
F2 |
Switch between the two, and in a formula between pointing at cells and moving the caret |
Alt+Enter Ctrl+Enter |
Over a selected block, put the entry into every cell; in a single cell, a line break inside the cell |
Esc |
Cancel the edit |
F4 |
Cycle the reference under the caret through $A$1, A$1, $A1 and A1 |
← → ↑ ↓ while typing a formula |
Point at a cell where a reference can go; with Shift, at a range |
Enter on an AutoComplete suggestion |
Take it |
Ctrl+Backspace Ctrl+Delete |
Delete a word |
Ctrl+Z Ctrl+Y |
Undo or redo inside the cell |
In the formula bar, Enter confirms, Esc cancels and F4 cycles references in the same way. In the Name Box, Enter goes to the name or reference typed, or defines a new name for the selection.
Sheet tabs
| Key |
What it does |
← → |
Previous or next sheet, while the tabs have the keyboard |
F2 |
Rename the sheet |
Mouse
| Gesture |
What it does |
Ctrl + wheel |
Zoom |
Shift + wheel |
Scroll sideways |
Shift + click |
Extend the selection |
Ctrl + click |
Add another range to the selection; on a hyperlink, follow it |
| Double-click a cell |
Edit it |
| Double-click a column or row border |
Fit it to its contents |
| Drag the fill handle |
Fill a series; with Ctrl, copy instead |
| Double-click the fill handle |
Fill down as far as the column beside it goes |
| Drag a table's corner handle |
Grow or shrink the table |
| Click the format painter, double-click it |
Paint the next selection once; keep painting until Esc |
Ctrl or Shift + click a sheet tab |
Select several sheets |
In the SQL Workbench, Ctrl+Enter or F5 runs the statement.
Not yet: Ctrl+Page Up and Ctrl+Page Down do not change sheets, and Ctrl+Shift+Enter does not enter an array formula (spilling formulas do not need it).
In the Scripts tab
Tools ▸ Scripts (Alt+F11) opens the script editor in the bottom tray. While the editor has the keyboard, its own keys win over the window's: Ctrl+F searches the script rather than the document.
| Key |
What it does |
Ctrl+Enter |
Run the script |
Ctrl+Shift+Enter |
Run the selected lines |
Ctrl+N |
New script |
Ctrl+Space |
Show completions; typing . (or : in Lua) shows them too |
Enter Tab |
Accept a completion; Esc closes the list |
Tab Shift+Tab |
Indent or outdent the line or the selected lines |
Ctrl+/ |
Comment or uncomment the selected lines |
Ctrl+G |
Go to a line |
Ctrl+D |
Delete the line |
Insert |
Overtype on or off |
Ctrl+Backspace Ctrl+Delete |
Delete the word before or after the caret |
Alt+Shift+← Alt+Shift+→ Alt+Shift+↑ Alt+Shift+↓ |
Rectangular selection |
Ctrl+F |
Find in the script |
Ctrl+H |
Find and replace in the script |
F3 Shift+F3 |
Next or previous match |
Alt+R Alt+A |
Replace, or replace all, while the find bar is open |
Ctrl+Tab |
Leave the editor |
In the list of scripts:
| Key |
What it does |
Insert Ctrl+N |
New script |
F2 |
Rename the script |
Ctrl+D |
Duplicate the script |
Delete |
Delete the script, after asking |
In the Immediate tab:
| Key |
What it does |
Enter |
Run the line, and print its value |
Shift+Enter |
Start another line; in Python a line ending in a colon does too |
Ctrl+Enter |
Run the lines typed |
↑ ↓ |
Step through what was run before |
In the graph editor:
| Key or gesture |
What it does |
| Right-click on the empty canvas |
Add a node, from a searchable palette |
| Right-click a node, a wire or a graph's tab |
Its menu |
Middle-button drag, or drag with Alt or Space held |
Pan |
| Wheel |
Zoom at the pointer |
F |
Fit the graph |
Ctrl+X Ctrl+C Ctrl+V |
Cut, copy and paste nodes, with the wires among them |
Ctrl+D |
Duplicate the selected nodes |
Delete |
Delete the selected nodes |
Alt+click a wire |
Disconnect it |
Ctrl+Z Ctrl+Y |
Undo and redo the canvas's steps |
See also