Hi,

I wonder how can I insert those neat little + and - signs that allows
users of the sheet to quickly hide and unhide set of rows/columns?

Would be nice feature to learn, but I don't even know what it is
called, so it makes it hard to search from help or google =)


-Sirritys

Select the rows to group, Data>Group And Outline>Group

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sirritys" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I wonder how can I insert those neat little + and - signs that allows
> users of the sheet to quickly hide and unhide set of rows/columns?
>
> Would be nice feature to learn, but I don't even know what it is
> called, so it makes it hard to search from help or google =)
>
>
> -Sirritys
>

Thank you

Now I'm a lot wiser ;-)



Bob Phillips kirjoitti:

> Select the rows to group, Data>Group And Outline>Group
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Sirritys" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> >
> > I wonder how can I insert those neat little + and - signs that allows
> > users of the sheet to quickly hide and unhide set of rows/columns?
> >
> > Would be nice feature to learn, but I don't even know what it is
> > called, so it makes it hard to search from help or google =)
> >
> >
> > -Sirritys
> >

If you want to keep them grouped but hide the + and - symbols then
press

Ctrl + 8

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566928

You can also use Data|Subtotals to get these outlining symbols.

Sirritys wrote:
>
> Hi,
>
> I wonder how can I insert those neat little + and - signs that allows
> users of the sheet to quickly hide and unhide set of rows/columns?
>
> Would be nice feature to learn, but I don't even know what it is
> called, so it makes it hard to search from help or google =)
>
> -Sirritys

--

Dave Peterson

[Zoddy]

I think what you are referring to is 'Grouping' from the Data menu

Select the columns you want to be hidden and then select Data > Group & Outline and finally Group. The selected columns will then have a + or - toggle button in a new row above the headings . The same can be done with rows. (Extra tip if you want to hide the extra rows containing the + & - control use CTRL and 8 (not the num pad 8))

HTH

Originally Posted by Sirritys

Hi,

I wonder how can I insert those neat little + and - signs that allows
users of the sheet to quickly hide and unhide set of rows/columns?

Would be nice feature to learn, but I don't even know what it is
called, so it makes it hard to search from help or google =)


-Sirritys