excel side bar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hcubed - 19 Apr 2007 22:58 GMT

I have an excel spreadsheet which has on the left hand side in front of the
numbers an area with a + sign and when you click on this + sign it drops the
rows for example 4-8, and if I click on it again it hides them, how can I
create this?

Thanks

Reply to this Message

Gord Dibben - 19 Apr 2007 23:13 GMT

Data>Group and Outline.

Gord Dibben MS Excel MVP

>I have an excel spreadsheet which has on the left hand side in front of the
>numbers an area with a + sign and when you click on this + sign it drops the
>rows for example 4-8, and if I click on it again it hides them, how can I
>create this?
>
>Thanks

Reply to this Message

JE McGimpsey - 19 Apr 2007 23:14 GMT

See Help for "Group or ungroup rows or columns in an outline"

> I have an excel spreadsheet which has on the left hand side in front of the
> numbers an area with a + sign and when you click on this + sign it drops the
> rows for example 4-8, and if I click on it again it hides them, how can I
> create this?
>
> Thanks

Reply to this Message

Dave Peterson - 19 Apr 2007 23:20 GMT

You can get those outlining symbols in a couple of ways:

Data|subtotals
or
Data|Group and Outline

> I have an excel spreadsheet which has on the left hand side in front of the
> numbers an area with a + sign and when you click on this + sign it drops the
> rows for example 4-8, and if I click on it again it hides them, how can I
> create this?
>
> Thanks

Signature

Dave Peterson

Reply to this Message

Frik - 21 Jun 2007 14:45 GMT

Hi

I often use the function when dealing with large spreadsheets. Is there
some means of adding names rather than just having the + / - signs? When
there is a summary column its no issue but there are times I have no such
column and loose track of what is hidden where.

Frik

> You can get those outlining symbols in a couple of ways:
>
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message