MS Excel Shortcut Keys: Best Microsoft Excel Keyboard Shortcuts for Windows.

 

Ms-Excel Shortcut Keys-Most Common Short Keys.

Shortcuts for MS Excel Functions	Short Keys
Create new workbook	Ctrl + N
Open workbook	Ctrl + O
Save workbook	Ctrl + S
Save as	F12
Print file	Ctrl + P
Open print preview window	Ctrl + F2
Close current workbook	Ctrl + W
Close Excel	Alt + F4
Open options	Alt + F + T
Open help	F1
Undo last action	Ctrl + Z
Redo last action	Ctrl + Y
Copy selected cells	Ctrl + C
Repeat last action	F4
Cut selected cells	Ctrl + X
Paste content from clipboard	Ctrl + V
Display the Paste Special dialog box	Ctrl + Alt + V
Display find and replace	Ctrl + F
Display find and replace and replace selected	Ctrl + H
Find next match	Shift + F4
Find previous match	Ctrl + Shift + F4
Create embedded chart	Alt + F1
Create chart in new worksheet	F11
Drag and cut	drag
Drag and copy	Ctrl + drag
Drag and insert	Shift + drag
Drag and insert copy	Ctrl + Shift + drag
Drag to worksheet	Alt + drag
Drag to duplicate worksheet	Ctrl + drag
Insert table	Ctrl + T
Toggle Autofilter	Ctrl + Shift + L
Activate filter	Alt + ↓
Select table row	Shift + Space
Select the table column	Ctrl + Space
Select table	Ctrl + A
Clear slicer filter	Alt + C
Toggle table total row	Ctrl + Shift + T
Move one screen right	Alt + Pg + Dn
Move one screen left	Alt + Pg + Up
Move one screen up	Pg + Up
Move one screen down	Pg + Dn
Move to right edge of data region	Ctrl + →
Move to the left edge of the data region	Ctrl + ←
Move to the top edge of the data region	Ctrl + ↑
Move to the bottom edge of the data region	Ctr + l↓
Move to the beginning of the row	Home
Move to last cell in the worksheet	Ctrl + End
Move to the first cell in worksheet	Ctrl + Home
Go back to hyperlink	Ctrl + G + Enter
Move to the next tab	Ctrl + Tab
Move to the previous tab	Ctrl + Shift + Tab
Toggle full screen	Ctrl + Shift + F1
Insert a new worksheet	Shift + F11
Go to the next worksheet	Ctrl + Pg + Dn
Go to the previous worksheet	Ctrl + Pg + Up
Move to the next pane	F6
Move to the previous pane	Shift + F6
Go to the next workbook	Ctrl + Tab
Go to the previous workbook	Ctrl + Shift + Tab
Minimize the current workbook window	Ctrl + F9
Maximize the current workbook window	Ctrl + F10
Insert rows	Ctrl + Shift + +
Insert columns	Ctrl + Shift + +
Display Delete dialog box	Ctrl + –
Delete rows	Ctrl + –
Delete columns	Ctrl + –
Hide rows	Ctrl + 9
Unhide rows	Ctrl + Shift + 9
Hide columns	Ctrl + 0
Unhide columns	Ctrl + Shift + 0
Group rows or columns	Alt + Shift + →
Ungroup rows or columns	Alt + Shift + ←
Hide or show outline symbols	Ctrl + 8
Zoom in	Ctrl + Alt + +
Zoom out	Ctrl + Alt + –
Align left	Alt + H + A + L
Align right	Alt + H + A + R
Add Indent	Alt + H + 6
Remove indent	Alt + H + 5
Increase font size one step	Alt + H + FG
Decrease font size one step	Alt + H + FK
Apply general format	Ctrl + Shift + ~
Apply currency format	Ctrl + Shift + $
Apply percentage format	Ctrl + Shift + %
Apply scientific format	Ctrl + Shift + ^
Apply date format	Ctrl + Shift + #
Apply time format	Ctrl + Shift + @
Apply number format	Ctrl + Shift + !