Viewing Excel Worksheets Side-by-Side
September 21st, 2006
In Excel, you can work on two worksheets (from two different workbooks) by placing them in vertical, side-by-side windows. When you have two workbooks open at the same time, select Window, Compare Side by Side With. After you select this command, a floating Compare Side by Side toolbar will open in Excel. The toolbar includes the Close Side by Side button, which you can use to close the windows as soon as you’re done comparing or transferring data between the two. While the two workbook windows are in open in Excel, you can select different worksheets and scroll to different regions in either one by using its sheet tabs and scroll bars that appear at the edge of the window. To make workbook active, just click the title bar or one of the cells of its worksheets.
September 23rd, 2006 at 7:16 pm
Another way to compare Excel, Word and any other program in multiple windows is to use a great program called WinTiles that has been around for a few years…
www.WinTiles.com
September 24th, 2006 at 4:56 am
Great hint Shaman. Thanks!
Jon-Paul:
I have never seen Win-Tiles although the program appears to me to be just a shareware way to tile windows.
XP already does tiles pretty well already… Just right click on the task-bar and select your tiling options. If you only want to tile certain windows… then just hold CTRL, then select the windows you want to tile, and then select your tile options.
Here is the recipe on the tile of windows:
http://www.tech-recipes.com/windows_tips830.html
September 25th, 2006 at 9:35 am
Hi,
Is there a way to view side by side 2 worksheets that are located in the same workbook?
Thanks,
Mickey
September 25th, 2006 at 11:40 am
[…] Viewing Excel Worksheets Side-by-Side - Digital Streets […]
September 25th, 2006 at 1:07 pm
Mickey,
With your workbook open, just select Window, New Window. This will create a second window of the current workbook. Then you can arrange them horizontally/vertically and select individual sheets in each window.
September 25th, 2006 at 1:10 pm
Oh how I needed this tip! Thank you so much!
September 26th, 2006 at 4:51 am
Hello,
If you have two monitors, like I do, you can go to
Tools > Options
Select the “General” tab and place a check mark at “Ignore other Applications”.
You will be able to open Excel files in multiple windows (like Word.
November 8th, 2006 at 12:00 pm
Francois,
Thats what I needed.
Thanks so much.
January 30th, 2007 at 11:07 am
When I check “ignore other applications” under tools > options > general, I can view an excel file on each of my two monitors. However, now when I try to open up an excel file through window explorer, just a blank excel file is loaded. The program no longer automatically opens the file I’ve selected. Is there a fix to view excel on two monitors and allow opening thorugh the window explorer?
Thanks.
February 21st, 2007 at 6:59 am
[…] enjoy >> No Comments so far Leave a comment RSS feed for comments on this post. TrackBack URI Leave a comment Line and paragraph breaks automatic, e-mail address never displayed, HTMLallowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> […]
May 30th, 2007 at 1:42 am
Thanks Nick.
That really made my day too! Comparing Excel sheets side by side, simply by choosing “new Window” was a too obvious solution for me to spot. It is in HELP under “View multiple sheets or workbooks at the same time ” , but for some reason that did not come up when i looked for it.
Nick Burns Says:
September 25th, 2006 at 1:07 pm
Mickey,
With your workbook open, just select Window, New Window. This will create a second window of the current workbook. Then you can arrange them horizontally/vertically and select individual sheets in each window.
mroonie Says:
September 25th, 2006 at 1:10 pm
Oh how I needed this tip! Thank you so much!
August 3rd, 2007 at 3:49 am
Hi
I have a bit of a problem , and you guys seem like you know what you are talking about when it comets to Excel. I would like to share a file which has excel on it. This Excel doc is my master. My friend would like to access this excel master and edit it. ie. work one the same excel document at the sametime on 2 different computers. Im sure that this is possible or there is a 3rd software that i have to purchase for this application.
Please get back to me a.s.a.p
Thank you so much
Monique
October 15th, 2007 at 7:11 am
It might be late. Still somebody might be able to use it. You can share the excel sheets. Tools and then share workbook. There are some limitations, but as long as to work it will work just fine.
February 18th, 2008 at 9:50 am
I don’t exercise at all. If God meant for us to touch our toes, he would have put them further up on our body.
February 28th, 2008 at 8:05 am
Ha ha! I was actually searching for food recipes but was brought to your blog. Funny thing is I use excell and I found your tip really helpful!! LOL
Thanks!
March 4th, 2008 at 12:21 pm
For those who have Excel for Mac 2004 - Windows > Arrange… > then select how you want them arranged.
March 10th, 2008 at 4:37 am
i am working with undp ACTED organization of relief
and aid to afghanistan really ia ma getting much
benefit sheets formulas from this site
i really appreciated this site
thanks
March 11th, 2008 at 12:41 am
Thats what I needed. Thanks for the idea.
March 27th, 2008 at 8:17 am
Thank you for information.
April 9th, 2008 at 8:03 pm
Oh yes! Wow! This is exactly what I needed! Thanks Nick. It did seemed too obvious. But I guess simplicity is always the best solution…
April 21st, 2008 at 8:07 am
Very useful information for me. Thanks.
April 30th, 2008 at 6:21 am
I’m trying to view unique floating windows of excel files, not within the same frame. Can someone help with this?
May 14th, 2008 at 4:54 am
thanks you it is very nice and using http://www.prefabrik.tv usefully and i am happy.
June 5th, 2008 at 1:58 pm
thank you francois! that resolved my dual monitor setup issue. i can now see side by side. Roger, do the same thing.
June 30th, 2008 at 4:56 am
Oh how I needed this tip! Thank you so much!hekimboard is very nice..