Headers

M

Marie

I want to use a different header on pg 4 of 4 pages. The Help site tells me
to click on the "Previous Link" icon, which I do not have.

Also, I want to position text at the TOP of a cell and cannot see that
option in the Cell Alignment diologue box.
 
D

David McRitchie

Hi Marie,
Without a macro, you might separate your data between two worksheets,
then when you print select both worksheets.

Otherwise,
You will have to control the printing through a macro, printing the
first three sheets and then printing the fourth sheet with changes.

Excel Developer Tip: Determining the Number of Printed Pages
http://www.j-walk.com/ss/excel/tips/tip65.htm

Restart the printer to print customized pages with different headers
http://www.mvps.org/dmcritchie/excel/headcols.htm#restart

Alignment to top of cell:
select row 1 or other selection i.e. Ctrl+A
Format, cells, alignment, vertical: Top (use the scroller)
 
Top