Basic Editing12
Ctrl+C
Copy
Copy the selected cells.
Ctrl+X
Cut
Cut the selected cells.
Ctrl+V
Paste
Paste the copied content.
Ctrl+Shift+V
Paste Values Only
Paste values without formatting.
Ctrl+Z
Undo
Undo the last action.
Ctrl+Y
Redo
Redo the last undone action.
Ctrl+A
Select All
Select the entire sheet.
Ctrl+F
Find
Search cell contents.
Ctrl+H
Find & Replace
Find and replace content.
Delete
Delete Content
Delete the content of selected cells.
F2
Edit Cell
Enter edit mode for the selected cell.
Escape
Cancel Edit
Cancel the current edit.
Cell Navigation10
Ctrl+Home
Go to A1
Jump to the first cell of the spreadsheet.
Ctrl+End
Go to Last Cell
Jump to the last cell with data.
Ctrl+Right
Right Edge
Jump to the right edge of the data range.
Ctrl+Left
Left Edge
Jump to the left edge of the data range.
Ctrl+Down
Bottom Edge
Jump to the bottom edge of the data range.
Ctrl+Up
Top Edge
Jump to the top edge of the data range.
Ctrl+G
Go to Range
Navigate to a specific cell address or range.
Tab
Move Right
Move to the cell on the right.
Shift+Tab
Move Left
Move to the cell on the left.
Enter
Move Down
Move to the cell below after input.
Rows & Columns6
Ctrl+Shift++
Insert Row/Column
Insert a row or column at the selected position.
Ctrl+-
Delete Row/Column
Delete the selected row or column.
Ctrl+Space
Select Column
Select the entire current column.
Shift+Space
Select Row
Select the entire current row.
Ctrl+Shift+9
Hide Rows
Hide the selected rows.
Ctrl+Shift+0
Hide Columns
Hide the selected columns.
Formatting11
Ctrl+B
Bold
Apply or remove bold formatting.
Ctrl+I
Italic
Apply or remove italic formatting.
Ctrl+U
Underline
Apply or remove underline.
Alt+Shift+5
Strikethrough
Apply strikethrough to selected text.
Ctrl+Shift+1
Number Format
Apply number format with 2 decimal places.
Ctrl+Shift+3
Date Format
Apply date format.
Ctrl+Shift+4
Currency Format
Apply currency format.
Ctrl+Shift+5
Percent Format
Apply percentage format.
Ctrl+D
Fill Down
Copy the content of the top cell downward.
Ctrl+R
Fill Right
Copy the content of the left cell rightward.
Ctrl+E
Smart Fill
Auto-fill based on detected patterns.
Formulas5
F4
Toggle Absolute/Relative Reference
Cycle through $A$1 → A$1 → $A1 → A1.
Ctrl+`
Show Formulas
Toggle between showing values and formulas.
Ctrl+;
Insert Today's Date
Insert the current date into the cell.
Ctrl+Shift+:
Insert Current Time
Insert the current time into the cell.
Ctrl+Shift+Enter
Array Formula
Enter as an array formula.
No shortcuts found