» Viewing Selecting Data in a Sheet

To increase or reduce the selected data region to the size of the window:

1. Select a range of cells containing data.
2. From the View menu, select Zoom.
3. In the Zoom dialog box, select Fit Selection.
4. Click OK.

To increase the number of cells appearing in the window, hide window elements, such as sheet tabs, toolbars, the formula bar, and the status bar:

1. From the Tools menu, select Options, and then select the View tab.
2. Clear the checkboxes for Row & Column headers, Horizontal scroll bar, Vertical scroll bar, Sheet tabs, and then click OK.
3. Select View and deselect the Formula Bar and Status Bar checkboxes.
4. Select any one of the toolbars, right-click, and clear the checkboxes beside each of the displayed toolbars from the shortcut menu.