SECTION 1
Lesson 1.5: Explore your Workbook

   

 

 

A single Excel 2003 worksheet can contain 65,536 rows and 256 columns. This means that there can be as many as 65,536 x 256 = 16,777,216 cells in a worksheet. This poses a problem for viewing large worksheets. How can you possibly get a big picture of your work if it is spread over a large number of cells?

 

By using Excel’s Zoom feature, you can change the viewing scale of a work sheet.

 

 

This is an image of a worksheet at 100 % zoom.

 

 

This is an image of the same worksheet at 75% zoom. Notice that you can now view much more of the worksheet area.

 

To see a bigger picture of a work sheet (more worksheet area), you will want to zoom out by clicking the down pointing triangle by the zoom text field on the standard tool bar.

 

 

You can then choose a viewing scale from the drop down list (The smaller the scale, the more worksheet area you will see).

 

You can also left click in the zoom text field, and enter a viewing scale directly. Pressing the Enter key will zoom the grid area in or out according to the value you entered.

 

To see cells at a close, detailed view, use larger zoom values. To see a larger number of cells, at less detail, use a smaller value.