Selecting Cells

In order to copy, move, or delete the data in several cells at one time, you must select those cells first. Then you can perform the appropriate action.

  • To select a single cell, click it.

  • To select adjacent cells (a range), click the upper-left cell in the group and drag down to the lower-right cell to select additional cells. (If you want more help in selecting ranges of various sizes, see Lesson 10.)

  • To select nonadjacent cells, press and hold the Ctrl key as you click individual cells.

  • To select an entire row or column of cells, click the row or column header.

  • To select adjacent rows or columns, drag over their headers.

  • To select nonadjacent rows or columns, press Ctrl and click the headers for those you want to select.

Range

Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.