The proper way of copying worksheet in #Excel

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…”

Excel Tips - Copy Worksheet1

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?

Excel Tips - Copy Worksheet

 

Let’s watch it in action:

Advertisements

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.