hiding columns or rows not using the hide function

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Don't worry. Found it by selecting required columns or rows and going to Data
- Group and Outline
 
You must log in or register to reply here.

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

Hide columns based on row values 2
Excel EXCEL - using a date dependant formula to hide rows 3
Hide unused rows based on column info 5
hiding an image 2
One-click hide or unhide rows & columns 3
Hide Rows or Columns with +/- button above row/column label headin 2
Hide Rows based on value, but not using autofilter 2
Creating a function to auto hide rows 1

Back
Top