How can I hide/unhide columns with those neat + and - signs

S

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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

VBA Noob

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

Ctrl + 8

VBA Noob
 
Top