Methodox Formula answers the keys below. The first tables are the menu commands that have a key, generated from the window itself; 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.
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 |
Edit
| Key |
Command |
Ctrl+Z |
Edit ▸ Undo |
Ctrl+Y |
Edit ▸ Redo |
Ctrl+X |
Edit ▸ Cut |
Ctrl+C |
Edit ▸ Copy |
Ctrl+V |
Edit ▸ Paste |
Ctrl+Shift+V |
Edit ▸ Paste Special ▸ Paste Special… |
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… |
Ctrl+G |
Edit ▸ Go To…, a second key for it |
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+Q |
Data ▸ SQL Workbench |
Alt+F5 |
Data ▸ PivotTable ▸ Refresh |
Ctrl+Alt+F5 |
Data ▸ PivotTable ▸ Refresh All |
| Key |
Command |
Ctrl+B |
Format ▸ Bold |
Ctrl+I |
Format ▸ Italic |
Ctrl+U |
Format ▸ Underline |
Ctrl+1 |
Format ▸ Cells… |
| Key |
Command |
Alt+F11 |
Tools ▸ Scripts |
Window
| Key |
Command |
Ctrl+F6 |
Window ▸ Next Document |
Ctrl+Shift+F6 |
Window ▸ Previous Document |
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 |
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 |
Enter F2 |
Edit the active cell |
| Any character |
Start typing over the active cell |
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 |
Editing a cell
| Key |
What it does |
Enter |
Confirm and move down |
Shift+Enter |
Confirm and move up |
Alt+Enter |
Confirm the entry into every cell of the selection |
Ctrl+Enter |
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 |
F2 |
Switch between pointing at cells and moving the caret in the text |
← → ↑ ↓ while typing a formula |
Point at a cell; with Shift, at a range |
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 |
| 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 |
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, Tab does not move to the next cell, Ctrl+Shift+Enter does not enter an array formula (spilling formulas do not need it), and there are no keys for selecting a whole row or column.
In the Scripts pane
Tools ▸ Scripts (Alt+F11) opens the script editor under the document. While the editor has the keyboard, its own keys win over the window's: Ctrl+F searches the script rather than the document, and Ctrl+D deletes a line.
| Key |
What it does |
Ctrl+Enter |
Run the 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 unindent by two spaces |
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 |
See also
