Microsoft Excel - Duplicate a sheet tab on your spreadsheet

If you need to make an exact copy of any of your sheet tabs, put down the copy and paste tools and try this instead...!

Option One

1. Choose the sheet tab you want to duplicate.

2. Right-click on it.

3. Choose 'move or copy...' from the menu that appears.

4. Choose where you would like your duplicated tab to go. Remember, it will appear before the tab you select.

5. Tick the box next to 'create a copy'.

6. Click OK.

7. Your tab will be copied for you.

Option Two

1. Choose the sheet tab you want to duplicate. Make sure it's selected.

2. Hold down the CTRL key on your keyboard.

3. Click and drag your selected sheet tab to the right.

4. Let go of your mouse button to see your duplicate sheet tab.

---

Follow The Blue Star Academy on Instagram for more Microsoft Excel hints and tips!

Click Me