Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center spreadsheet in middle of window
I would like to center my displayed columns in the middle of my window
instead of the current position on the left. Most of the columns on my worksheets are either hidden or deleted which leaves a couple inches to the right of the worksheet empty on my screen. Is there a way to center the displayed columns without expanding them or manipulating the worksheet? Perhaps with VBA? It's just a little thing, but it's like looking at a website that is not centered on your screen when IE is maximized. It works fine, just is a little annoying. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center spreadsheet in middle of window
See http://www.cpearson.com/Excel/zoom.htm#center for some example
VBA code to center a range of cells in the active window. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 18 Aug 2009 11:45:48 -0700 (PDT), dgold82 wrote: I would like to center my displayed columns in the middle of my window instead of the current position on the left. Most of the columns on my worksheets are either hidden or deleted which leaves a couple inches to the right of the worksheet empty on my screen. Is there a way to center the displayed columns without expanding them or manipulating the worksheet? Perhaps with VBA? It's just a little thing, but it's like looking at a website that is not centered on your screen when IE is maximized. It works fine, just is a little annoying. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze in the middle of a spreadsheet. | Excel Discussion (Misc queries) | |||
Center displayed columns in middle of window | Excel Programming | |||
VBA to center Selected Cell in Current Window | Excel Programming | |||
how do i center the worksheet in the viewing window? | Excel Discussion (Misc queries) | |||
How to move pictures to the center of window? | Excel Programming |