Print a selection of cells in an Excel worksheet

Applies to
Microsoft Excel 2002

If you are working with large amounts of data, you may want to share just a portion of it—for example, only certain cells or groups of cells from a worksheet.

  1. Select the cell or range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells you want to print.

ShowHow to select cells and ranges

To select Do this
A single cell Click the cell, or press the arrow keys to move to the cell.
A range of cells Click the first cell of the range, and then drag to the last cell.
A large range of cells Click the first cell in the range, and then hold down SHIFT and click the last cell in the range. You can scroll to make the last cell visible.
Nonadjacent (nonadjacent selection: A selection of two or more cells or ranges that don't touch each other. When plotting nonadjacent selections in a chart, make sure that the combined selections form a rectangular shape.) cells or cell ranges Select the first cell or range of cells, and then hold down CTRL and select the other cells or ranges.
  1. On the File menu, click Print.
  2. Under Print what, click Selection, and then click OK.

 Note   For information about additional print options, see the topics listed in the See Also list.