Now, let us see Top 10 shortcut keys we use on day-to-day basis. Of course we will use more than 10 shortcuts but these are the most required shortcut keys while working on Excel.
- To select the data in a sheet - - > CTRL + A (active cell should be within the data)
- To select the complete sheet - - > CTRL + A ('once' if the active cell is outside the data, 'twice' if the selection is within the data)
- After selecting data if we want to see corner cells of each side - - >CTRL + . (dot)
- To filter the data set - - >CTRL + SHIFT + L (hold CTRL and SHIFT then press L)(To activate filters and to deactivate filters)
- To activate the filters we can also do ALT + D + F + F (this option is imported from Excel 2003)
- To auto adjust the cell width and height - - >ALT + H + O + I and ALT + H + O + A
- To auto adjust we can also use double click from mouse.
- To use Format Painter - - >ALT + H + F + P (select the format you want to add to clipboard and then select the cell or data where the format to be applied)
- To select the appropriate formula, type the first letter in the cell after '=' and choose one among the list by using down arrow and then press TAB to auto select the formula. This will actually avoid typo error and also time. eg: To select Vlookup, type =VL and then TAB.
- To refresh the formulas in the work sheet and work book - - > Shift + F9 (function key) and F9.
- While working on formulas take example above as =VLOOKUP( 'after coming here press CTRL + A will get formula arguments. This will help the new bees to know how to import the data to the arguments.
- To select the name manager - - > CTRL + F3 (function key).
- To convert the data into a Table format use - - > CTRL + T (then ENTER).
- To get data validation list - - > ALT + A + V + V + TAB + L + ENTER (looks complicated but very useful).
- To apply 'all borders' for the data selection - - > ALT + H + B + A
- To edit and copy the above cell content - - > CTRL + ' (apostrophe)
The bonus shortcut 1 is - - > CTRL + 1 (one) gives the format cell window and this is very good features in Excel. We can use this shortcut for data format, table format and graph format.
