Top 100+ Excel Shortcut Keys List (A to Z)

F1

To open Help

Ctrl + Z

To Undo the last action

Ctrl + Y

To redo the last action

Ctrl + C

To copy the Selected data

F4

To Repeat the last action

Ctrl +X

To cut the selected data

Ctrl + V

To paste the Content from the clipboard

Ctrl + Alt + V

To display the paste special dialog box

Ctrl+ F

To display the find and replace with the find tab selected

Ctrl + H

To display the find and replace with the Replace tab selected

Ctrl+ Shift + F4

Find the previous match

Shift +F4

Find the next match

Alt + F1

Insert Embedded chart

F11

Insert a chart in a new sheet

Ctrl + Shift + L

Toggle Autofilter

Atl + (Arrow down button)

Activate Filter

Ctrl + T or Ctrl + L

Create Table

Shift + Space

Select Table row

Ctrl + Space

Select Table column

Ctrl + A

Select the table when the active cell is in the table

Clear Slicer Filter

Atl + C

Run Spellcheck

F7

Open the Macro Dialog box

Alt + F8

Open VBA Editor

Alt + F11

Shift + F11

Insert a new worksheet

Ctrl +PgDn

Go to the next Worksheet

Ctrl + PgUp

Go to the previous worksheet

Alt +O, H, R

Rename current worksheet

Alt + E, L

Delete current worksheet

Alt + E, M

Move Current Worksheet

F6 or Shift + F6

Move between the worksheet, Ribbon, Task pane, and zoom controls in a worksheet that has been split

Ctrl + Shift + PgUp/PgDn

Select adjacent worksheet

Ctrl + Click

Select non-adjacent worksheets

Scrlk

Toggle Scroll Lock

Ctrl +Shift + F1

Toggle fullscreen

Ctrl + P

Print

Ctrl + F2

Open print preview window

Alt + P, R, S

Set Print area

Alt + P + R,C

Clear Print area

Ctrl + Mouse Wheel up

Zoom in

Ctrl + Mouse Wheel Down

Zoom in

Zoom in

Ctrl + N

This will create a new workbook

Ctrl + O

This will open an existing workbook

Ctrl + S

This will save a workbook

Ctrl + W

This will Close the current workbook

Ctrl + F4

This will Close Excel

Ctrl + PageDown

This will move to the next sheet

Ctrl + PageUp

To move to the previous sheet

Ctrl + A

To go to the Data tab

Ctrl + W

To go to the View tab

This will undo your most recent action.

Ctrl +F1

Expand and collapse Ribbon

Alt

Activate access keys

Space or Enter

Activate or open selected Control

Enter

Confirm control change

F1

Get help with selected control

Drag

Drag and cut

Ctrl + Drag

Drag and copy

Shift + Drag

Drag and insert

Ctrl + Shift + Drag

Drag and insert copy

Alt + Drag

Drag to Worksheet

Ctrl + Drag

Drag to duplicate Worksheet

Right side arrow

Move one cell Right

Left side arrow

Move one cell Left

Upward arrow

Move one cell up

Downward arrow

Move one cell down

Alt + PgDn

Move one screen Right

Alt + PgUp

Move one screen Left

PgUp

Move one screen up

PgDn

Move one screen down

Ctrl + Right Arrow

Move to the right edge of the data region

Ctrl + Left Arrow

Move to the left edge of the data region

Ctrl + Upward arrow

Move to the top edge of the data region

Ctrl + Downward arrow

Move to the bottom edge of the data region

Home

Move to the beginning of Row

Ctrl + End

Move to the last cell in the Worksheet that contains the data

Ctrl + Home

Move to the first cell in the Worksheet

End

Turn end mode on

Shift + Backspace

