Most Useful Shortcut Keys Accurate in MS Excel? (Lession-4)

Shortcut Keys in MS Excel

MS Excel Keys a spreadsheet application that allows users to record data in the form of tables is Microsoft Excel. A spreadsheet created in Excel makes it simple to do data analysis. The following graphic is a representation.

Workbook Shortcut Keys:-

MS Excel Shortcut Keys	Description
Ctrl + N	To create a new workbook
Ctrl + O	To open an existing workbook
Ctrl + S	To save a workbook/spreadsheet
Ctrl + W	To close the current workbook
Ctrl + F4	To close Excel
Ctrl + PageDown	To move to the next sheet
Ctrl + PageUp	To move to the previous sheet
Alt + A	To go to the Data tab
Alt + W	To go to the View tab
Alt + M	To go the Formula tab

Cell Formatting Shortcut Keys :-

MS Excel Shortcut Keys	Description
F2	To edit a cell
Ctrl + C, Ctrl + V	To copy and paste cells
Ctrl + I, Ctrl + B	To italicize and make the font bold
Alt + H + A + C	To center align cell contents
Alt + H + H	To fill color
Alt + H + B	To add a border
Tab	To move to the next cell
Ctrl + Shift + &	To add an outline to the select cells
Ctrl + Shift + _	To remove outline border
Shift + Tab	To move to the previous cell
Ctrl + Shift + Right arrow	To select all the cells on the right
Ctrl + Shift + Left Arrow	To select all the cells on the left
Ctrl + Shift + Down Arrow	To select the column from the selected cell to the end of the table
Ctrl + Shift + Down Arrow	To select all the cells below the selected cell
Ctrl + Shift + Up Arrow	To select all the cells above the selected cell
Shift + F2	To add a comment to a cell
Shift + F10 + D	To delete a cell comment
Ctrl + Shift + L	To activate the filter
Ctrl + H	To display find and replace
Ctrl + ;	To insert the current date
Ctrl + Shift + :	To insert current time
Ctrl + Shift + $	To apply the currency format
Ctrl + K	To insert a hyperlink
Ctrl + Shift + %	To apply the percent format
Alt + Q	To go to the “Tell me what you want to do” box

Row and Column Formatting Shortcut Keys

MS Excel Shortcut Keys	Description
Shift + Space	To select the entire row
Alt+H+D+C	To delete a column
Ctrl + Space	To select the entire column
Alt+H+D+C	To delete a column
Ctrl + 9	To hide selected row
Shift + Space, Ctrl + –	To delete a row
Ctrl + Shift + 9	To unhide selected row
Ctrl + 0	To hide a selected column
Alt + Shift + Left arrow	To ungroup rows or columns
Alt + Shift + Right arrow	To group rows or columns
Ctrl + Shift + 0	To unhide a selected column

Pivot Table Shortcut Keys

MS Excel Shortcut Keys	Description
Alt + Shift + Right arrow	To group pivot table items
Alt + Shift + Left arrow	To ungroup pivot table items
Ctrl + –	To hide pivot table items
Alt + F1	To create a pivot chart on the same sheet
F11	To create a pivot chart on a new worksheet

Read also : Benefits of Using MS Excel. (Lession – 3)