How to duplicate a sheet in Excel

How to duplicate a sheet in Excel


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

  1. Hold down the “Ctrl” key;
  2. Click and hold the sheet tab you want to copy;
  3. Drag the tab to the row of sheets in the workbook;
  4. Drop the card in the location where you want to make the copy;
  5. Release the “Ctrl” key.



With the right mouse button

  1. Right click the worksheet tab you want to copy;
  2. Select the “Move or Copy” option;
  3. Check the box “Create a copy”;
  4. Select the position of the copy in “Before worksheet”;
  5. 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

  1. Hold down the “Option” key;
  2. Click the worksheet tab to copy;
  3. Drag the tab to the row of sheets in the workbook;
  4. Drop the card in the location where you want to make the copy;
  5. Release the “Option” key.

From the “Edit” menu.

  1. Click on the worksheet you want to copy;
  2. Access the “Edit” menu and select “Spreadsheet”;
  3. Click “Move or Copy Worksheet”;
  4. In the “To Workbook” option, select the destination folder;
  5. In the “Before worksheet” option, choose the location of the copy on the card;
  6. Check the “Create a copy” checkbox;
  7. 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:

Source: Terra

You may also like