Keeping column name in view when scrolling

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Geoman - 27 Jul 2007 04:24 GMT

Is there a way that when you name a column that it stays in view if you
scroll down?

Also, what about doing the same thing with a row?

It would be nice to be able to scroll down and still see what column and row
is named.

Rich

Reply to this Message

Greg Wilson - 27 Jul 2007 05:12 GMT

From the main toolbar, select:

Window > Freeze Panes (converts to Unfreeze panes to undo)

This will cause the window to "freeze" at the top-left corner of the
selected cell. To only achieve this effect for columns, select a cell in
column A (other than cell A1) so that there is no worksheet area to the left.
Similarly, to only achieve this effect for rows, select a cell in the top row
(other than cell A1) so that there is no worksheet area above.

Greg

> Is there a way that when you name a column that it stays in view if you
> scroll down?
[quoted text clipped - 5 lines]
>
> Rich

Reply to this Message

JLatham - 27 Jul 2007 05:44 GMT

And choose B2 as the Freeze point if you want Column A and Row 1 to always be
visible, thus keeping your column headers and perhaps a list of row or other
info in site.

> From the main toolbar, select:
>
[quoted text clipped - 17 lines]
> >
> > Rich

Reply to this Message