Advise needed on freezing panes in excel.

[ghrek]

Hi

I know how to freeze a pain so it allows the data to the right of where it frozen to be moved but im trying to do it the other way round so I can move cells to the left of the freezing point and freeze to the right as I have data on the right I do not want people to see.

Any Ideas

 

[Joe4]

I think Freeze panes only works from the Top-down and/or from the Left-to-the-right.
I don't think you can make it works the other way.

Why not hide the columns you don't want people to see?

 

[ghrek]

Could do but I have some linked formulas in the cells I want to hide will it still work?

 

[Joe4]

Could do but I have some linked formulas in the cells I want to hide will it still work?

Yes. Hiding the columns should have no impact on those formulas.
There is an easy way to check. Try it and see!