hiding/unhiding rows & columns with "+" and "-" buttons

S

shellshock

I was given an Excel file from a colleague, and there are these "+" an
"-" buttons above the rows and the columns. When you press them
several rows or columns can be hidden or unhidden all at once. I'v
never seen this before; can anyone tell me how they were implemented
 
R

Rowan

Select rows (or columns) then from menus: Data > Group and Outline > Group.

Data > Group and Outline > UnGroup to undo.

Regards
Rowan
 
S

shellshock

I've figured out that the rows and columns have been "grouped", usin
Data > Group and Outline > Groups
 
Top