ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I copy a customized Print format over to a new worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/46072-how-do-i-copy-customized-print-format-over-new-worksheet.html)

Jon Beard

How do I copy a customized Print format over to a new worksheet?
 
any assistance would be appreciated?

Dave Peterson

Lots of print settings can be "Copied" over by grouping each sheet -- select the
one with the correct page layout first.

Then go into File|page setup and hit ok.

Then ungroup your worksheets.

If the worksheets are in different workbooks, copy the "master" to the other
workbook, then do the work, and delete that copied worksheet.

Jon Beard wrote:

any assistance would be appreciated?


--

Dave Peterson


All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com