Excel
1

Learn

30 shortcuts · 0 practiced

Copy

General

Copy the selected cells.

Ctrl+C

Paste

General

Paste clipboard contents.

Ctrl+V

Cut

General

Cut the selected cells.

Ctrl+X

Undo

General

Undo the last action.

Ctrl+Z

Redo

General

Redo the last undone action.

Ctrl+Y

Save

General

Save the workbook.

Ctrl+S

Find

Navigation

Open the Find dialog.

Ctrl+F

Find & Replace

Navigation

Open Find and Replace.

Ctrl+H

Bold

Formatting

Toggle bold on selected cells.

Ctrl+B

Italic

Formatting

Toggle italic on selected cells.

Ctrl+I

Underline

Formatting

Toggle underline on selected cells.

Ctrl+U

Select All

Selection

Select all cells in the worksheet.

Ctrl+A

Select Column

Selection

Select the entire column.

Ctrl+Space

Select Row

Selection

Select the entire row.

Shift+Space

Insert Row

Editing

Insert a new row above.

Ctrl+Shift+=

Delete Row/Column

Editing

Delete the selected row or column.

Ctrl+-

AutoSum

Formulas

Insert a SUM formula.

Alt+=

Edit Cell

Editing

Enter edit mode for the active cell.

F2

Fill Down

Editing

Fill the cell below with the content above.

Ctrl+D

Fill Right

Editing

Fill the cell right with the content left.

Ctrl+R

New Worksheet

Sheets

Insert a new worksheet.

Shift+F11

Next Sheet

Navigation

Switch to the next worksheet tab.

Ctrl+

Previous Sheet

Navigation

Switch to the previous worksheet tab.

Ctrl+

Format Cells

Formatting

Open the Format Cells dialog.

Ctrl+1

Currency Format

Formatting

Apply currency format to selected cells.

Ctrl+Shift+4

Percent Format

Formatting

Apply percentage format to selected cells.

Ctrl+Shift+5

Go To

Navigation

Open the Go To dialog.

Ctrl+G

Toggle Absolute Reference

Formulas

Toggle absolute/relative cell reference in formula.

F4

Insert Today's Date

Editing

Insert the current date.

Ctrl+;

Insert Current Time

Editing

Insert the current time.

Ctrl+Shift+;