ExcelBanter - Can I copy page set ups in Excel 2003 from one wksht to another

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can I copy page set ups in Excel 2003 from one wksht to another (https://www.excelbanter.com/excel-worksheet-functions/153634-can-i-copy-page-set-ups-excel-2003-one-wksht-another.html)

MHacct

Can I copy page set ups in Excel 2003 from one wksht to another

Is it possible to take the page set ups along when copying an entire
worksheet from one workbook to another

Gord Dibben

Can I copy page set ups in Excel 2003 from one wksht to another

Not only possible but that is the default when copying a sheet from one workbook
to another.

Right-click on the sheet tab and "move or copy"

Check "create a copy" and select to where you want it copied.

Gord Dibben MS Excel MVP

On Thu, 9 Aug 2007 09:16:04 -0700, MHacct
wrote:

Is it possible to take the page set ups along when copying an entire
worksheet from one workbook to another

All times are GMT +1. The time now is 09:58 AM.