Managing data ranges

Learn how to sort data in a sheet or range and reference data that is on a different sheet.

A range can be a single cell, a rectangular block of adjoining cells, an entire sheet, or an entire spreadsheet. A range is represented as the addresses of its beginning and ending cells, separated by two periods. For example, A1:B4.

The following procedures help you manage your data.