Prev Previous Post   Next Post Next
  #4   Report Post  
Lady Layla
 
Posts: n/a
Default

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
My Excel column headers have changed to numbers, how do I get bac. Monty Excel Discussion (Misc queries) 3 February 18th 05 03:33 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
Excel 2003 headers ssandee Excel Discussion (Misc queries) 2 January 11th 05 05:16 PM
In Excel, can I copy Headers and Footers between Worksheets? Brian Excel Worksheet Functions 1 November 12th 04 01:14 PM


All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"