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

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.

Window menu, Freeze Panes. See Help for more information.

On Wed, 12 Jan 2005 18:37:02 -0800, MichaelG1947
wrote:

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.

Michael

Select A2 and WindowFreeze Panes to freeze row 1.

B2 to freeze row 1 and Column A.


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 18:37:02 -0800, MichaelG1947
wrote:

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.

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

--
Regards,

Peo Sjoblom

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



"MichaelG1947" wrote in message
...
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.

Sure. Check out:

http://www.techonthenet.com/excel/questions/freeze.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.