No zoom to page option ???

[Blue Max]

Doesn't Excel 2007 have an option to quickly zoom to the full page, the
width, or the height?

Most current programs provide quick menu options or toolbar buttons for
viewing a page, or in this case a worksheet, in one screen or at full width
or full height. Even Word 2007 provides these options.

I recognize that there may be issues with the fact a worksheet can span
multiple pages, but this issue could be easily resolved. Simply allow the
user to toggle an option that would instruct Excel, for purposes of the
screen display, to base the zoom options on pages as printed or on the
worksheet as a single page.

 

[Luke M]

The closest thing I can think of is the View - Print Layout selection. But
as you mentioned, the view you describe doesn't always make sense as
worksheets can span hundreds of printed pages.

 

[ozgrid.com]

Custom View?

 

[Blue Max]

Thanks, Dave. Good work-around, but we were hoping for a one-button
feature, without any pre-configuration, like you find in Microsoft Word 2007
or other applications.

Thanks,
Richard

*****************

 

[Blue Max]

Thanks, Luke, that does give us another option. However, we would still
like to see a one-button solution like Word 2007. As to the definition of a
page, I think that can be easily overcome. Simply provide an option that
allows the user to define a display page in relation to print pages. For
example, 1=0.5, 1=1, 1=1.5, 1=2 and so on.

Thanks,
Richard

**************

 

[ozgrid.com]

Record a macro showing/removing your Custom View and assign them to a
buttons/shapes.
http://www.ozgrid.com/Excel/assign-macros.htm