Excel table with section headers

Question

Hi

I am trying to make a report in excel, like an audit. Each worksheet will be based upon a table with headings, and sub-headings (sometimes 3 or 4 levels).

Then I would like to be able to filter the table when searching for several keywords, but the section headers should remain as they are not part of the data.

Please could some people give some ideas on how to achieve this.

This image shows a sample. For example, resources and manpower are 2nd level and 3rd level headings. I would like to filter the data in manpower for BF, LU.

Answer 1

Hi,

Welcome to Microsoft Community.

Let us select the entire “ManPower” row and apply filter, to filter the data present in the manpower header.

You may refer to the following article to know more about “Using Advanced Filters in Excel 2010”

https://support.microsoft.com/en-us/kb/2720580

Hope this information helps you. Please let us know if you need additional information.

Thank you.

Answer 2

Hi,

Use custom filters with the criteria of Contains BF or LU

Answer 3

Hi,

Thanks for your answers.

I think both of you are suggesting filtering each sub section separately.

I should have been clear to say that I need the whole table filtered as one unit, not separate sections. So if we filter the whole table (which may have 20 sub headers) we want the headers and sub headers to remain, and the data rows under the headers to be filtered, for example with criteria BF, LU etc.

Answer 4

Sorry, I should also add that for me, the filters are not a problem. It's for the end users who are reading the report. What I need is a way for them to be able to easily filter the whole table for different criteria, whilst keeping the headers. They are end users, so a complicated way with formulas or making new ranges wont help as they wont follow the steps.

Answer 5

Hi

Could anyone help with any ideas on how to achieve this?