KeyTap Logo
Excel Icon

Excel

Organize, manipulate, and analyze data

Frequently used shortcuts:

Save a file

Ctrl

S

Save as

F12

Go to Home tab

Alt

H

Copy

Ctrl

C

Paste

Ctrl

V

Undo

Ctrl

Z

Find

Ctrl

F

Remove cell content

Delete

Choose a fill colour

Ctrl

H

Cut selection

Ctrl

X

Go to Insert tab

Alt

N

Bold

Ctrl

B

Italics

Ctrl

I

Underline

Ctrl

U

Center alignment

Alt

H

Go to Page Layout tab

Alt

P

Go to Data tab

Alt

A

Go to View tab

Alt

W

Add borders

Alt

H

Delete column

Alt

H

Go to Formula tab

Alt

M

Hide rows

Ctrl

9

Hide columns

Ctrl

0

Insert sheet

Shift

F11

Delete sheet

Alt

E

L

Navigation:

Move cell up / down

Move to the right cell

Tab

Move cell to the left

Shift

Tab

Move to beginning of a row

Home

Move to beginning of worksheet

Ctrl

Home

Move to last cell with content

Ctrl

End

Move to the left most cell

Ctrl

Move to the right most cell

Ctrl

Toggle worksheet, ribbon bar and zoom controls

F6

Switch to next worksheet

Ctrl

F6

Move screen up

PageUp

Move screen down

PageDown

Move screen left

Alt

PageUp

Move screen right 

Alt

PageDown

Move worksheet tab to left

Ctrl

PageUp

Move worksheet tab to right

Ctrl

PageDown

Cell formatting:

Apply border

Ctrl

Shift

&

Format cells dialog box

Ctrl

1

Remove border

Ctrl

Shift

_

Currency format

Ctrl

Shift

$

Number format

Ctrl

Shift

~

Date format

Ctrl

Shift

#

Time format

Ctrl

Shift

@

Insert hyperlink

Ctrl

K

Strikethrough

Ctrl

5

Increase font size

Alt

H

+

F

+

G

Decrease font size

Alt

H

+

F

+

K

Format painter

Ctrl

Alt

V

Selections:

Select row

Shift

Select column

Ctrl

Select worksheet

Ctrl

A

Select adjacent cells

Shift

MouseLeft

Cancel selection

Esc

Extend selection to right

Shift

Extend selection to left

Shift

Extend selection to down

Shift

Extend selection to top

Shift

PageDown

Extend selection to left screen

Alt

Shift

PageDown

Extend selection to right screen

Alt

Shift

PageUp

Extend selection to bottom

Shift

PageUp

Select cells to the left

Ctrl

Shift

Home

Select cells to the right

Ctrl

Shift

End

Workbook:

Close workbook

Ctrl

W

Open workbook

Ctrl

O

Create new workbook

Ctrl

N

Next workbook

Ctrl

Tab

Previous workbook

Ctrl

Shift

Tab

Minimise workbook

Ctrl

F9

Maximise workbook

Ctrl

F10

Insert new worksheet

Shift

F11

Next Pane

F6

Previous Pane

Shift

F6

Switch Tabs

Ctrl

PageUp

Pivot table:

Open pivot table wizard

Alt

D

P

Create pivot chart

Alt

F1

Create pivot chart on new worksheet

F11

Hide pivot table item

Ctrl

-

Group pivot table items

Alt

Shift

Ungroup pivot table items

Alt

Shift

Select pivote table

Ctrl

A

Mouse shortcuts:

Drag and copy

Ctrl

MouseLeft

Drag and cut

MouseLeft

Drag and insert

Shift

MouseLeft

Drag to worksheet

Alt

MouseLeft

Drag to duplicate worksheet

Ctrl

MouseLeft

Zoom in

Ctrl

Alt

+

Zoom out

Ctrl

Alt

-

Productivity Boost? 🚀