How to Create a New Sheet in Excel With the Same Format
Do you often need to create a backup of existing worksheets with similar formatting? Do you need to create more than 50 worksheets to track data location-wise or project-wise? Do you manually apply similar formatting to all the worksheets in a workbook?
In that case, learn how to create a new sheet in Microsoft Excel with the same format to save time and flaunt your Excel skills to co-workers.
How to Create a New Sheet in Excel With the Same Format
There are many ways to replicate an Excel worksheet to apply its formatting in new worksheets. Here are some cherry-picked methods you should know:
1. Using the Excel Ribbon Menu
If you prefer to operate Excel by the book, then this method is perfect for you. You’ll need to follow these steps:
- Hit the Alt key and then press H to access the Home menu.
- Now, press O to expand the Format commands and click M to open the Move or copy options.
- Simply choose (move to end) under the Before sheet option and then check in the Create a copy box.
- Click Ok to create a new sheet with the same formatting.
- If you want to move the sheet to a new book, select (new book) under the To book menu and then select Create a copy followed by Ok to replicate the sheet in another workbook.
2. Replicating Sheets Using the Worksheets Menu
You may also try the following steps if the aforementioned method seems lengthier:
- Right-click on the source worksheet tab.
- Press M to access the Move or copy dialogue box.
- You can select (move to end) and check the Create a copy box.
- Select Ok to replicate the sheet with all of the existing formattings.
3. Using a Shortcut Move
There’s also a keyboard and mouse-based move to duplicate a worksheet and create a new one with the same formatting. Here’s what you need to do:
- Press the Ctrl key on your keyboard and don’t let it go.
- Left-click on the source worksheet tab while pressing the Ctrl key.
- Now, slightly drag the cursor to the right side until you see a tiny clipboard icon appearing beneath the cursor arrow.
- Let go of left-click and you’ll see Excel has created a copy of the existing worksheet.
- You can also stop pressing the Ctrl key now.
- The new worksheet will possess all the formatting from the source sheet.
4. Duplicating Contiguous Groups
Let’s say that your workbook contains 5 or more unique worksheets and you need to back up those by copying their formatting to new worksheets. Instead of making copies of multiple unique sheets one at a time, you can replicate them all at once. Here are the easy steps you can try:
- Hit the Ctrl key and then select multiple worksheet tabs that you’ve chosen as sources.
- Move the cursor on the first worksheet while pressing the Ctrl key. Left-click on this worksheet again.
- So far, all the worksheets have been selected and you didn’t let go of the Ctrl key.
- Now, drag the mouse cursor to the right side of the last worksheet and let go of it.
- All the worksheets will be automatically copied without compromising the formatting.
Final Words
Among all the options to duplicate existing worksheets and create new ones with similar formatting, the aforementioned methods are easy-to-remember and perform. We’re hopeful that you’ve found the answer to your question about how to create a new sheet in Excel with the same format.
When you’re dealing with multiple unique and copied worksheets, you can set a default sheet in Excel for collaborative work and avoid unintended modifications by collaborators.
