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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

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

Allowing expanding and colapsing of groups in a protected workshee 1
What do you use your R-Pi for - which Projects are you planning!? 1
Insert subtotal in a query database Excel 2007 3
Excel grouped data 2
How do I move the expand/collapse for rows and columns in Excel? 0
need Excel formula that figures out which data adds up to total 4
Grouping will not work 1
filling in extra information for subtotals 3

Back
Top