How do I make a row or information, follow as you scroll down..?

How do I make a row or information, follow as you scroll down..?

I've seen spreadsheets that allow a row or rows of information follow along
the top of the screen as I scrolled down, so I didn't have to keep looking
back up to enter data in the correct column.

Thanks,
Dave
dclemens@longwall.com

place the cursor below and to the right of what you want to "freeze"
window>freeze panes

--
Don Guillett
SalesAid Software
donaldb@281.com
"Dave_86" <Dave_86@discussions.microsoft.com> wrote in message
news:0E73AA94-BD4A-4BC3-98E5-53B1EC5E7F21@microsoft.com...
> How do I make a row or information, follow as you scroll down..?
>
> I've seen spreadsheets that allow a row or rows of information follow
along
> the top of the screen as I scrolled down, so I didn't have to keep looking
> back up to enter data in the correct column.
>
> Thanks,
> Dave
> dclemens@longwall.com
>

Hi Dave,
See http://www.mvps.org/dmcritchie/excel/freeze.htm

For Display use Freeze Panes, select a cell past the
row and column you want to freeze. i.e. B2
then use Window (menu), Freeze Pane

For Printing under File, Page Setup, Sheet
Rows to repeat at top $1:$1
Columns to repeat at left $A:$A
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave_86" <Dave_86@discussions.microsoft.com> wrote in message news:0E73AA94-BD4A-4BC3-98E5-53B1EC5E7F21@microsoft.com...
> How do I make a row or information, follow as you scroll down..?
>
> I've seen spreadsheets that allow a row or rows of information follow along
> the top of the screen as I scrolled down, so I didn't have to keep looking
> back up to enter data in the correct column.
>
> Thanks,
> Dave
> dclemens@longwall.com
>