Tag Archives: Copy and Paste

Copy and Paste can do so much…

Answer to the 5 little Tips (tests) – Part 5/5 The task: To sort the following dates in descending order.  Sound silly but… The first thing you would probably do is to go to Data tab and then click the Sort Z to A icon? … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 22 Comments

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

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 data from strictly-protected sheet

How to copy data from a range where you cannot select, due to worksheet protection? Here’s the situation: You receive a worksheet with data but not insight.  Well, it happens and you get use to it already.  You plan to … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 39 Comments

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

Probably the fastest way to convert formula into value – CTRL C, CTRL V, CTRL, V

“Copy and Paste Value” is probably one of the most popular actions taken by many people every day.  A probably fastest way to do so is definitely worth sharing. I learn this from a comment to the post (http://www.myonlinetraininghub.com/favourite-excel-shortcuts) by MYNDA TREACY … Continue reading

Rate this:

Posted in Excel Tips, Shortcut | Tagged , , , , | 5 Comments