[Quick Tip] How to Copy a Worksheet in Excel

The long (and inefficient) way is:

* Right-click on the worksheet tab for which you want to create a copy.

* Select the Move or Copy option.

* Check the “Create a Copy” check box

* Click OK.

This will create a copy of the worksheet.

While this is a perfectly fine way to copy a worksheet in Excel, it’s not the most efficient way of doing this.

In this tutorial, I will show you a super quick and efficient way to copy a worksheet in Excel.

How to Copy a Worksheet in Excel

Here are the steps:

  1. Activate the worksheet for which you want to make a copy.
  2. Press the Control Key from the keyboard.
  3. Left-click on the worksheet tab (a plus sign icon in a worksheet would appear).
  4. While still holding the Control key and the Left button of the mouse, drag mouse icon to the right.
  5. Leave the mouse Left-button followed by the Control Key.

This would create a copy of the worksheet:

Note: If you want to have the copy of the worksheet appear to the left of the original worksheet, drag the mouse to the left side.

Add a Comment

Your email address will not be published. Required fields are marked *