excel shortcuts

Ctrl+W

Close a spreadsheet

Ctrl+O

Open a spreadsheet

Alt+ H

Go to Home Tab

Ctrl+ S

Save a spreadsheet

Ctrl+ C

Copy

Ctrl+V

Paste

Ctrl+Z

Undo

Delete Key

remove cell contents

Alt H, H

Choose a fill color

Ctrl + X

Cut

Alt +N

Go to insert tab

Ctrl+B

Bold

Alt+H, A, then c

Center align cell contents

Alt + P

Go to page Layout Tab

Alt + A

Go to Data Tab

Alt + W

Go to view tab

Shift+ F10 or Context Key

format a cell from context menu

Alt +H, B

Add borders

Alt+ H,D then C

delete column

Alt+M

go to formula tab

Ctrl+ P

print

Alt+ P

Go to page layout tab

Alt+ A

go to data tab

Alt+ M

open formulas tab and insert, trace, and customize functions and calculations.

Alt + R

open the review tab, and check spelling, add comments, and protect sheets and workbooks

Spacebar or enter

activate a selected button

alt + down arrow

open the menu for a selected button - work in ribbon tabs

Ctrl+F1

Expand or collapse the ribbon

shift+F10

Open a context menu

shift +tab

• move to the previous cell in a worksheet or the previous option in a dialog box

ctrl + arrow key

move to the edge of the current data region in a worksheet

end, arrow key

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 cells are blank, move to the last cell in the row or column.

ctrl+ shift + end

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

ctrl + end

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

home + scroll lock

move to the cell in the upper left corner of the window then scroll lock is turned on

ctrl+ home

move to the beginning of a row in a worksheet. home move to the beginning of a worksheet

page down

move one screen down in a worksheet

Ctrl +pagedown

move to the next sheet in a workbook

ctrl+page up

move to the previous sheet in a workbook

Ctrl+Shift+ Plus

insert blank cells with the insert dialog box

Ctrl + apostrophe (“)

copy a formula from the cell above the active cell in the the cell or the formula bar

ctrl + Alt + V

paste content by using the paste special dialog box

ctrl A or Ctrl + shift+ spacebar

select the entire worksheet

ctrl + shift + arrow key

extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell

alt + enter

start a new line in the same cell

ctril + spacebar

select an entire column in a worksheet

shift + spacebar

select an entire row in a worksheet