Tricky Freeze Panes question

[MartinM]

Hi all Excel Wiz's out there!

This is what I want to do:

I would like to have cells A1-A22 static, always visible, and still be
able to scroll horizontally and vertically. I have tried to do this
with freeze panes but can't get it to work.

Thankful for any help!

Martin

 

[Gord Dibben]

Martin

To freeze A1:A22 select B23 and Window>Freeze Panes.

Note: you cannot freeze just a column without freezing the rows also. Rows 1
through 22 will also be frozen. Which is maybe why you state "can't get it to
work".

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[MartinM]

Tack Anna,

Thanks everyone!

Martin

Hi Martin,


If your intention is to not freeze the rows when you freeze a column
you should instead try the Windows/Split screens (with cursor in B23
sheet will be split in four screens). It won't make your selection
static as would freeze panes, but if you only move around in the
bottom right screen it will seem as if it was.

Regards,
Anna B