![]() |
Can I view separate worksheets at the same time?
I need to view two worksheets in the same workbook at one time, how can I go
about doing this? |
Hi MarieMc,
I need to view two worksheets in the same workbook at one time, how can I go about doing this? From the menu: Window, New window. Then: Window, Arrange. Select an arrangement and check "Windows of active workbook" Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
Goto menu WindowArrange..., a few options there.
-- HTH RP (remove nothere from the email address if mailing direct) "MarieMc" wrote in message ... I need to view two worksheets in the same workbook at one time, how can I go about doing this? |
After you do that window|new window, and you'll see something like:
book1.xls:1 book1.xls:2 (the :# represents those windows--not separate copies of the workbook). When you get tired of seeing those separate windows, select the one you don't want anymore. Hit ctrl-w to close it. Remember to save the workbook the way you like. MarieMc wrote: I need to view two worksheets in the same workbook at one time, how can I go about doing this? -- Dave Peterson |
All times are GMT +1. The time now is 11:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com