Microsoft Office Tutorials and References
In Depth Information
Keeping Others from Tampering with Worksheets
Figure 2-4:
Besides
dragging
it, you can
move a
worksheet
in this dialog
box.
Deleting a worksheet: Select the sheet, and on the Home tab, open the
drop-down list on the Delete button and choose Delete Sheet. You can
also right-click a worksheet tab and choose Delete. Be careful, because
you can’t restore your deleted worksheet by pressing the Undo button.
Copying a worksheet: Select the sheet, hold down the Ctrl key, and drag
the worksheet tab to a new location.
Moving a worksheet to another notebook: Make sure that the other
workbook is open, open the drop-down list on the Format button, and
choose Move or Copy Sheet. Then select the other workbook’s name in
the Move or Copy dialog box and click OK.
Book III
Chapter 2
Color-coding a worksheet: Right-click a worksheet tab and choose Tab
Color. Then select a color in the submenu, or choose More Colors and
select a color in the Colors dialog box.
You can change the size of columns or apply numeric formats to the same
addresses in different worksheets by selecting all the sheets first and then
formatting one worksheet. The formats apply to all the worksheets that you
select. Being able to format several different worksheets simultaneously
comes in handy, for example, when your workbook tracks monthly data and
each worksheet pertains to one month. Another way to handle worksheets
with similar data is to create the first worksheet and copy it to the second,
third, and fourth worksheets with the Copy and Paste commands.
Keeping Others from Tampering with Worksheets
People with savvy and foresight sometimes set up workbooks so that one
worksheet holds raw data and the other worksheets hold formulas that
calculate the raw data. This technique prevents others from tampering with the raw
data. Furthermore, if the worksheet with raw data is hidden, the chance that it
will be tampered with is lower; and if the worksheet is protected, people can’t
Search JabSto ::




Custom Search