Thread: Headers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Headers

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...ls.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)
---
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

"Marie" wrote ..
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.