Using mouse while working on Excel equal - “Waste of Time!”.

Every time you click a mouse instead of using Keyboard keys, you are wasting precious seconds. No doubt memorizing the shortcuts can be daunting at first. But once you get a hang of it, it will be a piece of cake. Below are the Top 5 shortcuts that you must use using working on Excel. These will not only increase your productivity and speed but will also keep you focused and reduce repetitive stress.

1. Move Across Sheets:

Use Ctrl + Page up and Ctrl + Page Down to easily navigate between sheets.

2. Move to Last Entered Cell:

Use Ctrl + Arrow Keys (Left, Right, Up & Down) to jump to the last populated cell in that direction.

3. Move to 1st Cell:

Use Ctrl + Home to go to Cell A1 of the sheet.

4. Add New Sheet:

Use Shift + F11 to add new sheet in the same workbook.

5. Edit Active Cell:

Use F2 to edit formula of the active cell.

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.