Viewing two excel sheet in one screen.

[ramki]

Hi,

I have to compare and correlation two data's from two different excel sheet. How to View Two different excel sheet in a single Screen. So that it is easy for me to compare. Please Help!. Thanks in advance.

[mudraker]

If both sheets are in the same workbook I do not think you can display them at the same time in the 1 Excel program


Ways around it are:-

Method 1
Copy 1 sheet to a 2nd workbook & have both books open
Adjust size of window for each book to suit

Method 2
Open Excel
Open workbook
Open a 2nd copy of Excel
Open same workbook (as readonly)
Adjust size of each program window to suit

[SEOT]

I do this all the time. Just use the arrange option under one of the menu drop downs, and you can see two excel workbooks at once. It is very easy to do.

[shg]

Assuming they are two different workbooks (not two sheets in the same workbook) and you're using Excel 2003 or 2007, there is a Compare side-by-side arrangement that scrolls the workbooks synchronously.

[taylorm]

You can view multiple tabs of a single worksheet at the same time.

From the "Window" menu option, select "New Window". Then you can arrange to view these multiple windows just as you would arrange multiple workbooks.