column

  • Thread starter Thread starter hootie
  • Start date Start date
H

hootie

how do i lock a column and make it follow me accross a page so i can see it
while working in other columns?
 
You can either try freeze panes options or use the Spit option.
XL07: View>Split/Freeze Panes
XL03: Window>Split/Freeze Panes

(If you use the split option you can drag the horizontal split to top so as
to have the vertical one alone..)


If this post helps click Yes
 
Select the column to the right of the one you want to lock, then go to Window
- Freeze panes.
 
Try Window > Split if you want to work/scroll on both sides of the fixed column
Assume you want to keep col X "fixed", first scroll the sheet horizontally
so that col X is visible roughly in the centre of the screen, then select the
adjacent col Y, click Window > Split to split it vertically. Now you can
scroll/work independently on either side of the split. Tinker around with
Window > Freeze pane as well.
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
thanks that was just what i was looking for

Jacob Skaria said:
You can either try freeze panes options or use the Spit option.
XL07: View>Split/Freeze Panes
XL03: Window>Split/Freeze Panes

(If you use the split option you can drag the horizontal split to top so as
to have the vertical one alone..)


If this post helps click Yes
Click to expand...
 
Back
Top