Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default How to copy print set up to other excel worksheets?

I want to copy the print set up including page breaks on to multiple
worksheets but when grouped this function is greyed out. Pasting just the
format does not copy the print set ups across to another work sheet. I do
not want this print set up on all my worksheets, just a few.
Anyone know how to copy print set ups to other sheets?
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 8,856
Default How to copy print set up to other excel worksheets?

How much data have you got in the other sheets? It might be easier just
to copy the main sheet a few times into the workbook using CTRL-drag,
then rename each new sheet and copy/paste data and formulae from the
existing sheets.

Hope this helps.

Pete

mcwhirter wrote:
I want to copy the print set up including page breaks on to multiple
worksheets but when grouped this function is greyed out. Pasting just the
format does not copy the print set ups across to another work sheet. I do
not want this print set up on all my worksheets, just a few.
Anyone know how to copy print set ups to other sheets?


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 to copy multiple Excel files from Outlook into Excel??? Brainless_in_Boston Excel Discussion (Misc queries) 0 February 24th 06 03:46 PM
How do I copy a worksheet's print parameters to other worksheets? Redundant908 Excel Worksheet Functions 2 December 6th 05 11:17 PM
How do I print all worksheets in Excel with one click? Kate New Users to Excel 4 July 30th 05 05:34 AM
Print multiple worksheets on one page in Excel? TCTeach Excel Discussion (Misc queries) 1 May 3rd 05 05:01 AM
EXCEL Won't Print More Than One Copy Frank Excel Discussion (Misc queries) 1 April 27th 05 01:01 PM


All times are GMT +1. The time now is 02:24 AM.

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

About Us

"It's about Microsoft Excel"