As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Unhide Sheets in Excel

If you've hidden sheets in an Excel workbook and need to unhide them, the process is straightforward and can be done in a few simple steps. Below are methods to unhide sheets in Excel using both the Ribbon and keyboard shortcuts.

Unhide Sheets Using the Ribbon:

  1. Click the View tab on the Ribbon.
  2. In the Show/Hide group, click the Unhide Sheet button.
  3. A list of all hidden sheets in the workbook will appear. Select the sheet you want to unhide and click OK.

Unhide Sheets Using the Keyboard Shortcut:

  1. Press Ctrl+Shift+U on your keyboard. This opens the Unhide dialog box.
  2. A list of all hidden sheets will appear. Select the sheet you want to unhide and click OK.

Unhide All Sheets:

If you want to unhide all sheets in an Excel workbook simultaneously:

  1. Click the View tab on the Ribbon.
  2. In the Show/Hide group, click the Unhide Sheet button.
  3. A list of all hidden sheets will appear. At the bottom of the list, select the option to Unhide All.

Additional Tips:

  • You can only hide and unhide sheets in Excel using the Ribbon or keyboard shortcuts; there is no mouse-based method.
  • To hide multiple sheets simultaneously, select them all and click the Hide Sheet button on the Ribbon.
  • Hiding sheets is an effective way to keep your workbook organized. If certain sheets contain data that is not frequently accessed, hiding them can declutter your workspace.