Editing

Entering Data

Simply start typing to enter data in the selected cell. The previous content will be replaced.

Action	Shortcut
Fill down	`Ctrl+D`
Fill right	`Ctrl+R`

Select a range where the first cell has content, then use Fill Down/Right to copy that content to all selected cells.

Action	Shortcut
Insert row/column	`Ctrl+Shift+=`
Delete row/column	`Ctrl+-`

When a full row is selected (via Shift+Space), these commands affect rows. When a full column is selected (via Ctrl+Space), they affect columns.

Action	Shortcut
Insert current date	`Ctrl+;`
Insert current time	`Ctrl+Shift+;`

Dates are inserted in M/D/YYYY format (e.g. 2/7/2026). Times use h:MM AM/PM format (e.g. 3:45 PM).

Action	Shortcut
Copy formula from above	`Ctrl+'`
Copy display value from above	`Ctrl+Shift+"`

Ctrl+' copies the raw formula (adjusting relative references down one row), while Ctrl+Shift+" copies the computed display value as plain text.

Press Ctrl+Alt+V after copying cells to open the Paste Special dialog.

Type	Description
All	Paste everything (default)
Values	Paste computed values only (no formulas)
Formulas	Paste formulas only (no formatting)
Formats	Paste formatting only (no data)

Apply a mathematical operation to existing cell values:

Operation	Effect
None	Replace existing values
Add	Add pasted values to existing
Subtract	Subtract pasted values from existing
Multiply	Multiply existing by pasted values
Divide	Divide existing by pasted values

Option	Description
Transpose	Swap rows and columns
Skip Blanks	Don’t overwrite cells with blank source cells