Compare Worksheets Side By Side In Excel 2007

Excel 2007 lets you view two worksheets side by side, as opposed to flipping between them. This is especially helpful when you need to compare two worksheets because you view them both on your desktop at once.

To compare two worksheets side by side in Excel 2007:

  1. On the View tab, within the Window group, click New Window.
  2. On the View tab, within the Windows group, click View Side by Side.
  3. In the Compare Side by Side dialog box, click the worksheets that you want to compare.
  4. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.
Article Written by

  • Anonymous

    Every time I see someone at a conference using an ipad with a bluetooth keyboard I want to slap them. Seriously just bring a fricking laptop. I could give you about 30 more reasons but yeah you nailed my #1 reason right on the head.

    • Chris Pirillo

      Actually, an iPad with a bluetooth keyboard is still infinitely lighter than the average notebook (or even netbook) computer.

      • Anonymous

        Which would be a real problem solver if I found 4lbs to be difficult to carry. Lets assume I don’t want to lug around a bag but just carry the item in the bag. with the ipad I’d be forced to carry 2 items. with a laptop only 1. Don’t get me wrong. I have a tablet for my couch. Good for flicking through emails and twitter and such while watching tv. But if I need to do anything productive Im pretty much always going to opt for something with a keyboard… and if Im going to go that far.. I’ll go with something that also has a mouse 😉

  • Shawn Amyotte

    I treat mine as a newspaper, I bring it with me when I’m just heading out for drinks or a quick bite and want to keep in touch with the world. The price was a little steep, but Apple is in the business of making money. They’re quite arrogant about it but the alternative is buy one of their competitors “tablets” *laugh*

  • Anonymous

    According to what I read at UBS Amazon will make a $50 profit from each sale of a Kindle Fire as manufacturing costs are about $150.

  • Justin Doak

    I agree fully. I purchased a refurbished 1st gen iPad for a nice price when the iPad 2 came out, and as a college student, use it daily. It is a great tool for accessing all of my school-related files, taking notes, staying connected to others, etc. without lugging around my 5 pound MacBook as I used to do daily. While I have successfully done some creating of content, such as writing papers, on the iPad, I realize it isn’t a replacement for my full-powered computer, but rather an incredibly capable and useful complement. I have never expected my iPad to replace my laptop, but by the same token, have never regretted the purchase. I love my iPad for what it does and see plenty of room for both it and my MacBook as productivity tools in my life.

  • Tom Marly

    “Not anyone’s fault. This is simply how the iPad is designed.” Chris says that, so obviously he sees that the iPad isn’t designed to function as a full netbook. he just is saying that what the iPad CAN do isn’t as useful as a netbook.