A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

No zoom to page option ???



 
 
Thread Tools Display Modes
  #1  
Old April 9th, 2010, 05:28 PM posted to microsoft.public.excel.newusers
Blue Max
external usenet poster
 
Posts: 301
Default 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.

  #2  
Old April 9th, 2010, 07:50 PM posted to microsoft.public.excel.newusers
Luke M[_4_]
external usenet poster
 
Posts: 451
Default 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.



  #3  
Old April 10th, 2010, 02:53 AM posted to microsoft.public.excel.newusers
ozgrid.com
external usenet poster
 
Posts: 328
Default 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.


  #4  
Old April 11th, 2010, 02:50 AM posted to microsoft.public.excel.newusers
Blue Max
external usenet poster
 
Posts: 301
Default 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.


  #5  
Old April 11th, 2010, 03:03 AM posted to microsoft.public.excel.newusers
Blue Max
external usenet poster
 
Posts: 301
Default 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.



  #6  
Old April 11th, 2010, 03:19 AM posted to microsoft.public.excel.newusers
ozgrid.com
external usenet poster
 
Posts: 328
Default 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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.