Excel Headers

[Sunden2010]

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,

Sunden

 

[AnotherHiggins]

First, I want to make sure you are aware of the 'Rows to repeat at top' selection in File > Page Setup on the sheet tab.

=>I am aiming for the column widths for the header and the column widths for the table to be independent.
That can't be done.

I personally hate merged cells, but have you tried this:
Select the cells that one might normally merge, then go to Format > Cells then on the Alignment tab, in the Horizontal box, select Center across selection. You still have independent cells so columns can easily be formatted, but it has the look of merged cells.


[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886