| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show or hide outlined data option in a protected worksheet? | Excel Discussion (Misc queries) | |||
| Hide/Show Sub data | Excel Discussion (Misc queries) | |||
| Pivot table Data area show/hide behavior | Excel Discussion (Misc queries) | |||
| How do I hide data labels that show a zero value on histograms? | Charts and Charting in Excel | |||
| HOW DO I HIDE DATA AND SHOW A PLUS SIGN THAT I HAVE HIDDEN DATA H. | Excel Discussion (Misc queries) | |||
Threaded Mode
