Selection

Basic Selection

Action	Shortcut
Extend selection	Shift+Arrow
Extend to edge of data	Ctrl+Shift+Arrow
Select all cells	Ctrl+A
Select entire column	Ctrl+Space
Select entire row	Shift+Space
Extend selection to A1	Ctrl+Shift+Home
Extend selection to last cell	Ctrl+Shift+End

Multi-Selection

Action	Method
Add cell to selection	Ctrl+Click
Extend selection	Shift+Click
Select column	Click column header
Select row	Click row number

Multi-Edit (Edit Multiple Cells at Once)

When multiple cells are selected, typing affects all selected cells simultaneously with live preview and smart formula shifting.

How it works

1. Select multiple cells using Ctrl+Click or Shift+Click
2. Start typing — all selected cells show a preview of what they’ll receive
3. Press Ctrl+Enter (Cmd+Enter on macOS) to apply to all selected cells. Enter applies to the active cell only, and Escape cancels

Formula Reference Shifting

When entering a formula with multi-selection, relative references automatically shift based on each cell’s position relative to the primary cell:

Example: Select D1, E2, F3 (Ctrl+Click), type =A1*2

While typing, you see:
  D1: =A1*2     (active edit cell)
  E2: =B2*2     (dimmed preview - shifted by +1 row, +1 col)
  F3: =C3*2     (dimmed preview - shifted by +2 rows, +2 cols)

Press Ctrl+Enter → all three formulas are applied with shifted references

Reference types

• Relative (A1): Shifts with each cell’s position
• Absolute ($A$1): Stays fixed in all cells
• Mixed ($A1 or A$1): Partially shifts

Fill Selection (Ctrl+Enter)

In navigation mode with multi-selection, press Ctrl+Enter to fill all selected cells with the primary cell’s content (with formula shifting).

Action	Shortcut
Apply edit to all selected cells	Ctrl+Enter
Apply edit to the active cell only	Enter
Fill selection from primary cell	Ctrl+Enter
Cancel multi-edit	Escape

Status bar hints:

• Navigation mode: “Type to edit · Ctrl+Enter fills selection”
• Edit mode: “Enter: this cell · Ctrl+Enter: apply to selection · Esc: cancel”

On macOS with the default platform modifier style, these read Cmd+Enter.