ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to split screen & display 2 different workbooks? (https://www.excelbanter.com/excel-discussion-misc-queries/230761-how-split-screen-display-2-different-workbooks.html)

LINDA

How to split screen & display 2 different workbooks?
 


Bernard Liengme[_3_]

How to split screen & display 2 different workbooks?
 
In classic Excel:
open the two workbooks
use menu command Window | Arrange | Tiled
Now you can see sheets from both workbooks side by side

To see two sheets of the same workbook:
use menu command Window | New Window and open the second sheet
use menu command Window | Arrange | Tiled
Now you can see the 2 sheets side by side

The steps are similar in Excel 2007
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Linda" wrote in message
...





All times are GMT +1. The time now is 08:10 PM.

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