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.