Filter a table by its in-cell checkboxes to show only checked or unchecked records, then freeze the header row so column names stay visible while you scroll. This setup is useful for task lists, inventory, approvals, and other tables where a checkbox marks a record’s status. The steps below apply to Excel for Microsoft 365 on Windows; checkbox cells contain TRUE when checked and FALSE when unchecked, which makes them filterable like other values.
Prerequisites
- Software: Excel for Microsoft 365 for Windows, with a worksheet containing a table.
- Data: A table with one checkbox column and a single header row.
- Estimated time: About 5–10 minutes, depending on whether the table is already set up.
- Difficulty: Easy.
Microsoft documents the in-cell checkbox feature for Excel for Microsoft 365 and Excel for Microsoft 365 for Mac. Menu labels and availability can differ in other Excel versions.
Step 1: Check that the records are in an Excel table
Click a cell in your data. If the ribbon shows a Table Design tab, the data is already a table. Otherwise, select the full data range, including its header row, and choose Insert > Table. Confirm My table has headers if the first row contains column names. Give each column a clear, unique name, such as Task, Owner, and Done.
Tables provide filter menus in their header row. Microsoft notes that turning off the table’s Header Row also turns off AutoFilter and removes applied filters, so leave that option enabled.
Step 2: Add or confirm the checkbox column
Use a column with a descriptive header such as Done or Approved. To insert in-cell checkboxes in a supported Microsoft 365 version, select the cells in that table column and choose Insert > Checkbox. Click each box to set its state. A checked box represents TRUE; an unchecked box represents FALSE. These are the underlying cell values, even when the cells display boxes rather than the words.
Step 3: Filter the table to the checkbox state you need
Select the filter arrow in the checkbox column’s table header. In the value list, clear (Select All), select TRUE to show checked items, or select FALSE to show unchecked items, and apply the filter. The table hides entire rows that do not match the chosen value. For example, filtering Done to TRUE shows completed tasks; choosing FALSE shows tasks that still need attention.
If both states are needed in a review, select both values. To restore every record, reopen the menu and select (Select All) or use the table’s clear-filter option.
Step 4: Freeze the row containing the table headers
Before freezing, make sure the table’s header is on worksheet row 1. If the worksheet has title rows or notes above the table, freezing the top row would keep those rows visible instead. Move the table or adjust the worksheet so its header is at the top if you want the simplest setup. Then choose View > Freeze Panes > Freeze Top Row. This locks worksheet row 1 in place as you scroll down.
Step 5: Confirm filtering and scrolling work together
Scroll down through the filtered results. The first worksheet row should remain visible while matching records move beneath it. Check that the filter arrow remains in the table header and that the checkbox state you selected is still indicated. Filtering changes which rows are shown; freezing panes controls which worksheet rows remain on screen. These settings work independently, so applying one does not replace the other.
Step 6: Clear or change the filter when your review is done
To switch from completed to incomplete records, open the checkbox column’s filter menu and choose the other value. To show all records again, clear the filter or select both TRUE and FALSE. Leave the top row frozen if you will keep working in the table. To undo the freeze, choose View > Freeze Panes > Unfreeze Panes.
Troubleshooting
The filter menu does not show TRUE and FALSE
Confirm that the cells contain Excel’s in-cell checkbox feature, rather than pictures or checkbox controls floating over the cells. Check that the column is inside the table boundaries and that its header has a filter arrow. If new rows were added outside the table, resize the table to include them.
The header disappears when I scroll
Check that the intended header is in worksheet row 1, then use View > Freeze Panes > Freeze Top Row. If another freeze setting is active, first choose Unfreeze Panes and apply the top-row setting again. Freeze Panes locks worksheet rows, not an arbitrary table header lower down the sheet.
Filtering TRUE does not match the boxes I expected
Click a few boxes and verify their states. A checked box stores TRUE and an unchecked box stores FALSE. If the column contains a mix of checkboxes and text such as “Yes,” those entries are different values; make the column consistent before filtering.
FAQ
Can I filter an Excel table to show only checked boxes?
Yes. Open the checkbox column’s filter menu, clear the selection, select TRUE, and apply the filter. Excel’s in-cell checkboxes use TRUE for checked and FALSE for unchecked.
Does freezing the top row also freeze the table filter?
Freezing keeps worksheet row 1 visible while you scroll. The filter belongs to the table header, so put that header in row 1 if you want it to remain visible with the Freeze Top Row command.
Can I keep both checked and unchecked records visible?
Yes. Select both TRUE and FALSE in the checkbox column’s filter menu, or clear the filter to show every record. The filter can be changed without removing the checkboxes.