Tag Archives: Paste Special

Transpose Data (Static and Linked)

Answer to the 5 little Tricks posted in the beginning of the year – Part 1/5 Transpose Data – Result is static This is actually a simple trick of using Copy and Paster (Special, Transpose).  See? It can be done in a … Continue reading

Rate this:

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

5 Little Excel Tips (tests)

First of all, Happy New Year of 2017!  Wish you all an Excellent year ahead! Let’s start the year with a simple “Game” which I developed for in-house Excel training in my previous company.  All participants were expected to have basic Excel knowledge. … Continue reading

Rate this:

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

Copy and Paste table while keeping column widths

A simple trick (click) can save you lots of time. Below is a commonly seen scenario in my work life: A user wanted to copy a table to a new worksheet/workbook, what he/she normally did was CRTL C then CTRL V. The … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Quickly set consistent column width throughout the whole table

I think many people know how to AutoFit column width in Excel.  In case you don’t, you can simply move your cursor in between the column headers, when you see a cross with left-right arrow, double-click.  Then the column width … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Paste Special – Linked Picture (aka “Camera” in earlier versions of Excel)

As mentioned in my previous post, I am going to talk about another built-in function that is not commonly used (in my limited community)… 😛 COPY, PASTE linked picture (aka “Camera”, which is actually available in Excel 2003; not sure … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 2 Comments