Wednesday, February 14, 2007

Hide or unhide a workbook

How to hide a workbook?
How to unhide a workbook?

To hide a workbook,

  • Goto Window->Hide
To unhide a workbook,
  • Goto Window->Unhide
If you have more that one worksheet hidden, then the list of all workbooks hidden would be displayed, from which you may select the workbook you want to unhide.

Note:
Always unhide a worksheet when you quit Microsoft Excel. This is because if you start Microsoft Excel, the next time again, and open the file (workbook) you have hidden, you may not see it. Of course, you can unhide it from the window menu but it is preferred to unhide a workbook before closing it.

No comments: