How to hide the rows/columns in a collapsed view?

**q988988** · 11-18-2019, 08:20 PM

How to hide the rows/columns in this view? Please see attached an example from the spreadsheet with the expected outcome.

Help.png

**shg** · 11-18-2019, 08:42 PM

Please take a few minutes to reread the Forum Rules about thread titles, and then amend yours accordingly.

Thanks.

EDIT: Thank you, crystal clear.

It's not a feature I use, but I don't think you can hide it in outline view.

**q988988** · 11-21-2019, 02:45 AM

This is from a spreadsheet I got from others, I can easily clicked into 1/2 to show different rows/columns previously set up. Now I am just trying to figure out how to do this...maybe someone will know the name of this function so I can just google?

**JeteMc** · 11-24-2019, 05:01 PM

From the screen shot it appears that the group feature, found on the Data tab, has been applied to rows 11:18.
Let us know if you have any questions.

**Roel Jongman** · 11-24-2019, 05:04 PM

Group or Outline feature

Read here how to use it or setup.. or google on excel grouping or excel outline to find other tutorials

https://support.office.com/en-us/art...7-8278c49e9aff