Print Preview is missing: Freeze Panes issue

[wimek]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I know that this issue is mentioned in several threads and I know I'm supposed to use Page view. However there's one serious drawback: when switching between page view and normal view, Excel forces me to remove frozen panes. This is a real pain, specially with large sheets.

It would be great is frozen panes are bound and thus shown only in the view where you've set them. Am I overlooking something? Please help or change Excel so frozen panes can remain in tact. This issue almost makes me switch back to Excel 2004.

Thanks,
Wim

 

[Pat McMillan]

Hi,

The reason Excel doesn't support freeze panes in Page Layout View is that
Page Layout is a view that shows the workbook exactly as it will print out.
Since frozen (and split) panes don't print it doesn't make sense to display
them in Page Layout View. If you're suggesting that we at least maintain
split panes regardless of view, but only show them when in Normal view, I
think that's a great suggestion and will pass it on to the team. There may
be a reason I'm not aware of it why we can't support that, but I'm not aware
of it.

I do have a question regarding your comment about Excel 2004. As far as I'm
aware our behavior in this regard is the same in 2008 as it was in 2004. Are
you seeing something different?

Thanks,

Pat

 

[wimek]

Thanks for you're reaction Pat,

You're absolutely right about page view having the same reaction in Excel 2004 and 2008. However, in Excel 2004 I can use the build in print preview to adjust page settings and headers and footers being able to switch back and forth quickly between the print preview and the printer settings dialog without losing the frozen panes. In Excel 2008 the build in print preview is missing. That gives me the hassle to do the following:

switch to page layout (and lose my frozen panes)
open printer settings
adjust
close printer settings
switch to normal view
again set the frozen panes...

Best regards,
Wim

 

[Pat McMillan]

Thanks again, Wim. That's good feedback. I will pass it on to the team.

Pat

 

[wimek]

I'd like to add another suggestion:

it would be handy when during switching from normal view to page layout and back not only frozen panes, but also things like zoom level remain the same in the normal view while in page layout the default should be to view the whole first page...

Greetings,
Wim

 

[Pat McMillan]

Thanks Wim. We'll consider that feedback for a future release too.

Thanks,

Pat

 

[ASLP_IT_Guy]

Hi there

Sign me up for the same feedback as Wimek. This is causing much annoyance to our Accounts guys. I can see the logic in ditching the Print Preview mode, but to break the zooming and pane freezing seems to have missed the mark, somehow...

 

[Bob Greenblatt]

Hi there

Sign me up for the same feedback as Wimek. This is causing much annoyance to
our Accounts guys. I can see the logic in ditching the Print Preview mode, but
to break the zooming and pane freezing seems to have missed the mark,
somehow...

Sign yourself up via the send Feedback in the Help menu.