Copying Excel Workbooks?

Lippy555 

Thanks, I worked it out - copied the whole File & used 'Delete Contents'

Thanks..

Lippy555 

To copy an Excel workbook without losing formatting and formulas, you can use one of the following methods:

1. Save As:

• Open the workbook you want to copy.

• Go to the "File" tab in the Excel ribbon.
• Select "Save As."
• Choose a location to save the copied workbook.
• Enter a new name for the copied workbook.
• Click "Save."

This method creates an exact copy of the workbook, preserving all formatting, formulas, and data.

1. Duplicate Sheet:

• Open the workbook you want to copy.
• Right-click on the sheet you want to copy (or select multiple sheets by holding down Ctrl while clicking on the sheet tabs).
• Choose "Move or Copy" from the context menu.
• In the "Move or Copy" dialog box, select "Create a copy" at the bottom.
• Choose the destination workbook where you want to copy the sheets (either an existing workbook or a new workbook).
• Click "OK."

This method copies the selected sheet(s) to a new workbook while preserving all formatting, formulas, and data.

1. Copy and Paste:

• Open the workbook you want to copy.
• Select all the cells in the worksheet by pressing Ctrl+A.
• Copy the selected cells by pressing Ctrl+C.
• Create a new workbook by going to the "File" tab and selecting "New Workbook."
• In the new workbook, select cell A1.
• Paste the copied cells by pressing Ctrl+V.

This method copies the entire worksheet's content, including formatting and formulas, to a new workbook.

These methods allow you to copy Excel workbooks while retaining formatting, formulas, and data. Choose the method that best suits your specific needs and workflow.

The text and steps were created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.