Microsoft Office Tutorials and References
In Depth Information
Selecting Rows, Columns, and Special Ranges
To select more, repeat step 3 until all non-contiguous ranges are selected.
Selecting Rows, Columns, and Special Ranges
In addition to selecting a range of contiguous and non-contiguous cells in a single work-
sheet, you may need to select entire rows and columns, or even a range of cells across
multiple worksheets. Cells can contain many different types of data, such as comments,
constants, formulas, or conditional formats. Excel provides an easy way to locate these
and many other special types of cells with the Go To Special dialog box. For example, you
can select the Row Differences or Column Differences option to select cells that are dif-
ferent from other cells in a row or column, or select the Dependents option to select cells
with formulas that refer to the active cell.
Select Entire Rows or Columns
• To select a single row or column, click in the row or column heading, or select
any cell in the row or column, and press Shift+Spacebar.
• To select multiple adjacent rows or columns, drag in the row or column headings.
• To select multiple nonadjacent rows or columns, press Ctrl while you click the
borders for the rows or columns you want to include.
Search JabSto ::

Custom Search