Learn how to duplicate a spreadsheet in Excel with handy shortcuts in the spreadsheet program for Windows, macOS and web
The Windows, macOS, or web versions of Excel offer convenient shortcuts for duplicating a worksheet and backing up your work. This can be useful for organizing content, saving editing history, and preventing data loss during editing.
You can precisely copy and duplicate a worksheet within the same workbook. However, be careful when moving a table to another workbook, as formulas and charts based on worksheet data can be buggy or produce inaccurate results.
How to duplicate a sheet in Excel
Excel has several ways to create a copy of a spreadsheet within the same workbook in every operating system.
On Windows
There are two practical ways to duplicate a worksheet in Excel for Windows.
with shortcut key
- Hold down the “Ctrl” key;
- Click and hold the sheet tab you want to copy;
- Drag the tab to the row of sheets in the workbook;
- Drop the card in the location where you want to make the copy;
- Release the “Ctrl” key.
With the right mouse button
- Right click the worksheet tab you want to copy;
- Select the “Move or Copy” option;
- Check the box “Create a copy”;
- Select the position of the copy in “Before worksheet”;
- Click “Okay”.
on macOS
Using the macOS operating system, it is also possible to duplicate an Excel spreadsheet using a hotkey or the “create a copy” option.
with shortcut key
- Hold down the “Option” key;
- Click the worksheet tab to copy;
- Drag the tab to the row of sheets in the workbook;
- Drop the card in the location where you want to make the copy;
- Release the “Option” key.
From the “Edit” menu.
- Click on the worksheet you want to copy;
- Access the “Edit” menu and select “Spreadsheet”;
- Click “Move or Copy Worksheet”;
- In the “To Workbook” option, select the destination folder;
- In the “Before worksheet” option, choose the location of the copy on the card;
- Check the “Create a copy” checkbox;
- Click “Okay”.
In Excel for the web
In the online version of Excel, you can duplicate worksheets within the same workbook by right-clicking the table tab and selecting the “Duplicate” option.
Find out even more tips on how to use excel to increase productivity and organization with spreadsheet control and formula application.
Trending on Canaltech:
- 10 things Google Bard does better than ChatGPT
- The patient allegedly used the butt plug in the MRI and the result is appalling
- The spider that appears in Harry Potter is real and can be seen in Brazil
- Samsung confirms its first OLED TV in Brazil with a discount of up to R$ 2,000
- Does Guardians of the Galaxy 3 have a post-credits scene?
- Millions of Android smartphones shipped with viruses “out of the box”
Source: Terra

Rose James is a Gossipify movie and series reviewer known for her in-depth analysis and unique perspective on the latest releases. With a background in film studies, she provides engaging and informative reviews, and keeps readers up to date with industry trends and emerging talents.