How to Quick Copy a Worksheet in Excel
Table of Contents
During work on a Microsoft Excel lot of times we need to make a copy of a worksheet in Excel.
Maybe we want to create a back-up worksheet, or we want to create a new worksheet, but don’t want to create the format again.
The long (and inefficient) way to Copy a Worksheet:
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.
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.
How to Quick Copy Worksheet in Excel:
In this tutorial, We will show a super quick and efficient way to copy a worksheet in Excel.
Here are the steps:
Activate the worksheet click on the excel sheet which you want to make a copy.
Press the Control Key from the keyboard.
Left-click on the worksheet tab (a plus sign icon in a worksheet would appear).
While still holding the Control key and the Left button of the mouse, drag mouse icon to the right.
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.
If you want to create copy of multiple worksheets copy, then you can do with select multiple worksheets by press & hold Ctrl Key and drag the mouse icon into the worksheet (a plus sign icon in a worksheet would appear).
Once you release the left button of the mouse all the selected file copies will be created automatically.