See all How-To Articles

How to Hide / Unhide Workbooks in Excel

This tutorial demonstrates how to hide and unhide workbooks in Excel.


hidewindow ribbon


Hide a Workbook

Hiding worksheets or workbooks in Excel is a useful way of preventing people from seeing data and calculations you want to restrict access to or pull focus from.

To hide a workbook, in the Ribbon, select View > Hide.


hide window hide


The workbook you are currently working in disappears.


hidewindow no window


Unhide a Workbook

  1. To unhide a workbook, in the Ribbon, select View > Unhide.


hidewindow unhide window


If you have previously recorded any macros in Excel and stored them in the personal macro workbook, then you may see the PERSONAL.XLSB workbook as well as the book you have hidden.

  1. Click on the workbook to unhide, and then click OK.


hidewindow unhideworkbook


The hidden workbook reappears.

hidewindow show workbook


See also

See all How-To Articles