Sunday, June 12, 2011

How to View Two Excel 2007 Spreadsheets on Separate Screens


Excel's 'Side-by-Side' View
1. Open the first Microsoft Excel 2007 file with which you want to work.
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.
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.
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)
5. Open the first Excel 2007 file which you want to view. Click the 'Maximize' button in the top-right corner of the Excel screen.
6. 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.
7. 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.

Blogger news