leave left column in place as you scroll to the right

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
To leave column 'A' in view:

Select cell 'B1' > Window > Freeze Panes.

HTH

George Gee
 
Back
Top