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

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

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