Quick Wins: Excel Keyboard Shortcuts

I have finally compiled a list of excel shortcuts few I knew and few collected from various Excel websites.

To download the file Click here

In total, I was able to collect keyboard shortcuts for 98 excel activities. I'm sure these save quite a lot of time and effort. But, I'm not happy.

Quick Wins: Shortcut to type multiples of 10 in Excel

Wishing you all a very happy and prosperous new year 2011.

Starting this year, I’ll start sharing quick tips under the head “Quick Wins”. Quick wins that save time and effort and importantly easy to learn and execute.

How often do you need to type multiples of 10 in excel (10 0r 100 or 1000 or 1000000 etc)? If that is multiple times in a day then this tip is for you. I’m sure this will drool you (Unless, you are already aware of it!!!).

Typing just 10 or 100 is easy in excel. But what if you have to type 1,000,000? (A million, a billion or greater than that).

 How easy is it to type 1E6 instead of 1,000,000? 3 letters instead of 7! Explanation below