Hide/Show Data

M

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!!!
 
D

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.
 
M

Mike

that works perfect! thank you!

Dave Peterson said:
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.
Click to expand...
 
Top