You can freeze panes so that certain columns are always visible.
Is that what you meant?
If yes, then make sure the column(s) that should be visible is showing.
Then select the column to the right
and window|Freeze Panes (in xl2003 menus)
For instance if I wanted column A to be always visible, I would make sure column
A is visible to start.
Then select column B and window|freeze Panes.