Display a hidden worksheet. 1  Click Home > Format. 2  Under Visibility, click Hide & Unhide, and then click Unhide Sheet. 3  In the Unhide box, double-click the name of the hidden sheet that you want to display. Note: You can unhide only one worksheet at a time.