Chapter 3: Performing Basic Worksheet Operations
3
which lists all hidden sheets. Choose the sheet that you want to redisplay, and click OK.
You can’t select multiple sheets from this dialog box, so you need to repeat the command
for each sheet that you want to unhide. When you unhide a sheet, it appears in its previous
position among the sheet tabs.Preventing Sheet Actions
To prevent others from unhiding hidden sheets, inserting new sheets, renaming sheets, copying sheets,
or deleting sheets, protect the workbook’s structure.
- Choose Review ➪ Protect ➪ Protect Workbook.
- In the Protect Structure and Windows dialog box, select the Structure option.
- Provide a password (optional) and click OK.
After performing these steps, several commands will no longer be available from the Ribbon or when
you right-click a sheet tab: Insert, Delete Sheet, Rename Sheet, Move or Copy Sheet, Tab Color, Hide
Sheet, and Unhide Sheet. Be aware, however, that this is a weak security measure. Cracking this par-
ticular protection feature is relatively easy.
Controlling the Worksheet View
As you add more information to a worksheet, you may find that navigating and locating
what you want becomes more difficult. Excel includes a few options that enable you to view
your sheet, and sometimes multiple sheets, more efficiently. This section discusses a few
additional worksheet options at your disposal.Zooming in or out for a better view
Normally, everything you see onscreen is displayed at 100%. You can change the zoom per-
centage from 10% (very tiny) to 400% (huge). Using a small zoom percentage can help you
get a bird’s-eye view of your worksheet to see how it’s laid out. Zooming in is useful if you
have trouble deciphering tiny type. Zooming doesn’t change the font size specified for the
cells, so it has no effect on printed output.Excel contains separate options for changing the size of your printed output. (Use the controls in the
Page Layout ➪ Scale to Fit Ribbon group.) See Chapter 7, “Printing Your Work,” for details.You can change the zoom factor of the active worksheet window by using any of these
three methods:■ (^) Use the Zoom slider located on the right side of the status bar. Click and drag the
slider, and your screen transforms instantly.
■ (^) Press Ctrl and use the wheel button on your mouse to zoom in or out.