Repeat Rows

melamaric · Apr 1st, 2002, 10:29 AM

Is there a way to create a 'section' break in a worksheet so that I can use Repeat Rows when printing? I have different sections within one sheet and because each section will print multiple pages, I want the headers to print for that section only. For internal departmental reasons, I am not allowed to create separate worksheets.

Anne Troy · Apr 1st, 2002, 10:43 AM

File-Page setup.
Sheet tab.
Rows to repeat at top.

Chris Davison · Apr 1st, 2002, 10:50 AM

you need different repeating headers printed for different sections within the sheet ?

(to clarify)

melamaric · Apr 1st, 2002, 11:17 AM

Yes, Chris.

[ This Message was edited by: melamaric on 2002-04-01 10:18 ]

Apr 1st, 2002, 10:43 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	File-Page setup. Sheet tab. Rows to repeat at top. __________________ ~Anne Troy

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

Apr 1st, 2002, 10:29 AM	#1
melamaric Board Regular Join Date: Mar 2002 Location: Ontario, Canada Posts: 68	Is there a way to create a 'section' break in a worksheet so that I can use Repeat Rows when printing? I have different sections within one sheet and because each section will print multiple pages, I want the headers to print for that section only. For internal departmental reasons, I am not allowed to create separate worksheets.

Apr 1st, 2002, 10:50 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	you need different repeating headers printed for different sections within the sheet ? (to clarify)

Apr 1st, 2002, 11:17 AM	#4
melamaric Board Regular Join Date: Mar 2002 Location: Ontario, Canada Posts: 68	Yes, Chris. [ This Message was edited by: melamaric on 2002-04-01 10:18 ]