Hide/Show Data
 

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

Hide/Show Data
 

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 wrote:

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

Hide/Show Data
 

that works perfect! thank you!

"Dave Peterson" wrote:

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 wrote:

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