How to Make a Copy in Microsoft Excel

Quick summary

The Move or Copy feature in Microsoft Excel lets you instantly duplicate any worksheet tab without manual data entry. Checking the Create a copy checkbox preserves your original sheet while placing the new copy exactly where you need it.

Steps

1. Right-click the sheet tab and select Move or Copy from the context menu.
2. Check the Create a copy box, then select whether to place the copy at the beginning or end of the sheet tabs, then click OK.
3. You have now successfully created a copy in Microsoft Excel.