drop-down

A single data list may contain records that fall into several categories or groups. Depending on the size of the data list, it may be difficult to focus on all of the records that belong to a specific group. Data filtering in MS Excel enables the ... user to work with a subset of data within the data list. When a filter is created, only the records that contain the values specified are displayed. Other records in the data list are hidden temporarily. AutoFilter is an automated filtering tool included in Excel. When AutoFilter is applied to a data list, the column headings change to drop-down list ... (view more)