ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Viewing worksheets side by side (https://www.excelbanter.com/excel-discussion-misc-queries/94800-viewing-worksheets-side-side.html)

Peter

Viewing worksheets side by side
 
Can you view worksheets in the same workbook side by side on the screen as
you can with different workbooks?
Many thanks
--
Peter
London, UK

Nika Lampe

Viewing worksheets side by side
 
Peter,

sure you can... you just open your workbook and then select menu Window -
New window and your workbook is displayed twice or more times if you repeat
the above.
And than you can view them as you like by selecting Window - Arrange...

Regards,
Nika Lampe

"Peter" je napisal:

Can you view worksheets in the same workbook side by side on the screen as
you can with different workbooks?
Many thanks
--
Peter
London, UK


Gord Dibben

Viewing worksheets side by side
 
Yes

With one workbook open.

WindowNew Window

WindowArrangeVertical(or whatever suits you)

Set one window to sheet1 and other window to sheet2.


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 11:40:02 -0700, Peter
wrote:

Can you view worksheets in the same workbook side by side on the screen as
you can with different workbooks?
Many thanks




All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com