At times you might have to view dif¬ferent worksheets of the same workbook simultaneously-this can be achieved by a small trick as soon below.
1.Open a single workbook.
2.Go to the View tab and choose NEiW Window under Window. Excel will open the same workbook in another new window.
3.Now, on the View Tab of the ribbon, click Arrange All in the window group and arrange both the windows to your liking.
4.In each window, select a different worksheet to view them together.




Reply With Quote
Bookmarks