How can I create a footer containing more than 255 characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a legal disclaimer that needs to print on the bottom of each page in
an Excel spreadsheet. I tried to get it shortened, but the minimum length in
555 characters. Is there any way to produce footers longer than 255
characters?

I could build a routine to print the footer in VBA, but I would like to
avoid that if possible.

Thanks.
 
I don't think VBA will allow you to break this rule either.

In xl2002+, you could add a picture to the footer (and maybe you could create a
picture of your disclaimer).

Maybe print a bunch of sheets with just the disclaimer (created in MSWord) and
then printing the excel data on a second pass through the printer.

Maybe...Put it in some cells and then use rows to repeat at Top (move it to the
header).
 
You could type out the disclaimer in Word, copy, paste special as picture,
copy this picture into Paint and save, then place this picture in the footer
of your worksheet.
Gary
 
But only if you have xl2002+. Support for pictures in headers/footers was added
then.
 

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

How do I get more than 255 characters into a cell? 3
Can I use a header or footer more than 255 characters in Excel? 1
How can I copy more than 255 characters in a cell without truncati 1
more than 255 character in one cell 1
Filter on number of characters on a cell 3
Why can't I get more than 255 characters in one cell in Excel 07? 1
How do I copy more than 255 characters per cell? 2
Why is Excel truncating my text to 255 characters? 2

Back
Top