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