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.

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.

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.

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.

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.