software

I have a 47 tab spreadsheet that I would like to print with the same
margins using the worksheet name as the header. Is there a way to do
this without individually formatting each worksheet?--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile: www.excelforum.com/member.php...oamp;userid=20834
View this thread: www.excelforum.com/showthread...hreadid=535509Right-click on a sheet tab, and choose Select All Sheets
Choose Filegt;Page Setup
On the Margins tab, set the margins
On the Header/Footer tab, from the Header dropdown, select the name of
the active sheet.
Click OK
Right-click on a sheet tab, and choose Ungroup sheets.

Potatosalad2 wrote:
gt; I have a 47 tab spreadsheet that I would like to print with the same
gt; margins using the worksheet name as the header. Is there a way to do
gt; this without individually formatting each worksheet?--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
This works very well. Thank you. I would also like to format all tabs
for Row 1 to repeat at the top but that option seems to be grayed out.
Any suggestions?--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile: www.excelforum.com/member.php...oamp;userid=20834
View this thread: www.excelforum.com/showthread...hreadid=535509Some options aren't available when sheets are grouped. You could use a
macro to set the print tile rows. For example:

'==============================
Sub SetPrinrTitles()

Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets
ws.PageSetup.PrintTitleRows = quot;$1:$1quot;
Next ws

End Sub
'============================

Potatosalad2 wrote:
gt; This works very well. Thank you. I would also like to format all tabs
gt; for Row 1 to repeat at the top but that option seems to be grayed out.
gt; Any suggestions?--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html