Filtering a document

Hi Pauline,

Thank you for the forum question.

If the filters aren't showing in your Excel document, here are a few steps you can take to restore them:

Step-by-Step to Show Filters in Excel

1. Select the Header Row
- Click on the row that contains the column headers (usually the first row of your data).

2. Enable Filters
- Go to the "Data" tab on the ribbon.
- Click on "Filter" (it looks like a funnel icon).

This should add drop-down arrows to each column header, allowing you to filter the data.

3. Check for Merged Cells:
- Filters won’t work if there are merged cells in the header row. Unmerge any merged cells by:
- Selecting the header row.
- Going to the "Home" tab.
- Clicking "Merge & Center" and choosing "Unmerge Cells".

4. Ensure You're in a Table or Range:
- If the data is in a table, filters should be automatic.
- If not, you can convert your data to a table:
- Select your data.
- Press Ctrl + T or go to Insert > Table.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector