Formatting headers and footers

srmorgan · May 23rd, 2002, 10:38 AM

Is there some way to control the default font and size that comes up on headers and footers?

We use Arial, 10 as a standard spreadsheet font here in the office, but we like to increase the font size and make the print bold on any footers we place on printed documents.
Is there some way to avoid having to change every footer that we create?

Thanks

Steve

inarbeth · May 23rd, 2002, 10:47 AM

You can amend the template Excel workbook that is opened each time you use Excel. I am not at my usual PC so cannot give you the standard file path. The tempalte as I recall has to named "Book" and this does the trick.

inarbeth · May 23rd, 2002, 04:11 PM

Open a blank sheet and use Page Setup to adjust the headers and footers to what you require and then save it as a template called Book in your XLStart folder. The path to this may be C:Program FilesMicrosoft OfficeOfficeXLStart.

[ This Message was edited by: inarbeth on 2002-05-24 00:28 ]

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

May 23rd, 2002, 10:38 AM	#1
srmorgan Board Regular Join Date: Apr 2002 Location: Wilmington North Carolina USA Posts: 61	Is there some way to control the default font and size that comes up on headers and footers? We use Arial, 10 as a standard spreadsheet font here in the office, but we like to increase the font size and make the print bold on any footers we place on printed documents. Is there some way to avoid having to change every footer that we create? Thanks Steve

May 23rd, 2002, 10:47 AM	#2
inarbeth Board Regular Join Date: Apr 2002 Location: Wivenhoe, England Posts: 877	You can amend the template Excel workbook that is opened each time you use Excel. I am not at my usual PC so cannot give you the standard file path. The tempalte as I recall has to named "Book" and this does the trick.

May 23rd, 2002, 04:11 PM	#3
inarbeth Board Regular Join Date: Apr 2002 Location: Wivenhoe, England Posts: 877	Open a blank sheet and use Page Setup to adjust the headers and footers to what you require and then save it as a template called Book in your XLStart folder. The path to this may be C:Program FilesMicrosoft OfficeOfficeXLStart. [ This Message was edited by: inarbeth on 2002-05-24 00:28 ]