What if there are too many columns in excel? How to solve the problem of too many columns in excel

1. For example, here I have an excel table whose data is A-H, here I want not to show this in another way

2. Select any quantity, and then click "data" on the menu, as shown in the figure.

3. Click data to display the drop-down menu. Click "group and grading (G)", as shown in the figure.

4. Click "combination (G)", as shown in the following figure.

Warm Reminder: steps 3 and 4 can be directly selected to press "g" twice consecutively. This is the shortcut key operation. See Figure 5 and 6.

5. Select "-" in the red box shown in the following figure to display the second figure.

 

6. Now I can see many "+" numbers. Do not select the column corresponding to the first "+" number. Select N columns from the next sequence and Repeat steps 1 and 2., 3, 4, and 5. See Figure 8.