Excel: Splitting a window and how to view two separate worksheets in the same file at the same time


I appreciate the split screen feature in Excel. It works especially well for very long worksheet where I need to keep the top visible while scrolling down the page.

Very easy way to enable the split:

  1. Hover the mouse over the top end of the scroll bars until the cursor changes into two vertical arrows
    SS-2010.06.24-07.55.15
  2. Drag down to split the screen.
    SS-2010.06.24-07.56.30
  3. To remove the split, simply drag the line back up to the top.
  4. You can also split the screen horizontally using the same method.

Now, what if you need to work on one worksheet while viewing another in the same workbook? The solution is not so obvious.

Here’s how:

  1. Go to View -> New Window in the ribbon
    SS-2010.06.24-08.00.35
  2. Now you will have two copies of the same file open.
  3. To view both at the same time, you can tile them. In the View tab, click “Arrange All”
    SS-2010.06.24-08.02.03
  4. Choose how you would like to tile the windows.

Here are two windows tiled using the “vertical” option. Notice that the title bar for each file identifies the window:

SS-2010.06.24-08.04.23 

Now, when you make changes to either of the windows, the other window will be updated. In other words, you are not opening a separate copy of the file, just a new view.

Advertisements
  1. #1 by Accountant on October 28, 2011 - 9:14 am

    Most people would rather have a SEPARATE Excel window open so a side to side comparison can be made instead of having 1 Excel window with 2 files opened, showing side to side!

    THIS is the problem with Excel 2007 & esp 2010!

    IF a person has a relatively SMALL LCD monitor, what good is it having 1 Excel window with more than 1 file open in the SAME window?

    Always better to have 2 or more Excel windows open so you can compare information esp if you have a dual monitor system than a Single Excel window with multiple Tiled files opened!!

    Any suggestions on how to FIX this darn problem? MANY users have posted this darn issue on several online forums!

  2. #2 by mainan anak-anak on June 29, 2012 - 2:53 pm

    Thank you for this article. I will also like to convey that it can often
    be hard when you are in school and starting out to create a long credit score.
    There are many students who are simply trying to endure and have a protracted or favourable credit history can often
    be a difficult factor to have.

  3. #3 by precept ladies golf balls on July 2, 2012 - 7:09 pm

    Hello. remarkable job. I did not anticipate this.
    This is a great story. Thanks!

  4. #4 by outdoor swings on July 2, 2012 - 9:24 pm

    Hello would you mind letting me know which webhost you’re working with? I’ve loaded your blog in 3 different internet browsers and I must say this blog loads a lot faster then most. Can you suggest a good web hosting provider at a reasonable price? Thanks a lot, I appreciate it!

  5. #5 by Roman on September 1, 2012 - 2:03 pm

    Hi there to all, for the reason that I am in
    fact eager of reading this webpage’s post to be updated daily. It consists of fastidious stuff.

  6. #6 by Etsuko on March 1, 2013 - 6:19 pm

    Hello there! This is kind of off topic but I need some guidance from an established blog.
    Is it hard to set up your own blog? I’m not very techincal but I can figure things out pretty fast. I’m thinking about setting up my own but I’m not sure where to start. Do you have any points or suggestions? Thanks

  7. #7 by Monique on March 22, 2013 - 8:39 pm

    I have seen plenty of useful issues on your site
    about personal computers. However, I have the view that netbooks are still not quite powerful more than enough to be a option if you normally do tasks that require plenty of power,
    just like video croping and editing. But for internet surfing, microsoft word processing, and
    majority of other prevalent computer functions they are fine,
    provided you cannot mind the small screen size.
    Many thanks sharing your notions.

  8. #8 by how to increase youtube views on July 26, 2013 - 1:59 pm

    Do you have a spam issue on this website; I also am a
    blogger, and I was wondering your situation; we have developed some nice procedures and we are looking to exchange
    techniques with others, why not shoot me an email if interested.

  9. #9 by medialappi.net on August 2, 2013 - 7:44 am

    Initially they were more expensive than the inkjet printers however they later dropped in prices after one company started offering less expensive photo printers.
    Nevertheless, no one ever desires in order to pay full price for his or the lady printer ink,
    subsequently why not buy online where you could a bit more often than not discover printer ink coupons.
    It prints in extra of 7000 webpages every thirty days and we have only experienced just definitely one
    tiny issues with some rollers for the internal workings.

  10. #10 by Web Site on August 8, 2013 - 8:40 pm

    Online merchants provide year-long savings because
    it is simpler than to run a shop in the market-place to run
    a personal online shop that to some shop which offers you anything underneath the sun that can be bought.
    Also these online retailers like Overstock.com offer particular discount such
    as overstock promotion rule for promotional and advertising function.
    Although a traditional Overstock coupon is difficult to find but when you obtain it be
    sure to be dazzled.

    Overstock Coupon is of very good use, as it has increased the fad of on line shopping by many times among your brain of men and women.
    It has also many choosing things which increase its need.
    Several types of voucher requirements are there namely Money Saver Coupon Code,
    Free Ship Coupon Code and several more; all are employed for diverse reasons.

    Now these codes are being sold-out to do business.

    This can be also comfortable for your consumers since they are
    now free from the risk of marketing using a large amount of cash.
    Actually some recharge internet sites and internet sites have started the
    Overstock Coupon program. They offer systems like on a recharge of Rs.10 only one will get
    200-400 concession on looking for Rs 999 and above. By using
    these plans, even the internet sites are extending their sales.
    Many shopping web sites have set a border such that shopping beyond
    that certain amount could bear no shipping charge. Online coupons are actually available to even reduce the
    delivery cost.

  11. #11 by Real YouTube Views on December 11, 2013 - 7:51 am

    Excellent post. I was checking constantly this weblog and I’m impressed!

    Extremely helpful information specially the ultimate section 🙂
    I deal with such information a lot. I used to be seeking this
    particular information for a very lengthy time.
    Thank you and good luck.

  12. #12 by dominios on January 16, 2014 - 7:10 am

    Hi! This is my 1st comment here so I just wanted to give a quick shout out and tell you I genuinely enjoy reading through your
    posts. Can you recommend any other blogs/websites/forums that go over
    the same subjects? Thanks!

  13. #13 by buy youtube views on March 21, 2014 - 12:14 pm

    Very nice post. I just stumbled upon your blog and wijshed to sayy that I’ve really enjoyed
    browsing your blog posts. After all I’ll be subscribing to your feed and I hope you write agzin very soon!

  14. #14 by Workingperson coupon on July 4, 2014 - 6:34 am

    Hello, i think that i noticed you visited my website so
    i got here to go back the want?.I am trying to in finding things to improve my site!I guess its good enough to use some of your ideas!!

  15. #15 by free money claims on April 18, 2016 - 5:25 pm

    Hey terrific website! Does running a blog similar to this require
    a massive amount work? I’ve no expertise in programming however I
    had been hoping to start my own blog soon. Anyways, if you
    have any ideas or techniques for new blog owners please share.
    I know this is off subject however I just needed to ask.

    Thanks!

  1. fx demo account
  2. La Verdad de Monagas, LVDM, mayor circulación, noticias de venezuela, diario, diarios, periódico, periódicos, noticia, prensa, videocolumna, videocolumnas, video, videos, multimedia, infografía, infografías, audiogalería, audiogalerías, actualidad,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: