Thread: Hide/Show Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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