I am creating a custom header for financial statements. It has 238
characters (without spaces) according to Word Count in Microsoft Word. When
I hit enter in Excel to create the header, it says that headers must be less
than 255 characters in length.

I have the first line of the header in BOLD.

Everything I've read so far about headers says it can be as many lines as
you like, and I haven't seen any kind of limitation on character length,
until I went to put in the header.

Is there a work around this?

Generally space counts as a character even though Word Count in MS Word
doesn't count it. So most likely it's more than 255 character if spaces are
counted.

If you can't reduce the header any shorter, one way around it is to put it
in your actual sheet. Put the header in your first row(s) and adjust the top
margin so that it looks like a header when printed out. You can go to File
-- Page Setup -- Sheet tab to set the rows that you want to appear on every
page. That way your fake header will print on every page, much like a real
header.

-Simon

"nat0516" wrote:

I am creating a custom header for financial statements. It has 238
characters (without spaces) according to Word Count in Microsoft Word. When
I hit enter in Excel to create the header, it says that headers must be less
than 255 characters in length.

I have the first line of the header in BOLD.

Everything I've read so far about headers says it can be as many lines as
you like, and I haven't seen any kind of limitation on character length,
until I went to put in the header.

Is there a work around this?

When I said without spaces, I mistyped. It was 238 characters WITH spaces.
I'm getting this same message over and over again.

The problem with putting the header in the actual worksheet is this: It is
a very wide worksheet, with 12 different views (columns being hidden), and
every other view needs the header. In order to put it in the worksheet, I
have to merge, unmerge and remerge for EVERY view.

If they are going to say it has to be less than 255 characters, then they
should let you type 255 characters!

"SimonCC" wrote:

Generally space counts as a character even though Word Count in MS Word
doesn't count it. So most likely it's more than 255 character if spaces are
counted.

If you can't reduce the header any shorter, one way around it is to put it
in your actual sheet. Put the header in your first row(s) and adjust the top
margin so that it looks like a header when printed out. You can go to File
-- Page Setup -- Sheet tab to set the rows that you want to appear on every
page. That way your fake header will print on every page, much like a real
header.

-Simon

"nat0516" wrote:

I am creating a custom header for financial statements. It has 238
characters (without spaces) according to Word Count in Microsoft Word. When
I hit enter in Excel to create the header, it says that headers must be less
than 255 characters in length.

I have the first line of the header in BOLD.

Everything I've read so far about headers says it can be as many lines as
you like, and I haven't seen any kind of limitation on character length,
until I went to put in the header.

Is there a work around this?