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
<[email protected]> 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 Window>Freeze 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
<[email protected]> 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.

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

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)



"MichaelG1947" <[email protected]> wrote in message
news:[email protected]...
> 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.