Hi Angelo........
Try making up your "Header" in rows 1:7 on Sheet2, and using whatever column
widths you choose, then highlight the area and do Cntrl-Shift Edit Copy
Picture Appearance "as shown on screen Format "picture" OK
.............then going to Sheet1A1 and Right-click Paste..........then
File PageSetup Sheet tab, and set $1:$7 as your "Rows to repeat at top"
OK

This will allow you to have different column widths in your "header' than in
your database...........

Vaya con Dios,
Chuck, CABGx3



"Angelo" wrote in message
...
Hello All,

Hope all is clicking good.

Excel allows a user to create a header but the header is only displayed
when
printing and is also very limited in function. I am trying to create an
Excel document that devoted the first seven rows to a header and then
remaining thousands of rows to a list of data. I.e.:


HEADER

Name: blah
Date: 03/03/03
Time: 12:24:03
Title: Excel problem
Procedure 1) ~~~~~~~~~~~~~~~~~~~~~~~~
2) ~~~~~~~~~~~~~~~~~~~
3) ~~~~~~~~~~~

TABLE

Symbol Name Description Price
----------- -------- --------------- --------
MSFT Microsoft A big giant $23.22
AAPL Apple A small fruit $40.00


etc.


The problem being that scaling the data in the header section will also
scale the table. I do not want to merge cells as the header data could
easily change and would require unneeded time to readjust the cells.
Instead, I am aiming for the column widths for the header and the column
widths for the table to be independent.

I very much appreciate any information you can provide,

Version is Excel 2000

Thanks,

Angelo