Format multi-sheets

mrowe · Apr 9th, 2002, 02:49 AM

Sorry, I know this is being lazy but....

I've got 10 sheets that I need the same custom headers and footers on - I know there is a way to do it one foul swoop, but have forgot... any takers?

Thanks in advance
Matt

rollo · Apr 9th, 2002, 03:05 AM

Click on the first sheet tab, then with your SHIFT key down click on the last sheet tab. This will group the sheets. Type in the details of your header and footer.

sen_edp · Apr 9th, 2002, 03:18 AM

Hello Matt
You can do it.
First you go at the sheet you have the header and footer, go to file menu -page setup and just press ok.
then go to every other sheet you want the same setting , edit menu and press repeat page setup.
Andreas

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

Apr 9th, 2002, 02:49 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Sorry, I know this is being lazy but.... I've got 10 sheets that I need the same custom headers and footers on - I know there is a way to do it one foul swoop, but have forgot... any takers? Thanks in advance Matt

Apr 9th, 2002, 03:05 AM	#2
rollo New Member Join Date: Feb 2002 Posts: 43	Click on the first sheet tab, then with your SHIFT key down click on the last sheet tab. This will group the sheets. Type in the details of your header and footer.

Apr 9th, 2002, 03:18 AM	#3
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	Hello Matt You can do it. First you go at the sheet you have the header and footer, go to file menu -page setup and just press ok. then go to every other sheet you want the same setting , edit menu and press repeat page setup. Andreas