Print view and freeze pane in escel 2007

Hi all,

...just started using Excel 2007, but for some reasoin when I want to see "print view", I get the message that to do this it will have to remove the "freeze" column option...is ther eany reason for this, or any way to overcome this problem?

Many thanks,

Stu

Hi,

Freeze Panes is an on-screen setting and it has got nothing to do with printing. If you are taking a print, freeze pane won't allow you to skip the data you hide. I would suggest that you hide rows that you don't want to print before printing and unhide them again when you're finished.

Warm regards,
Ishtiyaq