Keeping column name in view when scrolling
 

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

Keeping column name in view when scrolling
 

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


"Geoman" wrote:

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

Keeping column name in view when scrolling
 

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.

"Greg Wilson" wrote:

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


"Geoman" wrote:

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