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

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

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

To keep the rows on top while you are working in the spreadsheet, click the row
button for row 8, then go to Window -- Freeze pane



"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