![]() |
Custom Header Error - Too Many Characters
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? |
Custom Header Error - Too Many Characters
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? |
Custom Header Error - Too Many Characters
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? |
All times are GMT +1. The time now is 10:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com