How to Copy Excel Sheet to Another Sheet with Same Format

In Microsoft Excel, there are several methods to copy a sheet to another sheet with the same format. In this article, I’ll show 4 quick simple methods to do it. Just go through the steps and concentrate on the flow of the images.


Download Practice Book

Download the Excel workbook that we’ve used to prepare this article.


4 Easy Ways to Copy Excel Sheet to Another Sheet with Same Format

Method 1: Apply the Copy-Paste Method to Copy Sheet

Let’s get introduced to our datasheet first. In the picture below, three columns are lying with a number of random salespersons, their salaries, and states.

Apply the Copy-Paste Method to Copy Sheet

Now by using the Copy-Paste method, I’ll show how to copy an excel sheet to another with the same format.

Step 1: 

➜ Select the whole data range in the sheet by using a mouse or keyboard.

➜ Press Ctrl+C on the keyboard. A dancing rectangle will appear along the borders.

Apply the Copy-Paste Method to Copy Sheet

Step 2:

➜ Then go to a new sheet.

➜ Activate any cell in the new sheet.

➜ Now press Ctrl+V and the sheet will be copied with the same format.

Apply the Copy-Paste Method to Copy Sheet

Read More:How to Copy a Sheet in Excel (5 Ways)


Method 2: Copy Sheet with an Option from the Context Menu in Excel

This method is quite easy to operate. Here I’ll copy the sheet from the Context Menu option by using a mouse only. Let’s go through the following steps:

Step 1:

➜ First of all, press the title of the sheet that you want to copy.

➜ Then right-click your mouse.

➜ Some options will open up from the Context Menu.

➜ Select the Move or Copy option.

➜ A dialog box will appear.

Copy Sheet with an Option from the Context Menu in Excel

Step 2:

➜ Select “How to Copy Excel Sheet to Another Sheet with Same Format” from the To Book option bar which is actually our current working book.

➜ Select the sheet you want to copy from the Before sheet menu.

➜ Mark on the box of Create a copy option. And press OK.

Copy Sheet with an Option from the Context Menu in Excel

See the image below. The sheet is copied with a new title including the same format.

Copy Sheet with an Option from the Context Menu in Excel

Read More: How to Copy Excel Sheet to Another Sheet (5 Ways)


Similar Readings:


Method 3: Use Fill Handle to Copy an Excel Sheet to Another One

In this method, I’ll use the autofill option by using a mouse to show how to copy a sheet to another sheet with the same format, which is way too easy.

Steps:

➜ Press and hold the Ctrl button on the keyboard.

➜ Then press and hold the title of the sheet with left-click and drag to the new position.

➜ Then release the Ctrl key and mouse.

Use Fill Handle to Copy an Excel Sheet to Another One

Here I have dragged it after the “Method 4” sheet.

 

Use Fill Handle to Copy an Excel Sheet to Another One

Look here the sheet has been copied with a new title in the same format.

Use Fill Handle to Copy an Excel Sheet to Another One

Read More: Excel VBA: Copy Worksheet to Another Workbook Without Opening


Method 4: Copy Sheet with Cell Formatting Option in Excel

By using the cell formatting option, we can copy an Excel sheet to another place in the same workbook. We will use the ‘Move or Copy Sheet’ command to prepare it. Let’s see the steps on how to do it.

Step 1:

➜ Go to the Cells group of commands > Format drop-down.

➜ Now select the Move or Copy Sheet option. A dialog box will open up.

Copy Sheet with Cell Formatting Option in Excel

Step 2:

➜ Select “How to Copy Excel Sheet to Another Sheet with Same Format” from the To Book option bar. That is actually my current working book.

➜ Now select the sheet you want to copy from the Before Sheet bar.

➜ Press OK

Copy Sheet with Cell Formatting Option in Excel

And look, the data is copied with a new sheet with the same format.

Copy Sheet with Cell Formatting Option in Excel

Read More: How to Copy Sheet to End in Excel Using VBA (6 Methods)


Conclusion

I hope all of the methods described above will be effective enough to copy an Excel sheet to another one in a similar workbook. Feel free to ask any questions in the comment section and please give me feedback.


Related Readings

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo