· On the Protection tab, clear the Locked check box, and then click OK.
3. To hide any formulas that you don't want to be visible, do the following:
· In the worksheet, select the cells that contain the formulas that you want to hide .
· On the Home tab, in the Cells group, click Format, and then click Format Cells.
· on the Protection tab, select the Hidden check box, and then click OK.
4. To unlock any graphic objects (such as picture, clip art, shapes, or Smart Art
graphics) that you want users to be able to change, do the following:
· Hold down CTRL and click each graphic object that you want to unlock. This display the Picture Tools or Drawing Tools, adding the Format tab.
· On the Format tab, in the Size group, click the Dialog Box Launcher next to Size.
· On the Properties tab, clear the Locked check box, and if presents, clear the Lock text check box .
3. To hide any formulas that you don't want to be visible, do the following:
· In the worksheet, select the cells that contain the formulas that you want to hide .
· On the Home tab, in the Cells group, click Format, and then click Format Cells.
· on the Protection tab, select the Hidden check box, and then click OK.
4. To unlock any graphic objects (such as picture, clip art, shapes, or Smart Art
graphics) that you want users to be able to change, do the following:
· Hold down CTRL and click each graphic object that you want to unlock. This display the Picture Tools or Drawing Tools, adding the Format tab.
· On the Format tab, in the Size group, click the Dialog Box Launcher next to Size.
· On the Properties tab, clear the Locked check box, and if presents, clear the Lock text check box .
No comments:
Post a Comment