Excel Frequently Used Shortcuts

Question 1

Close A Spreadsheet

Answer 1

CTRL+W

Question 2

Open A Spreadsheet

Answer 2

CTRL+O

Question 3

Go To The Home Tab

Answer 3

ALT+H

Question 4

Save A Spreadsheet

Answer 4

CTRL+S

Question 5

Copy

Answer 5

CTRL+C

Question 6

Paste

Answer 6

CTRL+V

Question 7

Undo

Answer 7

CNTRL+Z

Question 8

Remove Cell Contents

Answer 8

Delete Key

Question 9

Choose A Fill Color

Answer 9

ALT+H,H

Question 10

Cut

Answer 10

CTRL+X

Question 11

Go To Insert Tab

Answer 11

ALT+N

Question 12

Bold

Answer 12

CTRL+B

Question 13

Center Align Cells Contents

Answer 13

ALT+H,A, then C

Question 14

Go To Page Layout Tab

Answer 14

ALT+P

Question 15

Go To Data Tab

Answer 15

ALT+A

Question 16

Go To View Tab

Answer 16

ALT+W

Question 17

Open Context Menu

Answer 17

Shift+F10 or Context Key

Question 18

Add Borders

Answer 18

ALT+H,B

Question 19

Move to the previous cell in a worksheet or the previous option in a dialog box.

Answer 19

Shift+Tab

Question 20

Move one cell up in a worksheet.

Answer 20

Up Arrow Key

Question 21

Move one cell down in a worksheet

Answer 21

Down Arrow Key

Question 22

Move one cell left in a worksheet.

Answer 22

Left Arrow Key

Question 23

Move one cell right in a worksheet.

Answer 23

Right Arrow Key

Question 24

Move to the edge of the current data region in a worksheet.

Answer 24

CTRL+Arrow Key

Question 25

Enter End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the Cell is blank, move to the last cell in the row or column.

Answer 25

End, arrow key

Question 26

Move to last cell on a worksheet, to the lowest used row of the rightmost used column.

Answer 26

CNTRL+End

Question 27

Extend the selection of cells to the last used cell on the worksheet (lower-right corner).

Answer 27

CTRL+Shift+End

Question 28

Move to cell in upper left corner of the window when Scroll Lock is on.

Answer 28

Home+Scroll Lock

Question 29

Move to the beginning of a worksheet.

Answer 29

CTRL+Home

Question 30

Move one screen down in a worksheet.

Answer 30

Page Down

Question 31

Move to the next sheet in a workbook.

Answer 31

CNTRL+Page Down

Question 32

Move one screen to the right in a worksheet.

Answer 32

ALT+Page Down

Question 33

Move one screen up in a worksheet.

Answer 33

Page Up

Question 34

Move one sheet to the left in a worksheet.

Answer 34

ALT+Page Up

Question 35

Move to the previous sheet in a workbook.

Answer 35

CNTRL+Page Up

Question 36

Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells.

Answer 36

Tab