Thread: Excel Headers
View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi Angelo

FilePageSetup..Sheet
See rows to repeat at top

Every page will use this rows on top now when you print


--
Regards Ron de Bruin
http://www.rondebruin.nl



"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