ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   No zoom to page option ??? (https://www.excelbanter.com/new-users-excel/261132-no-zoom-page-option.html)

Blue Max

No zoom to page option ???
 
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[_4_]

No zoom to page option ???
 
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.

--
Best Regards,

Luke M
"Blue Max" wrote in message
...
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.




ozgrid.com

No zoom to page option ???
 
Custom View?


--
Regards
Dave Hawley
www.ozgrid.com
"Blue Max" wrote in message
...
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.



Blue Max

No zoom to page option ???
 
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

*****************
"ozgrid.com" wrote in message
...
Custom View?


--
Regards
Dave Hawley
www.ozgrid.com
"Blue Max" wrote in message
...
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.



Blue Max

No zoom to page option ???
 
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

**************
"Luke M" wrote in message
...
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.

--
Best Regards,

Luke M
"Blue Max" wrote in message
...
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.




ozgrid.com

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



--
Regards
Dave Hawley
www.ozgrid.com
"Blue Max" wrote in message
...
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

*****************
"ozgrid.com" wrote in message
...
Custom View?


--
Regards
Dave Hawley
www.ozgrid.com
"Blue Max" wrote in message
...
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.





All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com