Thread: How do I define a line to appear on top, regardless of scrolling d

How do I define a line to appear on top, regardless of scrolling down?
I simply need that the "title" (top) line will remain in my view while
scrolling down.

position cursor under and to the right of the area desired>window>freeze
panes

--
Don Guillett
SalesAid Software
donaldb@281.com
"Line on top" <Line on top@discussions.microsoft.com> wrote in message
news:B3C158E8-47C9-4971-8152-33AE632064DF@microsoft.com...
> How do I define a line to appear on top, regardless of scrolling down?
> I simply need that the "title" (top) line will remain in my view while
> scrolling down.

Go your titles line in Column A and click on Windows>Freeze panes.
If you also want to continue to see Column A as you scroll to the right
you can use Windows>Freeze panes in Column B idea.

"Line on top" wrote:

> How do I define a line to appear on top, regardless of scrolling down?
> I simply need that the "title" (top) line will remain in my view while
> scrolling down.

You would click on the row below the titles row and then freeze panes.

If you click on row 1, the freeze line will be mid-window.

B1 to freeze row 1.

B2 to freeze row 1 and column A

i.e. everything above and left of the selected cell will be frozen.


Gord Dibben Excel MVP



On Wed, 23 Mar 2005 06:03:01 -0800, "ww" <ww@discussions.microsoft.com> wrote:

>Go your titles line in Column A and click on Windows>Freeze panes.
>If you also want to continue to see Column A as you scroll to the right
>you can use Windows>Freeze panes in Column B idea.
>
>"Line on top" wrote:
>
>> How do I define a line to appear on top, regardless of scrolling down?
>> I simply need that the "title" (top) line will remain in my view while
>> scrolling down.