RE: Filter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

you could use a Data, Validation list. Include the heading a one item in
the list. Then when you only want to see the heading select it, otherwise
you will be able to see the rest of the list when you open the drop down.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Joe" wrote:

Can I use the filter function in Excel 2007 to show headings and then when
one of the headings is selected it expands the list and shows each item
associated with the heading? For example:

Vehicle List A (Heading)
Car
Truck
Bus

Vehicle List B (Heading)
Car
Truck
Train

Vehicle List C (Heading)
Car
Motorcycle
Train

I want the filter to only show the headings (Vehicle List A, Vehicle List B,
Vehicle List C). However, what I want it to do is expand the table when I
select one of the headings. (Show the items under each heading.)

If the filter function isn't the way to go, I'm open to suggestions. Thanks.
.

Relevant Pages

  • Expanding Headings
    ... I have seen documents that when you click on a headng (or ... even a work on a paragraph) that it expands with a more ... Heading / Title #2 ...
    (microsoft.public.word.formatting.longdocs)
  • Filter
    ... Can I use the filter function in Excel 2007 to show headings and then when ... one of the headings is selected it expands the list and shows each item ... Vehicle List A (Heading) ... If the filter function isn't the way to go, ...
    (microsoft.public.excel.worksheet.functions)
  • Bottom aligned column headers in tabularx
    ... I have a tabularx table with one heading that has a line break so it ... expands over two lines. ...
    (comp.text.tex)
  • Re: Error filtering for unique values
    ... The filter function see the first cell as a heading. ... Expand your range to: D9:D999. ... Just notice that it will copy the filtered range including the heading to the desired place. ...
    (microsoft.public.excel.programming)
  • Re: Error filtering for unique values
    ... The filter function see the first cell as a heading. ... Expand your range to: D9:D999. ...
    (microsoft.public.excel.programming)