Group:  Microsoft Excel ยป microsoft.public.excel.setup
Thread: How to copy print set up to other excel worksheets?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

How to copy print set up to other excel worksheets?
mcwhirter 06.07.2006 06:50:01
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?
Re: How to copy print set up to other excel worksheets?
"Pete_UK" <pashurst[ at ]auditel.net> 06.07.2006 23:30:44
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:
[Quoted Text]
> 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?

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net