Search in Row Table Excel 2007

Asked By 20 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 5 points N/A #174562

Search in Row Table Excel 2007

qa-featured

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.

Randolph

Related Questions