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

Selecting Columns and Rows

Selecting a range requires highlighting a block of cells. You can drag to select all the entries in a column or row, but in many cases it's more efficient to select the entire row (all 256 cells) or column (all 65,536 cells), whether you're using the entire range of cells or not. To drag through an entire row or column could take several minutes, just to scroll to the ends of the worksheet. It's much easier to click the column letter or row number for the desired column or row, as shown in Figure 3.3.

Figure 3.3. Click the column letter to select all 65,536 cells in the column.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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