ExcelBanter - Keeping cells in place

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Keeping cells in place (https://www.excelbanter.com/excel-worksheet-functions/15727-keeping-cells-place.html)

Keeping cells in place

How do I keep the (A) Cloumn in from moving if I have the page view go Left
and right?

And the (1) Row from moving if I move the page up & down?

Lady Layla

Place your cursor in cell B2 and go to Window | Freeze Pane

"Rj" wrote in message
...
: How do I keep the (A) Cloumn in from moving if I have the page view go Left
: and right?
:
: And the (1) Row from moving if I move the page up & down?

Thanks

"Lady Layla" wrote:

Place your cursor in cell B2 and go to Window | Freeze Pane

"Rj" wrote in message
...
: How do I keep the (A) Cloumn in from moving if I have the page view go Left
: and right?
:
: And the (1) Row from moving if I move the page up & down?

Gord Dibben

Select B2 and WindowFreeze Panes.

Gord Dibben Excel MVP

On Wed, 2 Mar 2005 09:11:01 -0800, "Rj" wrote:

How do I keep the (A) Cloumn in from moving if I have the page view go Left
and right?

And the (1) Row from moving if I move the page up & down?

All times are GMT +1. The time now is 05:12 PM.