Current location - Recipe Complete Network - Complete cookbook of home-style dishes - How to implement hierarchical display in excel, that is, tree-shaped menu
How to implement hierarchical display in excel, that is, tree-shaped menu

1. Open the Excel table and select the data.

2. After selecting the data, click the data in the toolbar.

3. After entering the data page, click the icon in the lower right corner of the grading display.

4. After clicking the icon, the settings window will pop up, and you can choose whether the grading display is at the top or on the left.

5. After selecting the top, the hierarchical display menu will be on top. Click "-" to hide it, and click "+" to display it.