how do I "freeze" the left hand title column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DDAANN - 25 Feb 2006 20:34 GMT

I want the three left hand columns of my excel worksheet to remain fixed
while I scroll across the remaining 22 columns. How can I do this?

Reply to this Message

Dave Peterson - 25 Feb 2006 20:38 GMT

Select column D and window|freeze Panes.

You could even select D5 and have A:C frozen as well as rows 1:4.

Everything to the left of the selected cell and above that selected cell will be
frozen.

> I want the three left hand columns of my excel worksheet to remain fixed
> while I scroll across the remaining 22 columns. How can I do this?

Signature

Dave Peterson

Reply to this Message

dmexcel - 25 Feb 2006 22:27 GMT

in the bottom right corner by the scroll arrow you can grab the end of
the scroll box and drag it accross to the column the you need to see
all the time, you can also do this with the top right corner for the
headings

Reply to this Message

Dave Peterson - 25 Feb 2006 23:16 GMT

This actually splits the window. It's slightly different than freezing the
panes--each pane can be scrolled independently.

But it may be just what the OP wants.

> in the bottom right corner by the scroll arrow you can grab the end of
> the scroll box and drag it accross to the column the you need to see
> all the time, you can also do this with the top right corner for the
> headings

Signature

Dave Peterson

Reply to this Message

dmexcel - 26 Feb 2006 12:21 GMT

Right,
Not a lot people now about this

Reply to this Message