Editing

Entering Data

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

Action	Shortcut
Edit existing cell	F2
Confirm and move down	Enter
Confirm and move right	Tab
Confirm and move up	Shift+Enter
Confirm and move left	Shift+Tab
Cancel editing	Escape
Clear cell contents	Delete

Clipboard Operations

Action	Shortcut
Copy	Ctrl+C
Cut	Ctrl+X
Paste	Ctrl+V
Undo	Ctrl+Z
Redo	Ctrl+Y

Fill Operations

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.

Insert and Delete

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.

Date and Time

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

Paste Special

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

Paste Types

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)

Operations

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

Options

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

Keyboard Shortcuts in Dialog

Key	Action
↑/↓	Navigate options
Tab	Switch between sections
A/V/F/O	Quick select paste type
+/-/*/	Quick select operation
T	Toggle transpose
B	Toggle skip blanks
Enter	Execute paste
Escape	Cancel