I have a spread sheet with many columns and rows and I would like for the
First line of each column to remain visible as a user scrolls down the rows
so that he/she will be able to see that that data represents by simply
looking up(instead of scrooling all the way back up) to see that is the
heading of that column.

Any help would be appreciated.

Larry Hughes

Larry

Click on A2, then on the top toolbar, Window Freeze panes.
HTH

George Gee


"Larry Hughes" wrote in message
...
I have a spread sheet with many columns and rows and I would like for the
First line of each column to remain visible as a user scrolls down the
rows
so that he/she will be able to see that that data represents by simply
looking up(instead of scrooling all the way back up) to see that is the
heading of that column.

Any help would be appreciated.

Larry Hughes

Hi Larry,

Select the row 2, if you want to freeze row 1

click on the menu WINDOW | FREEZE PANEL

Does this Help?
regards from Brazil
Marcelo

"Larry Hughes" escreveu:

I have a spread sheet with many columns and rows and I would like for the
First line of each column to remain visible as a user scrolls down the rows
so that he/she will be able to see that that data represents by simply
looking up(instead of scrooling all the way back up) to see that is the
heading of that column.

Any help would be appreciated.

Larry Hughes

and for the same thing in printed worksheets
file, page setup, sheets, Rows to repeat at top: $1:$1
file, peg setup , Sheets, Columns to repeat at left: $A:$A
there is a little more flexibility in printing to allow you o not print headings
on the first page(s) until you need a page break after your designated entries.
More information on both see
http://www.mvps.org/dmcritchie/excel/freeze.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Larry Hughes" wrote in message ...
I have a spread sheet with many columns and rows and I would like for the
First line of each column to remain visible as a user scrolls down the rows
so that he/she will be able to see that that data represents by simply
looking up(instead of scrooling all the way back up) to see that is the
heading of that column.

Any help would be appreciated.

Larry Hughes

"Larry Hughes" wrote:

I have a spread sheet with many columns and rows and I would like for the
First line of each column to remain visible as a user scrolls down the rows
so that he/she will be able to see that that data represents by simply
looking up(instead of scrooling all the way back up) to see that is the
heading of that column.

Any help would be appreciated.

Larry Hughes

I went to Excel Help and did a search and found the following link.

http://office.microsoft.com/en-us/ex...CL100570551033

Epinn

"WJMcCOY" wrote in message ...


"Larry Hughes" wrote:

I have a spread sheet with many columns and rows and I would like for the
First line of each column to remain visible as a user scrolls down the rows
so that he/she will be able to see that that data represents by simply
looking up(instead of scrooling all the way back up) to see that is the
heading of that column.

Any help would be appreciated.

Larry Hughes

Also you might want to so see
http://www.mvps.org/dmcritchie/excel/freeze.htm
which covers some related things.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Epinn" wrote in message ...
I went to Excel Help and did a search and found the following link.

http://office.microsoft.com/en-us/ex...CL100570551033

Epinn

"WJMcCOY" wrote in message ...


"Larry Hughes" wrote:

I have a spread sheet with many columns and rows and I would like for the
First line of each column to remain visible as a user scrolls down the rows
so that he/she will be able to see that that data represents by simply
looking up(instead of scrooling all the way back up) to see that is the
heading of that column.

Any help would be appreciated.

Larry Hughes

According to the guidelines of how to post and the opinion of the majority, we are supposed to do research before we post. This makes sense. However, sometimes I have a different view. If the OP had found the answer from Excel Help, then he/she might not have posted. As a result, I would not have known about your web site which is a gift. You know if I know how to do something, I probably won't research. Thanks.

Epinn

"David McRitchie" wrote in message ...
Also you might want to so see
http://www.mvps.org/dmcritchie/excel/freeze.htm
which covers some related things.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Epinn" wrote in message ...
I went to Excel Help and did a search and found the following link.

http://office.microsoft.com/en-us/ex...CL100570551033

Epinn

"WJMcCOY" wrote in message ...


"Larry Hughes" wrote:

I have a spread sheet with many columns and rows and I would like for the
First line of each column to remain visible as a user scrolls down the rows
so that he/she will be able to see that that data represents by simply
looking up(instead of scrooling all the way back up) to see that is the
heading of that column.

Any help would be appreciated.

Larry Hughes