Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make a group of data (not figures) which could be collaps
How do I make a group of data (not figures) which could be expanded and
collapsed? As what I see now Excel 2002 only provides this feature for under subtotal, which is not exactly suits my requirement. |
#2
|
|||
|
|||
Hi
have a look at 'Data - pivot table' "Desmond Low" wrote: How do I make a group of data (not figures) which could be expanded and collapsed? As what I see now Excel 2002 only provides this feature for under subtotal, which is not exactly suits my requirement. |
#3
|
|||
|
|||
|
#4
|
|||
|
|||
First select the range of rows or columns you want to collapse and expand,
then use data group and outline. "CarlosAntenna" wrote in message ... data group and outline "Desmond Low" <Desmond wrote in message ... How do I make a group of data (not figures) which could be expanded and collapsed? As what I see now Excel 2002 only provides this feature for under subtotal, which is not exactly suits my requirement. |
#5
|
|||
|
|||
Lookup "Outline" in the Help files. These old posts may help: http://tinyurl.com/55wgw http://tinyurl.com/6b99n -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Desmond Low" <Desmond wrote in message ... How do I make a group of data (not figures) which could be expanded and collapsed? As what I see now Excel 2002 only provides this feature for under subtotal, which is not exactly suits my requirement. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Computer freezes while using mouse to select group of data in Exce | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) |