Skip to content

Duplicate Sheet In Excel Shortcut: How To Quickly Make Copies Of Sheets In Excel

Key Takeaway:

  • Maximize efficiency with quick sheet duplication: When working on Excel, it is important to save time and effort by streamlining your workflow. By using one of the available sheet duplication methods, users can quickly create copies of existing sheets without starting from scratch.
  • Multiple options for duplicating sheets: Excel provides users with various ways to duplicate a sheet quickly, including the “Move or Copy Sheet” command, drag-and-drop method, and VBA option. Each method has its own unique benefits and drawbacks, and users can choose the one that best suits their needs.
  • Utilize keyboard shortcuts to save time: Keyboard shortcuts are a great way to speed up your workflow and increase productivity. Windows and Mac users have different keyboard shortcuts to duplicate a sheet, so it’s important to know which shortcut corresponds to your device.

You don’t need to be an excel expert to quickly make copies of sheets and get your work done faster. Excel has a clever shortcut that anyone can use to easily duplicate worksheets and save time. Learn how to utilize this shortcut here!

How to Quickly Duplicate Sheets in Excel

Searching for a fast way to duplicate sheets in Excel? You’re in the right place! If you want to compare two versions of a sheet or make a backup copy, duplication can save lots of time. Here are 3 methods I’ve used that work well. Firstly, use the ‘Move or Copy Sheet’ command. Secondly, drag and drop to duplicate. Lastly, use VBA to create a sheet copy. Let’s explore each of these step-by-step!

Use the Move or Copy Sheet command

Right-click the sheet you want to copy, then click “Move or Copy“. Select “New Book” in the “To book” drop-down menu. Make sure to check the box next to “Create a copy“. Click OK! This will make a new workbook with a copy of your selected sheet.

Using the Move or Copy Sheet command is a great way to duplicate multiple sheets quickly. You can select which sheets you want to copy and where you want to place them – giving you more control over your data.

Another great advantage is that it lets you choose a different location for the copied sheet, making it easier to organize your data.

Pro Tip: If you have many sheets that need copied, click the first sheet, then hold Shift and click the last sheet. This will select all the sheets between them, allowing you to copy multiple sheets at once.

And Drag and Drop to Duplicate a Sheet is even quicker!

Drag and Drop to Duplicate a Sheet

Duplicating a sheet in Excel is made simple with the ‘Drag and Drop’ feature. Select the sheet you want to duplicate and right-click it. Then, drag it to the desired location and release the mouse button. A pop-up menu will appear. From the options, select ‘Move or Copy’ and then choose ‘Create a Copy’. Finally, click OK.

This method can be repeated to make multiple copies of sheets, keeping all content intact. This includes formatting, formulas, data validation settings and more.

Using ‘Drag and Drop’ is a great option for those who don’t know about keyboard shortcuts or using the Ribbon’s tabs. It also saves time and reduces potential errors that may occur when copying and pasting large amounts of data.

VBA options are also available to create copies of sheets. Let’s explore this next.

VBA Option to Create a Copy of a Sheet

Just press Alt + F11 to open the Visual Basic Editor. Then, select Insert from the menu bar and click Module. Type Sub CopySheet() and press Enter/Return. After that, type Sheets(“Sheet1”).Copy After:=Sheets(“Sheet2”) and press Enter/Return.

VBA option to copy a sheet may seem difficult, but it’s a great time-saver when working with big data sets or complex Excel spreadsheets.

It’s also useful because you can rename the coped sheets and pick what part of the sheet you’d like to copy.

For many years, this technique has been popular among Excel professionals. But it’s not widely known how easy it is!

So use your shortcut keys and make copies of your sheets in just seconds!

Save Time with Shortcut Keys to Duplicate a Sheet

Wanna boost productivity and save time? Then mastering Excel’s keyboard shortcuts is a must! Here’s a focus on copying sheets with shortcut keys. Making copies of sheets is great: same formatting, formulas and values – loads of time saved! Let’s dive into Windows and Mac shortcut combinations, with step-by-step instructions. Get ready to become an Excel pro in no time!

