How to find hidden sheets in excel

Method: First open the excel table that needs to be operated and select the sheet; then right-click the mouse and select "Unhide" in the pop-up right-click menu; then press and hold the "shift" key on the keyboard, and at the same time Select the sheets that do not need to be hidden; finally click the "OK" button.

The operating environment of this tutorial: Windows 7 system, WPS Office 2016 version, Dell G3 computer.

So how to display the hidden table? Similarly, right-click and select Unhide.

In the box, click to select the sheet to be displayed, click OK, and the sheet will not be hidden.

Also hold down the shift key and select the sheets that do not need to be hidden to unhide the sheets at the same time.

Related learning recommendations: excel tutorial

The above is the detailed content of How to find hidden sheets in excel. For more information, please follow other related articles on the PHP Chinese website!