I need to view two worksheets in the same workbook at one time, how can I go about doing this?
M MarieMc Jan 11, 2005 #1 I need to view two worksheets in the same workbook at one time, how can I go about doing this?
J Jan Karel Pieterse Jan 11, 2005 #2 Hi MarieMc, I need to view two worksheets in the same workbook at one time, how can I go about doing this? Click to expand... 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
Hi MarieMc, I need to view two worksheets in the same workbook at one time, how can I go about doing this? Click to expand... 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
B Bob Phillips Jan 11, 2005 #3 Goto menu Window>Arrange..., a few options there. -- HTH RP (remove nothere from the email address if mailing direct)
Goto menu Window>Arrange..., a few options there. -- HTH RP (remove nothere from the email address if mailing direct)
D Dave Peterson Jan 12, 2005 #4 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.
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.