Probably a basic EXCEL question.............but I don't even know what it is called to do a search on HELP !?

[GivePeasAChance]

So, you know when you have a 'title' or subject in column 1, and then there are sub-titles / subjects which are not initially shown.............unless you click the '+' sign......and when you do lots more rows come up....then you can click '-' to get it back just to the basic information / title.

Does anyone know how to create the + thing so I can add subtitle-like things?

God I hope that makes sense and someone can help

[Kevlarhead]

SOunds like the SUBTOTAL formula

"Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function."

says XL 2K7 help

[Kevlarhead]

OpenOffice Calc has the subtotals command under

Data>SUbtotals

and it's a pretty good copy of Excel 02/03 so I'd assume that's where it is.

Does that help at all?

[fanjolina]

I thought you meant grouping. Try Data > Group and Outline - Group. Thiswill then give you the ability to expand or hide the subcategories.

A word of advice - if you want the Title to still show when the subtitles are hidden (i.e. thereisjust the + sign on display), then only group the subtitles - don't include the row with the title in it.

Hope that's what you meant.

[fanjolina]

I thought you meant grouping. Try Data > Group and Outline - Group. Thiswill then give you the ability to expand or hide the subcategories.

A word of advice - if you want the Title to still show when the subtitles are hidden (i.e. thereisjust the + sign on display), then only group the subtitles - don't include the row with the title in it.

Hope that's what you meant.

[fanjolina]

oops . Internet connection went down so I didn't realise I had already posted.

[DraculaNeedsArteries]

Ohhh I know exactly what you mean what you mean. But don't know what it is call either.

But googling suggests that it might be "outlines"

see here

[DraculaNeedsArteries]

[GivePeasAChance]

OMG I only had a 20 minute convo on the phone and replies are immense - joys of MN.

Thanks all - I will try the subtotal thing now - actually using Open Office (Cheap skate), so will let you know in a minute

Thanks wonderful people

[DraculaNeedsArteries]

No it is not teh subtotal formula.

That is an addition based calculation.

In OO

you need to select the rows yo want to "hide

Then go to Data menu > Group and outline>group

Alternatively I think you can select the rows to hide a press F12

[GivePeasAChance]

It is Outlines !

Thanks the Drac and the Fanj. You are very very very clever

(not quite worked out the grouping to keep title but Fanj's thing makes sense and hopefully by midnight it will be clear )

[fanjolina]

Here's a bit more clarification on how to keep the title:

Row 1: Title
Row 2: Subtitle
Row 3: Subtitle
Row 4: Subtitle

Highlight rows 2-4. Go to Data -> Group & Outline -> Group

Rows 2-4 will now be hidden with a little + in their place. Row 1 will still show the Title.

Does that help?

[GivePeasAChance]

Oh Yes indeed that helped.

I have only gone and done it.

Seriously that would have taken me days/weeks/months/years to work out. Thank you so much

[GivePeasAChance]

Twice now !

Thanks again Excel geeks

[fanjolina]

My pleasure. Glad I could help