 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / May 2008Print Preview is missing: Freeze Panes issue
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 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 On 3/28/08 4:09 AM, in article ee96700.-1@webcrossing.caR9absDaxw, > Version: 2008 > Operating System: Mac OS X 10.5 (Leopard) [quoted text clipped - 12 lines] > Thanks, > Wim  SignaturePat McMillan Macintosh Business Unit Microsoft Corp. This posting is provided ³AS IS² with no warranties, and confers no rights. 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 Thanks again, Wim. That's good feedback. I will pass it on to the team. Pat On 3/30/08 9:20 PM, in article ee96700.1@webcrossing.caR9absDaxw, > Thanks for you're reaction Pat, > [quoted text clipped - 14 lines] > Best regards, > Wim SignaturePat McMillan Macintosh Business Unit Microsoft Corp. This posting is provided ³AS IS² with no warranties, and confers no rights. 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 > Thanks again, Wim. That's good feedback. I will pass it on to the team. > [quoted text clipped - 26 lines] > Microsoft Corp. > This posting is provided �AS IS� with no warranties, and confers no rights. Thanks Wim. We'll consider that feedback for a future release too. Thanks, Pat On 4/18/08 4:33 AM, in article ee96700.3@webcrossing.caR9absDaxw, > I'd like to add another suggestion: > [quoted text clipped - 38 lines] >> This posting is provided �AS IS� with no warranties, and >> confers no rights. SignaturePat McMillan Macintosh Business Unit Microsoft Corp. This posting is provided ³AS IS² with no warranties, and confers no rights. 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... On 5/2/08 7:58 AM, in article ee96700.5@webcrossing.caR9absDaxw, > 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. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.