Title, Page # , Rows to repeat at top

[ddeegan]

Hello

I am using Excel 2002. I want to repeat the
title, footer, and rows to repeat at the top for each sheet in a workbook.

The sheets already have data in them.

Any help on formatting all of the sheets in a workbook the same way would be appreciated.

Thanks
Dave

 

[AnotherHiggins]

[ul][li]Select the sheet that has the Page Setup data you want copied to the other sheets[/li]
[li]Right click on the sheet tab[/li]
[li]Click on Select All Sheets[/li]
[li]Go to File > Page Setup[/li]
[li]Press OK[/li][/ul]

This will copy the Header and Footer to all the other sheets. Unfortunately it will not copy over the 'Rows to repeat at top' to the other sheets, at least not in Excel 2000.

If you only want to copy the Header/Footer to some sheets, then replace the second step above with this:[ul][li]Press and hold [Ctrl]. While holding [Ctrl], select the other sheets you want[/li][/ul]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.