Lists in MS Excel are tables, whose rows contain homogeneous information. The rows of a table are called records, and the columns are called fields of records. Each column is assigned a unique field name, which is entered in the first row of the list — the header row.
As a rule, when working with lists you encounter the following ranges:
- Data range — the area where the list data is stored. Related data is written in separate rows, and each column corresponds to its own list field with a unique field name.
- Criteria range — an area on the worksheet where criteria for searching information are specified. In the criteria range, the field names are indicated, and space is allocated for entering selection conditions.
- Extract range — the area into which MS Excel copies the selected data from the list. This range may be located on the same sheet as the list, or on another sheet of the workbook.
Records – Fields – Header Row
Entering data into a list is done, for example, directly into the worksheet cells (i.e., into the empty rows below the header), or by using a data form. To do this, click the list button on the Quick Access Toolbar and choose More Commands. Then, in the Excel Options window, select Quick Access Toolbar on the left, and on the right, in the Choose commands from list, select All Commands. Find the Form command in the list below and add it to the Quick Access Toolbar.
As mentioned earlier, with data placed in a list you can perform: sorting, data filtering, and data analysis.