Can you keep column (field) names visible while scrolling downwar.

G

Guest

Is there a way to keep the column (field) headings ("name", "address",
"status", etc.) visible when scrolling through your spreadsheet? I am using
Windows XP Home and Word Suite 2003.
 
G

Gord Dibben

Michael

Select A2 and Window>Freeze Panes to freeze row 1.

B2 to freeze row 1 and Column A.


Gord Dibben Excel MVP
 
P

Peo Sjoblom

You can freeze rows, for instance if you want to freeze the first row select
A2 and do windows>freeze panes

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

Excel Word Mail Merge 8
Worksheet Row/Column Boundaries Question 3
Keep Top Row and Side Column always visible 3
Pasting with links when transposing 1
Best Practice for Public Variables for Column Headings 2
Automatically add a column to summary sheet if another worksheet i 2
Sorting problem 2
Finding the next record in a column 2

Top