Friday, 8 June 2007

Hiding a Workbook


In an earlier tip, we talked about hiding rows and columns in a workbook. Did you know you can also hide an entire workbook? To hide a workbook, simply choose Window, Hide to make the entire workbook seemingly disappear. This is a great trick for those moments when you don't want unauthorized personnel to see sensitive data but you don't want to close your workbook.
When it's safe to return to your work, choose Window, Unhide. Excel will display the Unhide dialog box, which may contain more than one workbook. Choose the workbook you want to unhide and click OK to redisplay your workbook.

No comments:

Analytics and Statistic

Blog Archive