Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Centering a worksheet for viewing
For viewing purposes, I frequently hide all the columns that exceed
what a single page would print so that I can focus only on what I know is the actual page. In doing so, the worksheet hugs the left side of the screen with everything to the right of the page in grey--about half the screen. Is there a way to make the visible portion of the worksheet center itself in the middle of the screen? Left and right is all that's important--not top and bottom. Thanks. Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Centering a worksheet for viewing
Michael,
If you mean you want to maximise the view of the remaining, visible columns, then may be : Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select ActiveWindow.Zoom = True Range("A1").Select You cannot have a blank area to the left of cells, as you can to right, so you cannot shift the visible cells as you describe. If you mean move the display Window within the Excel environment, you can set the window(1).left/width etc. NickHK wrote: For viewing purposes, I frequently hide all the columns that exceed what a single page would print so that I can focus only on what I know is the actual page. In doing so, the worksheet hugs the left side of the screen with everything to the right of the page in grey--about half the screen. Is there a way to make the visible portion of the worksheet center itself in the middle of the screen? Left and right is all that's important--not top and bottom. Thanks. Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Centering a worksheet for viewing
I feared I couldn't obtain a space to the left as I had hoped and as
you verified. Thanks. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Centering a picture in a worksheet | Excel Discussion (Misc queries) | |||
Only one worksheet in a workbook is available for viewing. | Excel Discussion (Misc queries) | |||
Viewing a worksheet within a Userform | Excel Programming | |||
Viewing worksheet tabs | Excel Discussion (Misc queries) | |||
Worksheet tabs viewing there of | Excel Worksheet Functions |