I have 30 worksheets in a single spreadsheet. Can I stack works sheet in 2
or 3 rows so that I can see all of the worksheets at once?

Thanks.

You will need to use Window / New Window 30 times to get 30 views of the
same worksheet
Windows / Arrange / Tile Horizontally
Click the tabs one-by-one to see each worksheet
Then drag them (drag the tile bar - the blue zone at top of each worksheet)
as needed

Need to do this often? Then record a VBA subroutine.
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Eastendkid" wrote in message
...
I have 30 worksheets in a single spreadsheet. Can I stack works sheet in 2
or 3 rows so that I can see all of the worksheets at once?

Thanks.

Eastendkid wrote...
I have 30 worksheets in a single spreadsheet. *Can I stack works sheet in 2
or 3 rows so that I can see all of the worksheets at once?

If you mean stack worksheet tabs, no.

You want to look at:
http://contextures.com/xlToolbar01.html
(From Debra Dalgleish's site.)

It builds a toolbar that you can use with any workbook to navigate to any
worksheet.

There's a link to an xl2007/ribbon version (by Ron de Bruin) on Debra's site.

=======
If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Eastendkid wrote:

I have 30 worksheets in a single spreadsheet. Can I stack works sheet in 2
or 3 rows so that I can see all of the worksheets at once?

Thanks.

--

Dave Peterson