Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Zoom and Page Break Preview | Excel Discussion (Misc queries) | |||
No zoom in print preview on landscaped page | Excel Discussion (Misc queries) | |||
recalculate page breaks after setting Zoom in pagesetup | Excel Discussion (Misc queries) | |||
Should the zoom option always be available in charts? | Charts and Charting in Excel | |||
How do you set default page break preview zoom to 100%? | Setting up and Configuration of Excel |