Monthly Archives: February 2014

Arrange multiple Windows of the same Workbook!

How to view different worksheets of the same workbook side by side? It’s quite normal to have two workbooks opened; and more than common to view the two workbooks side by side: Advertisements

Rate this:

Posted in Excel Basic, Excel Tips | Tagged , | Leave a comment

How to navigate cell in “Z” direction?? Tab Tab Tab Enter

Have you ever thought of how nice would it be if you can navigate cell in a “Z” direction?

Rate this:

Posted in Excel Basic | Tagged | 1 Comment

Input special characters in Excel by pressing Alt + Numpad

Perhaps you know that you can input some special characters/symbols by pressing Alt + Numpad together.  If you google “ALT Numpad”, you will probably find many extensive lists of special characters input in this way. Well, what to do with … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

What I did during the CNY holiday? To build my 1st dashboard…

During the past CNY holiday, I read a book called <Information Dashboard Design – Display data for at-a-glance monitoring> by Stephen Few.  Special thanks to my friend who borrows the book for me! Well, this is not an Excel book.  … Continue reading

Rate this:

Posted in General | Tagged | Leave a comment

How to insert picture / photo into comment?

Happy Valentine’s Day!! Tomorrow is a very special Valentine’s Day as both Chinese and Western Valentine’s Day fall onto the same day.  It happens only once in every 19 years. Let’s send your special feeling to a special person subtly … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment