hiding columns or rows not using the hide function

G

Guest

I have come across spreadsheets that have a 1 or 2 in a box in the top left
corner of the sheet, and a plus or minus in a box above columns and rows that
allow you to hide or display a selection of rows/columns. How do you do this?
 
G

Guest

Don't worry. Found it by selecting required columns or rows and going to Data
- Group and Outline
 

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

One-click hide or unhide rows & columns 3
Hiding Columns in split view 1
Hide columns based on row values 2
hiding an image 2
Hiding/Unhiding Rows Automatically 1
How do I limit rows and columns in all of my excel 2007 worksheets 2
Hide Rows or Columns with +/- button above row/column label headin 2
Hide unused rows based on column info 5

Top