Hide/Show Data

[Mike]

Hey i'm trying to create something that looks like this but i have no idea
how to

+Canada
Ontario
Quebec
Alberta

-China

+USA
Florida
Boston


i want something so that when you click the + / - button it shows/hides
records, does any1 know how to do this? thanks!!!

 

[Dave Peterson]

Maybe...

In xl2003 menus

Select some rows
Data|group and outline
Group

You can use the +/- outlining symbols to the left to show/hide details.

If you had the country code in every row, you could use:
data|subtotals (and even get count or sum of columns)

You'd probably want to sort your data first.

 

[Mike]

that works perfect! thank you!

Maybe...

In xl2003 menus

Select some rows
Data|group and outline
Group

You can use the +/- outlining symbols to the left to show/hide details.

If you had the country code in every row, you could use:
data|subtotals (and even get count or sum of columns)

You'd probably want to sort your data first.