excelexpandcollapse

excel expand and fold

When editing data in excel, scrolling up and down is very inconvenient, especially when you need to check back and forth. When there are two sets of data, it will be much more convenient if the middle data is folded. We can use the "combine" command to accomplish this.

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

2. After that, the cells in rows 1~6 will be grouped together. At this time, press "1" or "-" to close them. rise.

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

Recommended tutorial: excel tutorial

The above is the detailed content of excelexpandcollapse. For more information, please follow other related articles on the PHP Chinese website!