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:
wmfexcel 