How to View Two Excel 2007 Spreadsheets on Separate Screens

By Matthew Schieltz

Microsoft Excel 2007 offers calculation tools, graphing and charting tools and many other features to list, organize, sort and analyze data. Viewing two Excel spreadsheets separately--instead of flipping back and forth between documents--makes it easier to compare two charts, graphs or some other data sets that need to be evaluated against each other. Fortunately, Excel 2007 comes with a built-in feature to make this happen, but Windows users have additional options for organizing spreadsheets onto different screens as well.

Things You'll Need

  • Excel 2007

Excel's "Side-by-Side" View

Step 1

Open the first Microsoft Excel 2007 file with which you want to work.

Step 2

Open a second instance of Excel 2007. Go to the "Start" menu in the lower left-hand corner of the computer desktop, choose the "All Programs" list and click on Microsoft Office Excel 2007. Click the "Office" button in the program, select "Open," and double-click on the second file that you want to open and view.

Step 3

Click the "View" Ribbon in Excel 2007. Click the "View Side by Side" option in the "Window" group to view the spreadsheets stacked vertically side-by-side. Click the "Synchronous Scrolling" button in the "Window" group to control the scrollbar separately for each spreadsheet file. Click the "Full Screen" option in the "Workbook Views" group to expand the viewing area. Right-click anywhere on the screen and choose "Close Full Screen" to close this view.

Step 4

Click "Save Workspace" in the "Window" group from the "View" Ribbon. Type a name for the file and a directory location and click "Save." Re-opening this file saves the side-by-side view of the two files.

Split Screen Option (Windows 7)

Step 1

Open the first Excel 2007 file which you want to view. Click the "Maximize" button in the top-right corner of the Excel screen.

Step 2

Open the second Excel 2007 file you want to view in a new instance of the Excel program. To open a new instance of the program, either click the Excel application from the "All Programs" list within the "Start" menu or right-click the Excel 2007 shortcut on your computer desktop or Taskbar and choose "Microsoft Office Excel 2007." In the new instance of the program, open the second file you want to view. Click the "Maximize" button in the program to maximize the file's view.

Step 3

View the files in split screen mode. With the second Excel 2007 file open, maximized and selected, press first the Windows logo key in the lower left corner of the keyboard. Hold the Windows logo key down and then press the "right" arrow key to shift the file to the right side of the screen. Click once on the first Excel 2007 file to select it. Repeat the process of holding the Windows logo and the "left" arrow keyboard keys to place the file on the left side of the screen.

Tips & Warnings

  • Windows Vista and XP users can manually create a "split screen" if two instances of Excel are open by dragging and resizing the Excel windows using the re-size arrows around the edge of the program.