Thread: [SOLVED] leave left column in place as you scroll to the right

I've noticed on spreadsheets that have been sent to me that there is a way to
be able to leave the left-hand column (column A usually) showing even as you
scroll right through a very wide sheet. The obvious benefit is that it
leaves the ROW definition showing at all times.
Can someone tell me how this is done?

Thanks

Select cell B1 and choose Freeze Panes from the Window menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"AccessNewbie" <AccessNewbie@discussions.microsoft.com> wrote in
message
news:E18535AE-0EE1-4A40-BB30-125670DCF37E@microsoft.com...
> I've noticed on spreadsheets that have been sent to me that
> there is a way to
> be able to leave the left-hand column (column A usually)
> showing even as you
> scroll right through a very wide sheet. The obvious benefit is
> that it
> leaves the ROW definition showing at all times.
> Can someone tell me how this is done?
>
> Thanks
>

Hi

Place your cursor in Cell B2
Windows>Freeze Panes
This will keep column A visible as you scroll across, and row 1 visible
as you scroll down.

Regards

Roger Govier



AccessNewbie wrote:

>I've noticed on spreadsheets that have been sent to me that there is a way to
>be able to leave the left-hand column (column A usually) showing even as you
>scroll right through a very wide sheet. The obvious benefit is that it
>leaves the ROW definition showing at all times.
>Can someone tell me how this is done?
>
>Thanks
>
>
>

To leave column 'A' in view:

Select cell 'B1' > Window > Freeze Panes.

HTH

George Gee


AccessNewbie wrote:
> I've noticed on spreadsheets that have been sent to me that there is
> a way to be able to leave the left-hand column (column A usually)
> showing even as you scroll right through a very wide sheet. The
> obvious benefit is that it leaves the ROW definition showing at all
> times.
> Can someone tell me how this is done?
>
> Thanks