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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My rows keep "unhiding" when I do not want them to 6
Help with conditionally unhiding columns 1
Cannot unhide the hidden rows in my spreadsheet 3
Hiding and unhiding columns "toolbar" 3
hiding/unhiding rows 1
MS Excel unhiding columns tip 1
Display columns or rows based on values 1
Unhide columns 2

Top