wmfexcel

It is not uncommon for people to copy entire worksheet to another sheet (be it on the same workbook, or another workbook, even a new workbook). Nevertheless, are we doing it the right way?

Many people would do so by selecting ALL cells in the worksheet, and then paste in a blank worksheet.  BUT this is not the proper way to do so…  We should do so by right-clicking the worksheet to be copied, followed by “Move or Copy…”

Even if you have known the “proper” way to “Move or Copy…” a worksheet, did you know that you can do it with mouse drag and CTRL key quickly?

Let’s watch it in action:

Continue reading →

This is an extension of my previous post – Freeze a random result with mouse trick.

In my experience using Excel, from Excel 2000 to 2010, and recently 365 (I’d never used Excel 2013 though), I have experienced the same strange behavior when I tried to convert a random number to value by using copy and paste value – the random numbers got re-calculated before the paste action.   It happened to me in different PC (work, school, or home).  Therefore I thought it is a common problem until David N left his comments to my post.

It aroused my curiosity.  I tried again with four different ways to paste (random) values to see if I get different results.  Interestingly, it did.  See below:

A) Using shortcut Ctrl+Alt+V to open the paste special dialog, then select Value.  It works! 🙂

B) Using the mouse trick discussed in previous post.  It works! 🙂

C) Using the “Paste”, “Values” under Home Tab.  It doesn’t work. 😦

D) Using Right-Click, Paste Value.  It doesn’t work. 😦

Tip: Using Clipboard also works! 🙂

Honestly I have no clues why it happened.   If you know, please leave your comments.

Anyway, it reminds me one thing that I always say to my audience when I conduct in-house Excel training:

Always check your result! No matter how confident you are!