How to set collapse and expand in excel

How to set collapse and expansion in Excel?

Just use the "combine" command. The setting method is as follows:

Recommended: "Excel Tutorial"

Open EXCEL Table, select the rows you want to collapse (combine), click "Data"--Combine.

After that, the cells in rows 1 to 6 are grouped together. At this time, press "1" or "-" to collapse them.

If you want to see the collapsed content, click the "2" or " " sign.

The above is the detailed content of How to set collapse and expand in excel. For more information, please follow other related articles on the PHP Chinese website!