Most Important Microsoft Excel Shortcut Keys | PDF Download |

Workbook shortcut keys in excel :-

To do this	Press
Create a new workbook	Ctrl + N
Open an existing workbook	Ctrl + O
Save a workbook/spreadsheet	Ctrl + S
Close current workbook	Ctrl + W
Close Excel	Ctrl + F4
To move to the next sheet	Ctrl + PageDown
To move to the previous sheet	Ctrl + PageUp
Go to the Data tab	Alt + A
Go to the View tab	Alt + W
Go the formula tab	Alt + M

Cell formatting shortcuts :-

To do this	Press
Edit a cell	F2
Copy and paste cells	Ctrl + C, Ctrl + V
Bold and italicize the fon	Ctrl B, Ctrl I
Underline to the cell content	Ctrl + U
Center align cell contents	Alt+H+A+ C
To fill colour	Alt + H + H
Add a border	Alt + H + B
Remove outline border	Ctrl + Shift + _
Add outline to the select cells	Ctrl + Shift + &
Move to the previous	cell Shift + Tab
Move to the next cell	Tab
Select cells on the right	Ctrl + Shift + Right arrow
Select cells on the left	Ctrl + Shift + Left Arrow
Select the column from the selected cell to the end of the table	Ctrl + Shift + Down Arrow
Select the data above the selected cell	Ctrl + Shift + Up Arrow

Additional cell formatting shortcuts :-

To do this	Press
Add a comment to a cell	Shift + F2
Display find and replace	Ctrl + H
Activate Filter	Alt + Down Arrow
Insert the current date	Ctrl + ;
Insert current time	Ctrl + Shit + :
Insert a Hyperlink	Ctrl + k
To apply the currency format	Ctrl + Shift + $
To apply the percent format	Ctrl + Shift + %
Go to the “Tell me what you want to do” box	Alt + Q

Row and Column formatting shortcuts :-

To do this	Press
Select the entire row	Shift + Space
Select the entire column	Ctrl + Space
Select the entire worksheet	Ctrl + Shift + Space
To move to the edge of the worksheet	Ctrl + Right arrow
To delete a column	Alt+H+D+C
To delete a row	Shift + Space, Ctrl + - (minus)
To hide selected row	Ctrl + 9
To unhide selected row	Ctrl + Shift + 9
To hide a selected column	Ctrl + 0
To unhide a selected column	Ctrl + Shift + 0
Group rows or columns	Alt + Shift + Right arrow
Ungroup rows or columns	Alt + Shift + Left arrow

Pivot Table shortcuts :-

To do this	Press
Group Pivot table items	Alt + Shift + Right arrow
Ungroup Pivot table items	Alt + Shift + Left arrow
Hide Pivot table item	Ctrl + -
Create a Pivot chart on the same worksheet	Alt + F1
Create a Pivot chart on a new worksheet	F11

Most Important Microsoft Excel Shortcut Keys Download PDF

Download PDF

Download PDF
579 KB