3 Tables, Sorting, and Filtering

Create and manage structured tables

A structured table is a rectangular set of related data. Each column is a field, such as Date or Region, and each row is one record, such as one sale. A suitable source range has one header row, no blank rows or columns inside the data, and one kind of information in each column.

For example, a sales table can have the fields Date, Region, Product, Units, and Sales. Its records might include a West-region Notebook sale on 2026-03-04 with 12 units and sales of 60; an East-region Pen sale on 2026-03-05 with 20 units and sales of 30; and a West-region Pen sale on 2026-03-06 with 15 units and sales of 22.50.

In Microsoft Excel, select a cell in the data, choose Home > Format as Table, select a style, confirm the range, and indicate whether the data has headers. Excel adds filter controls to the header row. Use clear, unique column names and consistent formats, such as storing dates as dates and sales amounts as numbers. Menu names may differ in other spreadsheet programs.

Tables can expand as records are added, helping keep table formatting and related formulas aligned. Excel assigns each table a name, and formulas can refer to named columns—for example, =SUM(Table1[Sales]) instead of fixed cell addresses. A table style affects visual formatting, not the underlying values.

Sort records while keeping them together

Sorting rearranges records into an order; it does not remove them. Text can be sorted alphabetically, numbers from smallest to largest, and dates from oldest to newest. In Excel, use a header dropdown for a quick sort or choose Data > Sort to set more detailed rules.

A multi-level sort can organize records by Region from A to Z and then by Sales from largest to smallest. The first level takes priority, and later levels break ties, so sales are ordered within each region.

Sort the entire table rather than a single column so each record’s values remain together. If Excel prompts you, choose to expand the selection. Sorting may make the original order difficult to recover; if that order matters, add an ID or sequence-number column before sorting.

Filter records by criteria

Filtering temporarily hides records that do not meet selected criteria; it does not delete them. Open a column’s filter dropdown and select values or conditions. For example, filter Region to show only West, then filter Sales to show amounts greater than 25. When filters are combined across columns, only rows that satisfy all active filters remain visible.

To see all records again, clear the individual criteria or turn off the filter. Check whether a filter is active when interpreting totals or copying results: hidden records remain in the table even though they are not displayed.

Highlight values with conditional formatting

Conditional formatting changes how cells look when they meet a rule. Select the relevant cells or column, choose Home > Conditional Formatting, and set a rule. For example, highlighting Sales values below 25 in amber can flag smaller transactions.

Data bars compare magnitudes visually, color scales show relative high-to-low values, and icon sets divide values into categories. Choose the range and rule carefully: a rule applied to one cell or an incomplete range may not cover existing or new records as intended. Conditional formatting emphasizes patterns but does not change the data itself; color alone should not be the only way to communicate important information.

Follow a reliable table workflow

Use this sequence to prepare and analyze a table:

1. Organize one record per row and one field per column, using descriptive headers.

2. Check for blank rows, inconsistent entries, and incorrect data types.

3. Convert the range to a structured table.

4. Sort or filter to answer a specific question, keeping complete records together.

5. Apply conditional formatting to make relevant values easier to spot.

6. Clear filters and verify the table before sharing it or using its results.

Structured tables organize records and provide features such as header filters and expanding data ranges. Sorting changes record order, filtering hides records that do not meet selected criteria, and conditional formatting highlights values according to rules. Use each tool deliberately, while keeping the underlying data complete and consistent.