How do I keep line one from scrolling in excel?

S

SeabeePlumber

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

Kassie

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)
 
G

Gord Dibben

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
 
K

Kassie

Thanks gordon, that was a bad lapsus latina

Gord Dibben said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
List all tables, including document structure 0
Auto populate value from one task to another in MS PROJECT 0
How to make scroll bar permanently visible, Word 365 0
Integrating information from Word to Excel (not mail merge) 1
Style Gallery View 3
Word- Find and Replace 1
Possible to Combine reports to's to a single box? 0

Top