Tag Archives: Go to special

Unstack data across columns with #Excel Pivot Table

Another commonly seen problem in daily work.  Many hours are spent on reshaping data, we all know that.  Nevertheless, if you are good in Excel, doing this task is not difficult at all.   Indeed, there are many ways to solve … Continue reading

Rate this:

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

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 , , | 4 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