Excel Headers

[Guest]

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

 

[Ron de Bruin]

Hi Angelo

File>PageSetup..Sheet
See rows to repeat at top

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

 

[Gord Dibben]

In addition, check out the possibilities of formatting the first 7 rows using
Format>Cells>Alignment>Center across Selection.

Then follow Ron's suggestion for printing.


Gord Dibben Excel MVP

 

[CLR]

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

 

[Lady Layla]

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



: 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