Excel title bar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lillian Lian - 04 Oct 2007 20:06 GMT

I have big excel spread sheet, and the first row is the title with

username, Ip Address, machine name

if scrow down to row 500, I lost the first row of the title bar along with
the page, is anyway when I scrow down I can have my first row of title bar
with me all the time, so no matter what row you are on it, you always can see
the title?

Thanks.

Lillian

Reply to this Message

Sandy Mann - 04 Oct 2007 20:13 GMT

Select B1 then select Window > Freeze Panes

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

>I have big excel spread sheet, and the first row is the title with
>
[quoted text clipped - 9 lines]
>
> Lillian

Reply to this Message

Sandy Mann - 04 Oct 2007 20:26 GMT

Damn! Of course as Earl said I meant Select A2

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Select B1 then select Window > Freeze Panes
>
[quoted text clipped - 13 lines]
>>
>> Lillian

Reply to this Message

Earl Kiosterud - 04 Oct 2007 20:17 GMT

Lillian,

Select cell A2. Window - Freeze panes. Now when you scroll down, row 1 will remain on the
screen.

If you'll be also scrolling to the right, and would like to keep the first column also on
the screen, do the above with B2 selected. For columns A and B, select C2, etc.

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

>I have big excel spread sheet, and the first row is the title with
>
[quoted text clipped - 8 lines]
>
> Lillian

Reply to this Message