How can I stack worksheets (I have 30 worksheets)

[Eastendkid]

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.

 

[Bernard Liengme]

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

 

[Harlan Grove]

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.

 

[Dave Peterson]

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 here:
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.)