ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can we see two different excel sheets on one screen? (https://www.excelbanter.com/excel-worksheet-functions/44475-how-can-we-see-two-different-excel-sheets-one-screen.html)

Lisa

How can we see two different excel sheets on one screen?
 
I have two worksheets im working on but dont want to get incorrect data from
switching back and forth is there a way to display both on my screen.


David Billigmeier

Just tile your windows (un-maximize both and make each half screen width)
--
Regards,
Dave


"Lisa" wrote:

I have two worksheets im working on but dont want to get incorrect data from
switching back and forth is there a way to display both on my screen.


MetricsShiva

when you have both files open,
Go to Window, and click "compare side by side with..".

this also gives you the option to scroll simultaneously in both windows... I
think a new toolbar appears with an icon to disable or enable the scrolling
function.


"Lisa" wrote:

I have two worksheets im working on but dont want to get incorrect data from
switching back and forth is there a way to display both on my screen.



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

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