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!

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!