[Quick Tip] How to Copy a Worksheet in Excel

A lot of times we need to make a copy of a worksheet in Excel. May be you want to create a back-up worksheet, or you want to create a new worksheet but don’t want to redo the formatting. 

The long (and inefficient) way is:

  • Right-click on the worksheet tab for which you want to create a copy.
  • Select move or copy option.How to Copy a Worksheet in Excel - right click on tab
  • Check the “Create a Copy” check box.How to Copy a Worksheet in Excel - create a copy
  • 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:

Copy of Excel Worksheet

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

Related Tutorial:
>