• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Selecting Cells

Whenever you click a cell or press Enter, Tab, or one of the arrow keys to move to a cell, you select the cell, and Excel displays a dark outline around the cell, called the selector. You typically select a single cell to type or edit an entry. Many times, however, you need to select multiple cells—a block or range of cells—perhaps to apply the same formatting to several cells or to total the values in multiple cells. The following sections show you how to select and work with cell ranges.

Selecting a Cell Range

A range consists of two or more cells on a sheet; the cells can be neighboring or nonneighboring. The only trick to selecting cells is making sure Excel is not in Edit mode; Excel does not allow you to select cells when you’re in the middle of typing or editing an entry. If you are typing or editing an entry, click another cell to exit Edit mode. Then perform one of the following steps to select a range:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint