Monthly Archives: February 2015

Compare two documents for changes – Word and maybe Excel

Posted on February 28, 2015 by

If you use Word, I believe there is high chance that you send out a document to someone for comment, and you expect the receiver would know how to use  Track Changes in Word, which is a great function to … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 3 Comments

Mouse Tip – Move cell with Shift Key

Posted on February 18, 2015 by

If you have read my post about Move Cells with Right Click, you should know it is possible. However for continuous improvement, we often look for faster way to achieve the same thing.  With a simple trick, you may move cells … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 6 Comments

Pay attention when you concatenate – A1 & B1 vs. A1 & “|” & B1

Posted on February 14, 2015 by

In many case, we may want to combine texts from different cells.  This can be done by either CONCATENATE function or simply an Ampersand &.  E.g. A1 & B1 & C1 …… We may take it for granted as it looks so … Continue reading →

Rate this:

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

Ctrl+Enter won’t let you down!

Posted on February 7, 2015 by

As you may be aware of, Ctrl+Enter enables you to input the same thing (be it text, value or formula) in multiple cells simultaneously.  See screenshot below for example: It is quite handy and I use this trick a lot in … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 9 Comments