How do I keep line one from scrolling in excel?
 

I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
Thanks

If you want to freeze the entire first row, with your cursor in Cell A1,
click on Windows|Freeze panes.

If you move your cursor to say C1 before doing this, not only will your
first row remain visible, but also Cols A-B will always remain visible (if
you scrool to the right)

"SeabeePlumber" wrote:

I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
Thanks

Select cell A2
Choose WindowsFreeze Panes

SeabeePlumber wrote:
I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Selecting A1 and Freeze Panes will freeze panes in the center of the window.

Not what OP asked for.

Select A2 to freeze row 1.

Select B2 to freeze row 1 and column A.

Everything above and to the left of selected cell will be frozen.


Gord Dibben Excel MVP



On Sun, 10 Apr 2005 10:17:02 -0700, Kassie
wrote:

If you want to freeze the entire first row, with your cursor in Cell A1,
click on Windows|Freeze panes.

If you move your cursor to say C1 before doing this, not only will your
first row remain visible, but also Cols A-B will always remain visible (if
you scrool to the right)

"SeabeePlumber" wrote:

I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
Thanks

Thanks gordon, that was a bad lapsus latina

"Gord Dibben" wrote:

Selecting A1 and Freeze Panes will freeze panes in the center of the window.

Not what OP asked for.

Select A2 to freeze row 1.

Select B2 to freeze row 1 and column A.

Everything above and to the left of selected cell will be frozen.


Gord Dibben Excel MVP



On Sun, 10 Apr 2005 10:17:02 -0700, Kassie
wrote:

If you want to freeze the entire first row, with your cursor in Cell A1,
click on Windows|Freeze panes.

If you move your cursor to say C1 before doing this, not only will your
first row remain visible, but also Cols A-B will always remain visible (if
you scrool to the right)

"SeabeePlumber" wrote:

I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
Thanks

lapsus latina

Same like a brain-fart or a senior moment<g


Gord

On Sun, 10 Apr 2005 11:57:02 -0700, Kassie
wrote:

Thanks gordon, that was a bad lapsus latina

"Gord Dibben" wrote:

Selecting A1 and Freeze Panes will freeze panes in the center of the window.

Not what OP asked for.

Select A2 to freeze row 1.

Select B2 to freeze row 1 and column A.

Everything above and to the left of selected cell will be frozen.


Gord Dibben Excel MVP



On Sun, 10 Apr 2005 10:17:02 -0700, Kassie
wrote:

If you want to freeze the entire first row, with your cursor in Cell A1,
click on Windows|Freeze panes.

If you move your cursor to say C1 before doing this, not only will your
first row remain visible, but also Cols A-B will always remain visible (if
you scrool to the right)

"SeabeePlumber" wrote:

I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
Thanks