Below are the keyboard shortcuts for copying sheets in Windows and Mac operating systems:


  1. Select the sheet you want to copy.
  2. Hold down the CTRL key and drag the sheet tab to the right to create a copy.
  3. Release the mouse button and then the CTRL key.
  4. If you want to move the sheet to a new workbook, right-click on the sheet tab, select Move or Copy, choose the new workbook from the To book dropdown, and select Create a copy.


  1. Select the sheet you want to copy.
  2. Hold down the Option key and drag the sheet tab to the right to create a copy.
  3. Release the mouse button and then the Option key.
  4. If you want to move the sheet to a new workbook, right-click on the sheet tab, select Move or Copy, choose the new workbook from the To book dropdown, and select Create a copy.

Windows Keyboard Shortcut

Use Windows Keyboard Shortcut for fast duplication in Excel!

Press and hold Ctrl and Shift keys, then press “+” sign on your keyboard.

Release all 3 keys together and a new worksheet will appear – an exact copy of the original.

Microsoft themselves recommend this as one of the fastest ways to duplicate worksheets.

To use Mac Keyboard Shortcut, continue reading.

Mac Keyboard Shortcut

Mac Keyboard Shortcut is the way to go for those who need to duplicate sheets in Excel! Here’s a quick and easy 5-step guide:

  1. Open the workbook that has the sheet you want to copy.
  2. Click on the sheet.
  3. Press “Command” and “D” keys on the Mac keyboard at the same time.
  4. A copy of the sheet will appear with “Copy” added to its name.
  5. Right-click to rename it as desired.

Say goodbye to tedious menu navigation and save time with this useful shortcut! No more accidental copying of settings or formulas – just duplicate what you need, and be done with it.

Mac Keyboard Shortcut is a must-know trick for Excel users who need to create sheet duplicates. Try it today and enjoy a more efficient workflow!

Five Facts About Duplicate Sheet in Excel Shortcut:

  • ✅ The shortcut key to duplicate a sheet in Excel is Ctrl + Shift + F11. (Source: Excel Easy)
  • ✅ Duplicating a sheet can save time when creating multiple sheets with the same layout/formatting. (Source: Excel Campus)
  • ✅ When you duplicate a sheet, all data, formulas, formatting, and charts are copied to the new sheet. (Source: Microsoft Support)
  • ✅ You can also right-click on a sheet and select “Move or Copy” to access the duplicate sheet option. (Source: TeachExcel)
  • ✅ This shortcut can be used in all versions of Excel, including Excel 365, Excel 2019, and Excel 2016. (Source: Excel Off The Grid)

FAQs about Duplicate Sheet In Excel Shortcut: How To Quickly Make Copies Of Sheets In Excel

What is the Duplicate sheet in excel shortcut, and how do I use it?

The Duplicate sheet in excel shortcut is a quick way to create copies of a sheet within an Excel workbook. To use this feature, first, select the sheet you want to duplicate. Then, press the “Ctrl” and “D” keys simultaneously. This will create a duplicate of the selected sheet.

Can I duplicate multiple sheets at once using this shortcut?

No, the Duplicate sheet in excel shortcut only works for duplicating one sheet at a time. If you need to duplicate multiple sheets, you will need to use a different method, such as copying and pasting the sheets manually.

What happens to the duplicate sheet? Is it an exact copy of the original?

Yes, the duplicate sheet created using the shortcut is an exact copy of the original, including all formatting, formulas, and data. However, any references to other sheets or cells may need to be updated to reflect the new sheet name.

Can I assign a different name to the duplicate sheet?

Yes, you can rename the duplicate sheet by right-clicking on the tab for the sheet and selecting “Rename.” Alternatively, you can double-click on the tab to rename it as well.

Is there a limit to how many times I can duplicate a sheet?

No, there is no limit to the number of times you can duplicate a sheet using this shortcut. However, keep in mind that creating multiple identical sheets may use up a lot of memory and slow down your workbook.

What if the Duplicate sheet in excel shortcut doesn’t work?

If the shortcut doesn’t work, check to make sure that you have selected the correct sheet and that it is not protected or shared. You may also want to try closing and reopening Excel to see if that resolves the issue.