Arrange Worksheets

L

leolin

Hi,

I am wondering if you can arrange worksheets in Excel as
you would arrange workbooks. Does anyone know how to do
this?

Ie.
Windows/arrange/vertical [except i want to do this for
work sheets [tabs] and not two different workbooks.

Thanks for your help.
 
R

RagDyer

Do this as many times as you have sheets in the WB:
<Window> <NewWindow>
You'll see a number appended to the name of the WB for each window created.
Then,
<Window> <Arrange>
Make sure "Windows In Active WB" is checked,
And choose the configuration you want.

When you're done with these windows, you should close them before you save
the WB, or they'll remain there indefinately.
Best way to close is to focus on the highest numbered window, then
<Ctrl> <W> as many times as necessary to return to WB name that's
*un-numbered*.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi,

I am wondering if you can arrange worksheets in Excel as
you would arrange workbooks. Does anyone know how to do
this?

Ie.
Windows/arrange/vertical [except i want to do this for
work sheets [tabs] and not two different workbooks.

Thanks for your help.
 
Top