Headers and footers in Excel

Feb 26th, 2002, 12:05 PM

Can you create different first page headers and footers in Excel 97?

Anne Troy · Feb 26th, 2002, 12:14 PM

Not by using the header/footer on ONE sheet. You can create different headers/footers for each sheet, or the same for all sheets (by grouping).

Anything else would require code.

anno · Feb 26th, 2002, 02:28 PM

you can however put a different header and/or footer on a separate worksheet and use that as your first page. you'll need to select both sheets to get them to print though.

Feb 26th, 2002, 12:14 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Not by using the header/footer on ONE sheet. You can create different headers/footers for each sheet, or the same for all sheets (by grouping). Anything else would require code. __________________ ~Anne Troy

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

Feb 26th, 2002, 12:05 PM	#1
Guest Posts: n/a	Can you create different first page headers and footers in Excel 97?

Feb 26th, 2002, 02:28 PM	#3
anno Board Regular Join Date: Feb 2002 Posts: 202	you can however put a different header and/or footer on a separate worksheet and use that as your first page. you'll need to select both sheets to get them to print though.