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
Post a Comment (0)
Previous Post Next Post

Recent