How do I add a formatted sheet to an existing workbook?

I have 2 separate workbooks, and I would like one of the worksheets to be added to a different workbook with it's formatting intact. I'm trying to avoid re-creating the sheet.

Open both the 'source' workbook and the 'target' workbook.

Activate the 'source' workbook.

Right-click the sheet tab of the sheet that you want to add to the other workbook.

Select 'Move or Copy...' from the context menu.

Select the 'target' workbook from the 'To book:' drop down.

Specify where you want to insert the sheet: before on of the existing sheets, or at the end.

Tick the check box 'Create a copy'.

Click OK.

---
Best wishes, HansV
https://www.eileenslounge.com

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 13, 2025 Views 142 Applies to: