Formula Keyboard Shortcuts

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.

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

Format

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…

Tools

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