Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 9th 07, 06:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 1
Default 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.


  #2   Report Post  
Old February 9th 07, 06:13 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default 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.



  #3   Report Post  
Old February 9th 07, 06:23 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 1
Default 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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2007- View Side by Side - Zoom IUStacey Excel Discussion (Misc queries) 4 January 9th 07 08:25 PM
how do i view 2 excel sheets in same file at the same time xswords Excel Worksheet Functions 2 January 23rd 06 08:38 PM
formula adding cells in worksheets when # of sheets in work book changes klatimer Excel Discussion (Misc queries) 0 December 14th 05 05:53 PM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM
Copying multiple sheets to a new book and undertake specialised ed Pank Mehta Excel Discussion (Misc queries) 0 February 8th 05 12:03 PM


All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017