Header/Footer max 255 chars

G

Guest

I need to put a text from over 255 characters in the Header/Footer of an
Excel file which is not allowed.
How can I overcome this problem?
thanks, roland
 
D

Dave Peterson

For the header:

Put the data in some rows and use those rows in the
File|page setup|sheet tab|Rows to repeat at top

If you're using xl2002+, maybe you could create the header/footer as a picture
and insert that picture.

And one more: Use MSWord to print the header/footer and then send the paper
through the printer to pick up the excel data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Footer limitation 3
Can I use a header or footer more than 255 characters in Excel? 1
Customise the location of the header and footer of excel 2
Footer 1
Change Header & Footer Info w/ Worksheet Option Buttons 1
How can I copy more than 255 characters in a cell without truncati 1
Header and Footer 3

Top