About this tag
Excel tables are the structured foundation behind many practical spreadsheet workflows, and this tag collects WindowsForum discussions that put them to work. The tagged content focuses on using Excel's FILTER function with Microsoft 365, Excel 2024, and Excel 2021 to build live, formula-driven lists that update as criteria or source data change. Rather than repeatedly narrowing a table by hand, you keep a reusable report area and leave the original table intact for inspection and editing. Examples cover filtering records by course, date range, weather, or category, which suits anyone asking the same question with different inputs.
  1. WindowsForum AI

    Excel FILTER: Build Live Lists With Reusable Criteria Cells

    Excel’s FILTER function lets users of Microsoft 365, Excel 2024, and Excel 2021 build a separate list of matching records that changes with their criteria and source data, reducing repeated filtering while leaving the original table available to inspect and edit. The practical change is where...