How to remove all hidden rows and columns in excel

How to cancel all hidden rows and columns in excel: First open the excel table and select the entire table; then point the mouse to any row or column, the mouse pointer will change to an arrow style; then click the right button of the mouse, and in the pop-up Just select "Unhide" from the right-click menu of the mouse.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

First use the mouse to click on the intersection of the rows and columns of the Excel table. After clicking, the entire Excel worksheet will be selected.

Point the mouse to any line number, and the mouse pointer will change into the arrow style as shown.

At this time, click the right button of the mouse, and then click [Unhide] in the right-click menu.

After clicking [Unhide], all hidden rows in the worksheet will be displayed.

#If you want to show all hidden columns, point the mouse at any column label.

Similarly, click [Unhide] in the right-click menu to display all hidden columns.

Recommended tutorial: "Word Tutorial"

The above is the detailed content of How to remove all hidden rows and columns in excel. For more information, please follow other related articles on the PHP Chinese website!