Search in Row Table Excel 2007

Asked By 20 points N/A Posted on -

In the header row made in a table in Excel 2007, I have a cell named ‘Name’ which contains the people’s names.

When I try to search for an individual’s name, the header row filter shows me other names at the bottom.

After I go back and I choose ‘Select all’, some of the rows at the bottom remain hidden.

Is anyone willing to give me a solution?

Answered By 0 points N/A #174562

Search in Row Table Excel 2007


Hello John

This may be because you do not have an outline created in your table.

You can create an outline that will display summary rows/columns or reveal data for each group.

Please access the link I have provided you. It will give you detailed information about Outlines,

how to create them and what they do.

Outline (group) data in a worksheet

I hope you will find this information useful.


Login/Register to Answer

Related Questions