Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kernat
 
Posts: n/a
Default 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   Report Post  
CyberTaz
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I copy an entire worksheet to another with text & format? kb Excel Discussion (Misc queries) 15 July 4th 08 09:25 PM
copy formula referencing sheet name to another sheet Tat Excel Worksheet Functions 1 June 26th 05 03:00 AM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. RonMc5 Excel Discussion (Misc queries) 9 February 3rd 05 01:51 AM
Copy formula...sheet 2 sheet Mick New Users to Excel 0 January 26th 05 02:58 AM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 8th 04 12:02 AM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"