Can you view 2 sheets within the same book side by side ?

G

Guest

In Excel 2007, I have a spreadsheet file that has more than one sheet in it.
I know that I can open two separate spreadsheet files and view them side by
side. What I want to do is have one excel file open with two sheets in it and
see the two sheets side by side for comparison. So far I can't find how to do
this, if it is possible.
 
B

Bernard Liengme

Excel 2007 is on another PC which is busy.
In Excel 2003 use Window | New Window and you get two views of the same
workbook; now open a different sheet in one of them. You can view them
side-by-side just as you can with different workbooks
The same must be possible in Excel2007
best wishes
 
G

Guest

Thanks, I found this in Excel 2007 also.

Bernard Liengme said:
Excel 2007 is on another PC which is busy.
In Excel 2003 use Window | New Window and you get two views of the same
workbook; now open a different sheet in one of them. You can view them
side-by-side just as you can with different workbooks
The same must be possible in Excel2007
best wishes
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turn on "View Side by Side" option 2
Sheets Side by Side 4
Viewing Two Sheets within One Workbook 2
View side by side 1
How do you turn on "view side by side"? 1
View workbooks side by side in Excel 2007 12
Excel 2007 "view side by Side" 10
Printing from side by side spread sheets 1

Top