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

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

data > group and outline

"Desmond Low" <Desmond (E-Mail Removed)> wrote in message
news:573F918F-E615-4E84-8F3E-(E-Mail Removed)...
> 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.

's Computer Specifications

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

"CarlosAntenna" <(E-Mail Removed)> wrote in message
news:uW%(E-Mail Removed)...
> data > group and outline
>
> "Desmond Low" <Desmond (E-Mail Removed)> wrote in message
> news:573F918F-E615-4E84-8F3E-(E-Mail Removed)...
> > 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.
>
>

's Computer Specifications

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 (E-Mail Removed)> wrote in message
news:573F918F-E615-4E84-8F3E-(E-Mail Removed)...
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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Y Axis labels: How to make them different to figures used to plot.	happyhenry	Microsoft Excel Worksheet Functions	1	17th Jan 2010 12:51 AM
Make my figures divisable by 3	Shazza	Microsoft Excel Misc	5	5th Feb 2008 06:27 PM
Collaps a menu?	Peter	Microsoft Dot NET Framework Forms	1	9th Jan 2008 01:32 PM
How do I group a caption and object (figures and tables)?	=?Utf-8?B?SnVsaWE=?=	Microsoft Word Document Management	1	17th Oct 2006 08:53 AM
How can I make a group not to show/display in a report if no data is under that group?	erick-flores	Microsoft Access Reports	29	6th Aug 2006 05:54 AM