freezing panes

[dusty]

I have a frozen panes such that column A is stationary and row 1.

Is it possible to also freeze say column z?

 

[HaHoBe]

Hi, dusty,

no - standard is rows to the top and columns to the left with no spaces in between. Maybe you could use graphics instead but you won´t be able to change values or formulas this way.

Ciao,
Holger

 

[Kryst51]

Hi Dusty, unfreeze, then select the cell to the right ofwhere you want the freezing to be, such as C2 then hit freeze. This wil freeze columns A and B and row one, you can freeze however much you want jut by selecting the cell to the right of the column you want to freeze at and underneath the row you want to freeze at.

 

[dusty]

Thanks Holger


Kryst51 I dnt think I was clear in my description but I want to freeze column A and Z but not in between so the columns inbetween scroll as usual.

 

[Kryst51]

Oh...... I See. Sorry.