How do I make a group of data (not figures) which could be collaps

D

Desmond Low

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.
 
C

CarlosAntenna

First select the range of rows or columns you want to collapse and expand,
then use data > group and outline.
 
R

RagDyeR

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Names in Mail Merge 0
Grouping Rows 1
Embed the same Excel multiple times 0
Expanding Grouped Rows when sheet is Protected 2
Labeling Grouped & Collapsed Columns 0
How do I install Microsoft Equation 3.0 back to Office 365? 0
Excel grouped data 2
Combination of Grouping and Subtotal 0

Top