Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I copy a print format from sheet to sheet in excel ?
I would like to copy a printing format to other sheets in a workbook
including print areas and print titles. Is this possible does anyone know? Thanks. |
#2
|
|||
|
|||
Hello-
Unless I'm missing something, most everything you're asking *is* done automatically since your print specs are for the workbook, not sheet-by-sheet. Headers/Footers, Rows to repeat@top, margins, etc. apply to all sheets, and Print Areas need only be set if you want to print a portion of what would normally be output. You might want to consider Named Ranges if you haven't already done so. HTH |:) "kernat" wrote: I would like to copy a printing format to other sheets in a workbook including print areas and print titles. Is this possible does anyone know? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I copy an entire worksheet to another with text & format? | Excel Discussion (Misc queries) | |||
copy formula referencing sheet name to another sheet | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Copy formula...sheet 2 sheet | New Users to Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |