Copy Excel tabs

Copper Contributor

Is there a way to copy all tabs in a workbook to a new workbook. I have tried Ctrl and clicking on the tabs, but they will not all highlight,

3 Replies

@johnjr1955 Why not just save the workbook under a different name and continue from there.

Right-click any sheet in workbook - Select all sheets.
Right-click again - Move or Copy
to book: new book
Check "create a copy"
(Don't forget to ungroup the original workbook.)

@Riny_van_Eekelen The workbook has over 100 tabs. We are looking to just copy four of the tabs to a new workbook.