Keyboard Shortcuts

Keyboard Shortcuts 


 

CTRL+9

Hides the selected rows.

CTRL+0

Hides the selected columns.


CTRL+A

Selects the entire worksheet.

If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.

CTRL+B

Applies or removes bold formatting.

CTRL+C

Copies the selected cells.

CTRL+D

Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.

CTRL+F

Displays the Find and Replace dialog box, with the Find tab selected.

CTRL+N

Creates a new, blank workbook.

CTRL+T

Displays the Create Table dialog box.

CTRL+V

Inserts the contents of the Clipboard

CTRL+X

Cuts the selected cells.

CTRL+Y

Repeats the last command or action, if possible.

CTRL+Z

Uses the Undo command to reverse the last command or to delete the last entry that you typed.

 


CTRL+SPACEBAR

Selects an entire column in a worksheet.

SHIFT+SPACEBAR

Selects an entire row in a worksheet.

CTRL+SHIFT+SPACEBAR

Selects the entire worksheet.

 


CTRL+ ~ (Tilde symbol)

Shows all formulas.

CTRL+HOME

Moves to the beginning of a worksheet.

 

Reference 


Links 

 

Keyboard shortcuts in Excel 

10 top Excel keyboard shortcuts