Category Archives: Excel Tips

Working with Objects

Posted on October 20, 2013 by MF

From a simple textbox, a rectangle to a chart, you may have experience in moving/resizing/aligning or even selecting multiple objects in excel.  It could be really time consuming and the result may not be good looking still. :O Have you … Continue reading →

Rate this:

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

Fill in the blanks – quickly

Posted on October 12, 2013 by MF

How to fill up all the blank cells in a Table in less than 1 minute??? The table on the left is a typical output from Pivot Table.  The blank cells help to make the table more “reading-friendly”.  However they … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 7 Comments

Quickly highlight the differences in two columns – Go to Special

Posted on October 6, 2013 by MF

There are many ways to find out the cells in column B which are different from the cells in column A, e.g. using Conditional Formatting, Using formula in column C.  These methods require some knowledge in Formula.  Nevertheless, It could … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Another useful tips with Go to Special – Visible cells only

Posted on October 3, 2013 by MF

This is an extension of the previous post that talks about Go to Special -> Visible cells only Apart from Copy ONLY unhidden rows/columns, another situation we used to run into is probably deleting or modifying hidden cells unintentionally.  Sound … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

How to copy visible cells only?? – GO TO SPECIAL: visible cells only

Posted on September 25, 2013 by MF

Have you run into a situation that you wanted to copy a table, like the one below, to a new worksheet. However the Table “expanded” automatically… All the information from the hidden rows and columns reappears.  What??? A simple trick … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Another use of F4 – Repeat LAST action

Posted on September 22, 2013 by MF

Excel tips: F4 to repeat LAST action As mentioned in my previous post, F4 is my favorite keyboard buddy.  It helps you quickly shift between relative reference and absolute reference when building formula; it also helps to repeat your last … Continue reading →

Rate this:

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

How to switch between Absolute and Relative reference? F4

Posted on September 12, 2013 by MF

如何快速轉換公式中的絶對參照及相對參照? To kick off my first blog, I would like to introduce my buddy on keyboard to you – F4 To me, it helps 1)      Switch between Relative and Absolute reference easily when typing formula 2)      Repeat last action Let’s … Continue reading →

Rate this:

Posted in Excel Tips, Formula, Shortcut | Tagged | 1 Comment