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!