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..
July 15th, 2008 at 7:20 pm
Excel 2007 is pathetic. You can have two windows open inside the Excel workspace, but not in Windows. The workbooks appear separately on the taskbar, but they’re not separate windows. What if I want to look at the figures from two workbooks while entering data into a database? I’ve been able to do that for years, and now they’ve killed that basic usability feature. Vista sucks, IE7 sucks, Office 2007 sucks…. whoever makes the UI decisions at Microsoft is driving the company into the ground.
July 18th, 2008 at 6:31 am
thanks you it is very nice ..
July 26th, 2008 at 8:32 am
thanks you it is very nice.
August 4th, 2008 at 5:28 am
[…] 100% Secure, Full Encryption Is Being Used AFFILIATES CONTACT Sites you may be interested in Viewing Excel Worksheets Side-by-Side — Digital StreetsRight-clicking with a one-button mouse? | ATMac LiveWriter OnScreen - Windows Live Writer […]
September 9th, 2008 at 9:48 am
This is great if you want to view worksheets at the top and bottom of the screen, which isn’t side-by-side. How do I view them side-by-aside?
September 16th, 2008 at 12:24 pm
Anyone know how you can view microsoft excel tabs like vertically and horizontally. Or is it possible to view the sheets tab in sought of a table like instead of just having the horizontal scroll bar.
October 4th, 2008 at 1:07 am
Great post about Viewing Excel Worksheets Side-by-Side. 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.
October 10th, 2008 at 8:20 am
thanks a lot.
October 14th, 2008 at 7:23 am
New window option is awesome! Everyone who suggested this has saved me quite a bit of a headache! Thanks!!!
October 19th, 2008 at 11:50 am
Oh how I needed this tip! Thank you so much!hekimboard is very nice..
October 22nd, 2008 at 5:41 pm
What about tag pages? I’m finding that alot of my traffic is coming from tag pages. I didn’t see any settings for true/false with regard to tag pages. Thx.
October 29th, 2008 at 8:54 pm
Matt is right.
The biggest annoyance I have with Excel 2007 is the inability to have two separate windows open for the same workbook. Many people these days have two monitors, so why cant I have one tab open in a window on one monitor and another tab from the same book open on the other monitor ?
I know you can drag one window across two monitors and have two views (subwindows) open within that same big window but this works very poorly unless both monitors are the same size and have the same resolution. Even then, switching between the views/subwindows does not work well at all.
The suggested feature should be a very easy tweak for Microsft to do. In Word the feature already exists. If you open two views of the same Word document each view appears in a separate window that can be resized according to each monitor
Damo
November 1st, 2008 at 8:17 am
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.
November 11th, 2008 at 6:06 am
Brilliant….The day fruits became inhabitable……The morning the coconut became architecture…. A wooden fruit made of wood hanging in a tree…..it cannot be more birdy…..
I am all tears.
November 11th, 2008 at 11:21 am
is there any downside to increasing the max users for mysql database? thanks for this article.
November 11th, 2008 at 8:13 pm
it’s not all bad news - some things apparently went right with Wordpress 2.3. This isn’t the first scandal to rock Wordpress. It was previously found that
November 13th, 2008 at 11:45 am
Like the others, I’m so grateful for that New Windows tip. Now for the stoopid question; how do I now remove the addition windows I’ve created? Although I’ve saved, closed and re-opened my Workbook, all additional windows appear under the Window menu and to be honest I’d prefer just the one at present. I’m using Office 2003 by the way. THX!
November 13th, 2008 at 12:25 pm
HOLD EVERYTHING! Just found that if I click the ‘X’ in the window(s) I do not want to keep (so NOT the huge Red Excel ‘X’) and then Save the file, I’m left with just the single windows worksheet. Sorry for wasting your time. Cheers.
November 23rd, 2008 at 8:16 pm
For those of you thinking that if they implement this it will eliminate some of the waiting and lines…
November 24th, 2008 at 9:25 am
Very helpful tip about excel worksheet.
November 24th, 2008 at 9:28 am
My only real problem with google analytics is that it doesn’t work very well with a lot of ASP pages, which a lot of clients use nowadays. It can also get kind of hairy when trying to get it to understand what a conversion is. Instead of just any click, it needs to be one specific click haha.
November 26th, 2008 at 7:01 am
windows XP can do 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, and then select the windows you want to tile, and then select your tile options.
November 26th, 2008 at 7:38 pm
thanks a lot..!
November 29th, 2008 at 2:20 am
thank you very much
December 6th, 2008 at 7:32 am
thanks a lot.
December 6th, 2008 at 7:35 am
thanks
December 6th, 2008 at 7:36 am
thank you.
December 11th, 2008 at 5:55 pm
You’ve got a lot of cool posts here. Really like it. It served to be helpful. Thanks on that. meme estetiği
December 12th, 2008 at 1:34 am
thank you very much
December 14th, 2008 at 5:49 pm
I’ve noticed that the liberal media and GW proponents are cooling it on using the words “global warming.” The words of choice are now “global climate change.” Can you say, CYA?!
December 15th, 2008 at 10:24 am
These are great tips. Thank you so much!
I have a question to add though. It’s about opening .PNG files that’s hyperlinked in excel. My default program for opening .PNG files is Windows Picture and Fax Viewer. It works perfectly when I open a .PNG file in a file folder. When I click on the hyper link in excel, the .PNG file opens up in IE7. Anyone know how to change this? I’d like the hyperlink to open the picture in Windows Picture and Fax Viewer because I can use the arrow button to scroll to the next file. I am using Office 2003. Hyper link is done with a formula: =hyperlink(”filename.PNG”,filename)
Thank you in advance.
December 17th, 2008 at 4:24 am
thank you
January 1st, 2009 at 1:15 am
Still somebody might be able to use it. You can share the excel sheets. Tools and then share workbook. Burun estetiği Saç Ekimi
January 7th, 2009 at 3:50 pm
thank you very much
January 18th, 2009 at 12:51 pm
Are there any issues with this in that version.
Great plugin. Thanks!
January 23rd, 2009 at 3:22 pm
thanks
January 28th, 2009 at 4:01 am
thanks
January 28th, 2009 at 4:03 am
thanks you
January 28th, 2009 at 9:09 am
nice post!
February 4th, 2009 at 3:46 am
thank you very much
February 5th, 2009 at 8:33 am
quality
February 5th, 2009 at 8:34 am
good post!
February 11th, 2009 at 2:18 am
thanks
February 12th, 2009 at 12:31 pm
Thanks
February 12th, 2009 at 12:33 pm
THANK YOU
February 12th, 2009 at 12:34 pm
tahnk you very much
February 15th, 2009 at 12:33 pm
sikiş izle video thanks lot
February 16th, 2009 at 7:53 am
thanks a lot!
February 17th, 2009 at 7:34 am
Thank you very nice blog I like it Estetik
February 17th, 2009 at 7:36 am
Thank you very nice blog I like it Kombi Kombi Servisi
February 17th, 2009 at 7:38 am
Thank you very nice blog I like it Burun Burun Estetiği
February 18th, 2009 at 10:32 am
a very good job sharing your health ..
I wish you continued success ..
thank you ..
February 19th, 2009 at 5:17 am
Karın germe estetiği ve karın germe AmeliyatlarıKarın Germe Güzelliği ertelemeyin
February 25th, 2009 at 5:54 am
sikiş
March 4th, 2009 at 8:43 am
thank you informationThank you very nice blog I like it EstetikBurun Estetiği a href=”http://dr-fatihdagdelen.com” rel=”nofollow”>Göğüs Estetiği
March 5th, 2009 at 2:46 am
Great information! Very useful for me. Thanks a lot.
March 5th, 2009 at 2:48 am
The idea is awesome. Congrats.thank you very much very nice article
March 9th, 2009 at 3:26 am
video
March 11th, 2009 at 8:58 am
thank you very good
March 19th, 2009 at 3:33 pm
With your workbook open, just select Window, New Window. This will create a second window of the current workbook. sikiş Then you can arrange them horizontally/vertically and select individual sheets in each window.
March 29th, 2009 at 4:32 am
PNG files that’s hyperlinked in excel. My default program for opening .PNG files is Windows Picture and Fax Viewer. It works perfectly when I open a .PNG file in a file folder. When I click on the hyper link in excel, the .PNG file opens up in IE7. Anyone know how to change this? I’d like the hyperlink to open the picture in Windows Picture and Fax Viewer because I can use the arrow button to scroll to the next file. I am using Office 2003. Hyper link is done with a formula: =hyperlink(”filename.PNG”,filename)
March 31st, 2009 at 1:00 pm
Viewing Excel Worksheets Side-by-Side — Digital Streets great artice thankyou
..
April 3rd, 2009 at 4:12 am
Viewing Excel Worksheets Side-by-Side — Digital Streets great article thank you.
April 12th, 2009 at 12:37 pm
htanks verygood sıcak videolar izle
April 14th, 2009 at 1:26 am
Thanks for this great tip, it was useful for me
April 18th, 2009 at 3:41 am
thank you
April 18th, 2009 at 3:43 pm
thank you
April 26th, 2009 at 6:53 am
Viewing Excel Worksheets Side-by-Side — Digital Streets great article thank you.
April 29th, 2009 at 1:53 pm
Viewing Excel Worksheets Side-by-Side — Digital Streets great article thank you.
April 29th, 2009 at 2:38 pm
good stlye
April 29th, 2009 at 2:39 pm
goods
April 29th, 2009 at 2:42 pm
goddds
April 30th, 2009 at 12:30 pm
Viewing Excel Worksheets Side-by-Side — Digital Streets great article thank you.
April 30th, 2009 at 2:03 pm
Viewing Excel Worksheets Side-by-Side — Digital Streetsvery good great article thank you.
May 1st, 2009 at 5:01 am
great article thank you.
May 1st, 2009 at 6:50 am
thank you corç
May 2nd, 2009 at 12:54 am
Viewing Excel Worksheets Side-by-Side — Digital Streets great article thank you.
May 2nd, 2009 at 8:45 am
Viewing Excel Worksheets Side-by-Side — Digital Streets great article thank you.
May 15th, 2009 at 7:43 am
nice post! thanks
June 8th, 2009 at 7:00 am
thanks
June 16th, 2009 at 1:47 am
Very interesting information! Thanks!
June 16th, 2009 at 4:11 am
thank youu
June 16th, 2009 at 4:12 am
thank youu
July 3rd, 2009 at 8:58 am
thanks