Microsoft Office Tutorials and References
In Depth Information
Hiding Data
Hiding a Workbook
The main reason for hiding a workbook is to
make it quickly disappear from the screen. For
example, you might be working on a
departmental budget worksheet that reveals you will only
have three salespeople next year instead of five.
Should someone from your department walk up
while you’re crunching numbers, it would be
great if you could quickly hide the evidence that
two people are about to be let go. With the click
of one button, you can remove the worksheet
from screen.
Figure 13-4
Hide a workbook quickly using the Hide button.
Tip
As you can see in Figure 13-4, there’s nothing
onscreen that obviously gives away the fact that
a workbook is currently open but hidden. To
unhide a workbook, click the Unhide button on
the View tab. The Unhide dialog box appears,
listing any hidden workbooks (see Figure 13-5).
Select the workbook you want to redisplay from
the Unhide Workbook list and click OK.
Hidden workbooks can be easily
redisplayed by anyone who knows how. To
prevent a workbook from being accessed
by unauthorized personnel, you must
protect it. See the section “Protecting
Data” for help.
Figure 13-5
Unhide hidden
workbooks when you are
ready to work with
them again.
To hide the currently displayed workbook, click
the Hide button on the View tab. The workbook
is immediately removed from the screen, as
shown in Figure 13-4. When a workbook is
hidden, it remains open during your Excel work
session. If you try to end your work session
without redisplaying a hidden workbook, Excel
will tap you on the shoulder and ask if you want
to save it before it’s closed. Click Save in the
dialog box that appears to save the hidden
workbook’s data; if you don’t want to end the
session, click Cancel.
 
Search JabSto ::




Custom Search