How to copy print set up to other excel worksheets?

mcwhirter · July 6th, 2006, 07:50 AM posted to microsoft.public.excel.setup

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?

Pete_UK · July 7th, 2006, 12:30 AM posted to microsoft.public.excel.setup

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy page settings to multiple worksheets in excel?	mcwhirter	Setting up and Configuration	1	January 27th, 2006 03:28 PM
How do I copy a worksheet's print parameters to other worksheets?	Redundant908	Worksheet Functions	2	December 6th, 2005 11:17 PM
Printer Control and Print/Preview Problems	Peter Hallett	Setting Up & Running Reports	3	November 5th, 2005 03:19 AM
How do I print excel worksheets double sided	Kinvara	Worksheet Functions	2	July 1st, 2005 12:26 AM
Copy from Excel into Powerpoint - picture changes	Andrew Wood	Powerpoint	4	July 31st, 2004 11:18 AM