ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I view separate worksheets at the same time? (https://www.excelbanter.com/excel-discussion-misc-queries/3506-can-i-view-separate-worksheets-same-time.html)

MarieMc

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?

Jan Karel Pieterse

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


Bob Phillips

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?




Dave Peterson

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