Archive of Mr Excel Message Board
Back to Printing in Excel archive index
Back to archive home
Larger Footers
Posted by Carolyn on April 20, 2000 12:02 PM
I have a large text footer I need to used that exceeds the size allowed in the Page SetUp Footer. I tired typing the information on a sheet in the workbook, name the range and then tried to reference it in the footer in page setup. It didn't work. Can anyone tell me how to get a large footer on a spreadsheet.
Thanks!
Re: Larger Footers
Posted by david rainey on April 20, 2000 9:08 PM
does it help if you make your margins bigger on the bottom of the page
Re: Larger Footers
Posted by Carolyn on April 21, 2000 6:24 AM
No, it seems I hitting a limit on the number of characters allowed in the footer.
Re: Larger Footers
Posted by Tim Francis-Wright on April 24, 2000 9:08 AM
I don't know of a way to trick Excel into letting you use over 255 characters in a footer. An alternative might be to use the Print Titles feature. You can specify any number of rows to appear at the top of each page.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.