Here is a great trick I learned a decade ago from Mack Wilk.
I have a long list of topics in Excel.
I want to convert it to a collapsible outline view.

There is one secret hidden setting that you need to change first.
Then, it is all very easy.

Join the MrExcel community: https://www.mrexcel.com/community/

Table of Contents
(0:00) Need for outline in Excel
(0:28) Secret hidden setting
(0:48) Select detail rows for group 1
(1:05) Group & Outline buttons
(1:25) Select rows with Shift Spacebar
(1:45) Using the Group buttons
(2:09) Third Thursday Webinar

This video answers these common questions:
what does grouping cells in excel do?
what does grouping in excel do?
what does grouping rows in excel do?
excel can’t group rows?
excel do group by?
using grouping in excel?
how do i enable grouping in excel?
excel not allowing grouping?
how excel group?
excel how group rows?
how does excel grouping work?
how to use excel grouping?
how to do excel grouping?
what is excel group file?
how grouping works in excel?
why excel grouping not working?