B
BDavis
Is there anyway around the 250 character limit in Headers?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Maybe you can use Rows to repeat at top.
Is there anyway around the 250 character limit in Headers?
E
Earl Kiosterud
A problem with Rows to repeat at top is that if the sheet is more than one
page wide, you get different columns. You get only the columns of Rows to
repeat that are being printed on a given page. You could manually repeat
the stuff in the Rows to repeat, between the page breaks.
page wide, you get different columns. You get only the columns of Rows to
repeat that are being printed on a given page. You could manually repeat
the stuff in the Rows to repeat, between the page breaks.
D
Dave Peterson
That explains my "maybe" <vbg>.
Another option for the OP (maybe, hehe) is to print a bunch of paper in MSWord
exactly the way they need it. Then print excel's report on these preprinted
sheets.
(maybe, though!)
Another option for the OP (maybe, hehe) is to print a bunch of paper in MSWord
exactly the way they need it. Then print excel's report on these preprinted
sheets.
(maybe, though!)
D
David McRitchie
Hi BDavis,
I don't know if this fits your situation or not for printing.
Using the top rows of your spreadsheet as already suggested,
but as Earle indicated you would be stuck with that and it
would not appear for the pages printing columns to the
right of the first page.
Pages that print a once at the top Logo can start the rows
to repeat at a later row i.e. $50:$50 instead of $1:$1
Addressing Earles concern:
If you want the header on every page you would have to
repeat the header in Row 1 depending on where the page
breaks are. Not the best since you have to keep an eye
on things and probably best to set your own vertical page
breaks.
Some pages that may be of interest:
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm
Freeze Panes for view and Repeat descriptive row/col headings for printing
http://www.mvps.org/dmcritchie/excel/freeze.htm
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
I don't know if this fits your situation or not for printing.
Using the top rows of your spreadsheet as already suggested,
but as Earle indicated you would be stuck with that and it
would not appear for the pages printing columns to the
right of the first page.
Pages that print a once at the top Logo can start the rows
to repeat at a later row i.e. $50:$50 instead of $1:$1
Addressing Earles concern:
If you want the header on every page you would have to
repeat the header in Row 1 depending on where the page
breaks are. Not the best since you have to keep an eye
on things and probably best to set your own vertical page
breaks.
Some pages that may be of interest:
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm
Freeze Panes for view and Repeat descriptive row/col headings for printing
http://www.mvps.org/dmcritchie/excel/freeze.htm
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Earl Kiosterud said:A problem with Rows to repeat at top is that if the sheet is more than one
page wide, you get different columns. You get only the columns of Rows to
repeat that are being printed on a given page. You could manually repeat
the stuff in the Rows to repeat, between the page breaks.