MrExcel Publishing
Your One Stop for Excel Tips & Solutions

View 2 worksheets at once?


Posted by jackie on February 14, 2002 6:36 AM

Is it possible to view 2 worksheets in the same file at the same time? I know you can view 2 or more files at the same time. What about in the same workbook?
Thanks
J


Posted by Mudface on February 14, 2002 6:45 AM

Click on Window- New Window, then Window-Arrange-Horizontal (or whichever view you prefer). Note that if you have other workbooks open you may need to resize or minimise their windows so it doesn't get too confusing.

Posted by jackie on February 14, 2002 7:55 AM

Thanks for the quick response. Just to clarify: I want to see 2 worksheets in the SAME workbook (i.e. look at sheet1 and sheet2)
J

Posted by Mudface on February 14, 2002 11:17 AM

That *will* show two sheets from the same workbook (honest!). Do what I said below, and try changing sheets on one of the copies...

Posted by jackie on February 14, 2002 12:57 PM

My impatience strikes again! It workds. Sorry about that. Thanks for the info.
J