#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 143
Default Headers

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.


  #2   Report Post  
Posted to microsoft.public.excel.misc
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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting by Column Headers Richard Excel Discussion (Misc queries) 2 June 19th 06 11:55 PM
How can I expose the actual column & row headers in excel? Juanita Excel Discussion (Misc queries) 1 December 1st 05 06:18 PM
Excel - auto freeze list headers Anorak Excel Worksheet Functions 0 October 23rd 05 02:22 PM
Headers on a Shared Workbook jessica Excel Discussion (Misc queries) 1 April 29th 05 09:46 AM
Help with Headers jessica Excel Discussion (Misc queries) 0 April 6th 05 06:41 PM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"