Quick links

• The Chancellor
• The Provost
• Senior Staff
• Support Units/Staff
• Organizational Structure
• Resources

Mrak Hall
University of California, Davis
One Shields Avenue
Davis, CA 95616
Map

(530) 752-2065
(530) 752-2400 fax

UC Davis home > Offices of the Chancellor and Provost > Q&A

Excel 2003: Viewing Spreadsheets

By utilizing some the views listed below, you can enter and edit data on several worksheets simultaneously and perform calculations based on data from more than one worksheet.

Views
Compare Spreadsheets Side by Side
View Multiple Sheets or Spreadsheets at the Same Time
Splitting Panes
Freezing Panes

Compare Spreadsheets Side by Side

1. Open the spreadsheets you want to compare side by side
2. On the Window menu, click Compare Side by Side with (name of the other spreadsheet)

To remove this view, click Close Side by Side on the Window menu.

View Multiple Sheets or Spreadsheets at the Same Time

1. Open the first spreadsheet you want to view
2. In the same Excel session, click File then Open to open the additional spreadsheets
3. On the Window menu, verify that all the spreadsheets you want to view are listed in the open file section. If not, ensure that the spreadsheets were open using the same session



4. While on the Window menu, click Arrange
5. Under Arrange, click the view option you want and then OK.

   

   To view sheets in only the active workbook, select the Windows of active workbook check box.

To restore a spreadsheet window to full size, click Maximize at the upper-right corner of the spreadsheet window.

Freeze or Lock Rows and Columns

You can view two areas of a worksheet and lock rows or columns in one area by splitting or freezing panes (pane: A portion of the document window bounded by and separated from other portions by vertical or horizontal bars.).

Splitting Panes

When you split panes, you'll be able to scroll in both areas of the worksheet, while rows or columns in the non-scrolled area remain visible.

1. To lock rows, select the row below where you want the split to appear. To lock columns, select the column to the right of where you want the split to appear. To lock both rows and columns, click the cell below and to the right of where you want the split to appear
2. On the Window menu, click Split. For a quick way to split panes, point to the split box at the top of the vertical scroll bar or at the right end of the horizontal scroll bar.

To restore a window that has been split into two scrollable areas, double-click any part of the split bar that divides the panes or click Window then Remove Split.

Freezing Panes

When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.

1. To lock rows, select the row below where you want the split to appear. To lock columns, select the column to the right of where you want the split to appear. To lock both rows and columns, click the cell below and to the right of where you want the split to appear
2. On the Window menu, click Freeze Panes

To unfreeze panes, click Unfreeze Panes on the Window menu.