Microsoft Office Tutorials and References
In Depth Information
Protecting the Worksheet and the Workbook
Figure 9–38. Clicking directly to the right of the column you want to freeze and directly beneath the row you want
to freeze
Once you’ve gotten a handle on where you want to locate the freeze, click Freeze Panes
Freeze Panes. If you’ve discovered you’ve clicked in the wrong place, just click the
Unfreeze Panes option and try again.
NOTE: As mentioned earlier, converting a database to a table will automatically freeze the top
table row, which is the header of the table.
Protecting the Worksheet and the Workbook
Once you’ve put all that work into your workbook, having outfitted it with rows of
complex formulas and breathtaking charts, you may get a bit nervous about what might
happen next. What if you were to accidentally overwrite—or delete—a formula? True,
you might be able to bring it back with an Undo command, but that prospect would
depend on exactly when you discovered the mishap. Worse yet, what if your five-year-
old nephew began to type some formulas of his own on the sheet?
Have no fear. Excel has anticipated those calamities, by allowing you to protect your
workbooks and individual worksheets with a set of options that should help you fend off
little Timmy’s editorial changes and leave your masterpiece intact.
By way of introduction, you need to understand what protecting a sheet does and
doesn’t do. Protecting a sheet won’t seal off your sheet with industrial-strength
invincibility, foiling the bad guys who want to compromise or steal your data. Not quite,
because workbook and worksheet protection is more about warding off mistakes than
disarming hackers who have your formulas in their sights. Still, protection can do a
pretty good job of, well, protecting your work.
The process of protecting worksheets and workbooks is actually quite easy, but the
details get a bit quirky, as you’ll see.
Search JabSto ::

Custom Search