Which option is preferable in Excel? Using mouse or using keyboard?
Rajesh Pathak
Simple example is opening Data validation using mouse vs. using keyboard shortcut keys.

By using mouse, you need to take following four steps:
  1. First position your palm on the mouse properly.
  2. Drag the mouse on ‘Data’ tab in the ribbon.
  3. Click on ‘Data’ tab in the ribbon
  4. Finally, click on ‘Data Validation’ to open data validation dialog box.
You need to take only one step if you use the shortcut key Alt D L to open data validation dialog box.

Imagine, if you don’t know the shortcut keys for every feature in the ribbon, you need to take extra steps to access that feature in the ribbon. Consequently, you are taking more time than your colleague to do the same activity.

Shortcut keys are certainly time savers.

Homepage
MS EXCEL TRAINING