Shortcut keys of Microsoft Excel

Here are some shortcut keys of Microsoft Excel, which make your work easier and faster.

Ctrl + N

To open a new workbook.

Ctrl + S

To save any active workbook.

Ctrl + O

To open any saved workbook.

Alt +F4

To close or exit active workbook.

Ctrl + P

To print data of active workbook. It can be whole work or any selected part of work

Ctrl + Z

To undo or undone any last action.

Ctrl + Y

To repeat or redo any undo or undone action.

Ctrl + I

To make selected text little italic.

Ctrl + B

To make selected text bold (dark).

Ctrl + C

To copy any selected data.

Ctrl + V

To paste any cut or copied data.

Ctrl + X

To cut any selected data. (copy and delete)

Ctrl + A

To select all or entire data of active sheet.

Ctrl + F

To find any word.

Ctrl + H

To replace any old word with new one.

Ctrl + +

To add or insert any cell, row or column.

Ctrl + -

To delete any cell, row or column.

Ctrl + K

To add or insert hyperlink .

Ctrl + G

To goto on any cell by providing address .

Enter

To move to next row.

Delete

To clear or delete data of selected range (area) .

F1

Help

F2

To edit data of active cell.

F7

To open spelling and grammar check dialog box.

Escape

To quit any dialog box.

Ctrl + ;

To insert current date .

Ctrl + Shift + ;

To insert current time.

Page Up

To move one page upward at one time.

Page Down

To move one page downward at one time.

Tab

To move to one cell right active position of cell.

Shift + Tab

To move to one cell left active position of cell.

Arrow keys

To move to one cell right/left/up/down active position of cell.

Shift + Arrow key

To select area or range according to need using arrows..

Exit mobile version