View two Excel worksheets side-by-side

Switching back and forth between worksheets can make your eyes spin around in their sockets (a great party trick but something your optometrist would advise against). Keep those baby blues steady when you use Excel 2007:

  1. On the View tab, in the Window group, click New Window.
  2. On the View tab, in the Window 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.

— Crabby