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

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.

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

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bob Grabbe" <Bob wrote in message
...
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.

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

Thanks, I found this in Excel 2007 also.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bob Grabbe" <Bob wrote in message
...
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.