Block or freeze colum

[Jimeson]

Hi folks,

my question is... how do i freeze or block a colum so it will always be visible when i scroll to the right.

when i scroll to the right i alwys wanna see colum A.

excuse me for my english.

Tnx in advance !

Jim

[sweep]

Please see attachment

Dave

[Jimeson]

tnx Sweep,

but thats not the way i meant. there is another way to do that.
but i can't seem to find it anymore.
i've done i before and blocked colum A and row 1 & 2, so where ever a scroll to those 2 rows en 1 colum stay visible.

tnx for more info

Greetz !
Jim

[VBA Noob]

Try Freeze pane

http://www.bettersolutions.com/excel...N116716332.htm

Think you need to select cell B3

VBA Noob

[Jimeson]

Tnx VBA Noob !

your info did help me in the way i want my sheet to appear.
many tnx dude !

Greetz !

this threat can be closed if mod or admin wants to

Jim