Selecting Rows, Columns, and Special Ranges

In addition to selecting a range of contiguous and non-contiguous cells in a single worksheet, 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 different 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 ...

Get Excel® 2013 On Demand 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.