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" wrote in
message
...
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
WindowsFreeze 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