Select the active cell( when multiple cells already selected0

Ctrl + Backspace

Show the active cell on the worksheet

Ctrl +.

Move active cell clockwise to corners of the selection

Enter

Move the active cell down in the selection- wrap to the next column

Shift + Enter

Move active cells up in selection – wrap to the previous column

Tab

Move active cell right in a selection – Wrap to next row

Shift + Tab

Move active cell left in a selection – Wrap to the previous row

Shift + Space

Select the entire row

Ctrl + Space

Select entire column

Ctrl + A

Select the current region if the worksheet contains data. Press again to select the current region and summary rows. Press again to select the entire worksheet.

Shift + Click

Expand Selection

Ctrl + Click

Add nonadjacent cells to the selection

Ctrl + Alt + Right Side arrow

Move right between non- Adjacent selections

Ctrl + Alt + Left side arrow

Move left between non-adjacent selections

Shift +F8

Toggle the ‘Add to selection’ mode

Esc

Exit the ‘Add to selection ‘ mode

F2

Edit active cell

Shift +F2

Insert or edit the comment

Shift + F10 ,M

Delete comment

Esc

Cancel Editing

Shift + Right Side Arrow

Select one character right

Shift + Left Side arrow

Select one character Left

Ctrl + Right side Arrow

Move one word right

Ctrl + Left side Arrow

Move one word left

Ctrl + Shift +Right arrow

Select one word right

Ctrl + Shift + Left arrow

Select one word left

Shift +Home

Select the beginning of the cell

Shift + End

Select to end of the cell

Ctrl + Delete

Delete to end of line

Backspace

Delete the character to the left of the cursor

Delete

Delete the character to the right of the cursor

Alt +Enter

Start a new line in the same cell

Enter

Enter data and move down

Shift + Enter

Enter data and move up

Tab

Enter data and move right

Shift +Tab

Enter data and move left

Ctrl + Enter

Enter data and stay in the same cell

Enter

Enter the same data in multiple cells

Ctrl + ;

Insert current date

Ctrl + Shift + :

Insert current Time

Ctrl + D

Fill down from the cell Above

Ctrl + R

Fill right from the cell on the left

Ctrl + ‘

Copy the formula from the cell above(the formula is an exact copy)

Ctrl +Shift + “

Copy value from the cell above

Ctrl + K

Insert hyperlink

Alt + Arrow down

Display AutoComplete list

Ctrl + 1

Format cells

Ctrl + Shift + F

Display format cells with font tab selected

Ctrl + B

Apply or remove bold

Ctrl + I

Apply or remove italics

Ctrl + U

Apply or remove the underscore

Ctrl + 5

Apply or remove the strikethrough

Alt + H, A, C

Align center

Alt + H, A, L

Align left

Alt+ H, A, R

Align right

Alt + H, 6

Indent

Alt+ H, 5

Remove Indent

Alt + H, W

Wrap text

Alt + H, A, T

Align top

Alt + H, A, M

Align Middle

Alt + H, A, B

Align bottom

Alt + H, F, G

Increase font size by one step

Alt +N+T

To insert table

Alt +N+P

To insert picture

Alt +N+S+H

To insert shape

Alt +N+S+C

To insert Chart

Alt +N+I

To insert hyperlink

Alt +N+X

To insert a text box

Alt +N+U

To insert Symbol

Alt +N+H

To insert header and footer

Alt +W+F+C

To Create a custom View

Alt + H + B

To open a list of borders styles from ribbon

Ctrl + Shift + &

Add a border around selected cells

Alt + H +B,R

Add or remove the right border

Alt + H, B, L

Add or remove the left border

Alt +H, B, P

Add or remove the top border

Alt + H, B, O

Add or remove the bottom border

Alt + H, B, A

Add all borders to all cells in the selection

Ctrl + Shift + –

Remove borders

Alt + N+ V

Create pivot table

Ctrl + A

Select entire pivot table

Alt + Shift + Right arrow

Group pivot table

Alt + Shift + Left arrow

Ungroup Pivot table items

Ctrl + –

Hide (Filter out) pivot table item

Alt + H,S,C

Unhide (clear filter on) pivot table item

Alt +N,S,Z,C

Insert pivot chart.