Working with Excel in office environment extensively needs you to work with keyboard. You need to be quick to be productive. Time and motion study proves it that making use of keyboard shortcuts reduces time required to accomplish a task. You must learn the short cuts for the tasks you use more frequently.

autosum

Autosum option in Ribbon

Probability is quite higher that you use autosum option quite frequently. When applied, this deploys SUM function on selected cell such that cells above that are added. If there is no value above, preceding cells in the row are checked and sum of the values is returned.

ALT + autosum

hold ALT and press +

This task can be done quickly using keyboard shortcut. You only need to hold ALT and press + button. And SUM function as described above is implemented on selected cell. Like Cell A6 was selected and ALT+ is pressed to get sum of cells above selected cells.

workingWithExcel.com

Subscribe To Excel Newsletter

 

You will receive it when a new post is published

You have Successfully Subscribed!

Pin It on Pinterest

Share This