Freeze Pane??

[ssei1]

IS IT POSSIBLE TO FREEZE THE PANE or do window splists SO THAT THE LEFT
FOUR COLUMNS ARE FROZEN and MY FAR RIGHT HAND COLUMN IS FROZEN. I have
96 columns in-between column 4 and 100, which can not all fit on the
screen at the same time. I would like column2 1-4 and 100 to always
show on the screen and the others to move "beneath" them as requried by
user scrolling or mouse movement.

1 2 3 4...............................5 -
99.................................100



HELP!

Thanks in advance

 

[Ken Wright]

No, but why not insert a column between 4 and 5 and then have it reference the values in
your 101st column. that way you will always be able to see the Totals.

 

[ray]

one way:
see help on viewing 2 parts of the sheet at the same time.
You must unfreeze the pane for this to work
good luck