Tag Archives: Go to special

Go to Special + Copy and Paste do the magic

Answer to the 5 little Tips (tests) – Part 4/5 The task: To convert “1” to “Tick” in a table like the following one: Answer:  Copy and Paste with a simple trick … What? Not Find and Replace?  Yes, you may do it by using … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 2 Comments

Move cells with data to the top

Did you spend too much time to move cells so that there are no blank cells in each column? Again, a picture tells thousand words.  Here’s the task… Would you do it this way? Or this way? What did I do … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment

F5 – It is the key I rarely press

The working combinations for F5. F5 alone – Open the Go To Dialog box Ctrl+F5 – restore the window size of the selected workbook Shift+F5 – Open Find (and Replace) Alt+F5 – Refresh Pivot Table Ctrl+Alt+F5 – Refresh All Nevertheless, … Continue reading

Rate this:

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

Fill in the blanks – quickly

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

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

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

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