Link Search Menu Expand Document
Excel toolbox

6.2 Time-saving shortcuts


Keyboard shortcuts Meaning
Ctrl + S Save an Excel file
Ctrl + C Copy
Ctrl + V Paste
Ctrl + Spacebar Selection of the current column
Shift + Spacebar Selection of the current row
F2 Modify the current cell
Shift + F3 Insert a formula
Ctrl + G Bold
Ctrl + I Italicize
Ctrl + % Percentage format
Ctrl + - Delete a row or column
Ctrl + + Insert a row or column
Alt + ( Hide selected columns
Alt + Hide selected rows
F4 Freeze a cell, column, or row when entering a formula
Ctrl + Arrow Freeze a cell, column, or row when entering a formula
Ctrl + Shift + Arrow Select the entire data table
Delete Clear the contents of an Excel cell
Ctrl + F Find and replace a value
Shift + F2 Enter content as a comment