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
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
Please see attachment
Dave
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
Try Freeze pane
http://www.bettersolutions.com/excel...N116716332.htm
Think you need to select cell B3
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks