Limit the use of mouse and unleash the power of Keyboard! Become super-fast and swift in navigating, formatting, selecting and entering formula and evolve as an Excel Ninja! If you have missed first part of this blog, click here: Top 5 shortcuts to Increase Speed in MS Excel

1. Select Entire Row & Column:

Use Ctrl + Spacebar to Select a Column and Shift + Spacebar to select a Row. (Pro Tip: C for Ctrl, C for Column)

2. Add or Delete Row & Column:

Use Ctrl and ‘+’ symbol to Add Row or Column and Ctrl and ‘-’ symbol to Delete Row or Column.

3. Type in Multiple Cells at once:

Select the cells, type the formula and then Press Ctrl + Enter.

4. Convert to Table:

Use Ctrl + T to convert a range into table. This will allow you to format the table, add filters, auto freeze the headers and much more. (Pro Tip: Press Tab at the end of the Table, to add new rows)

5. Add Filter Buttons:

Use Alt + D + F + F to add or remove filter buttons

Author Aditi Lundia

Aditi Lundia is a full-time Corporate Trainer and Consultant in MS Excel. She has conducted excel training in various colleges, organization, and clients abroad and plan on doing the same on a larger scale in the future.