【實用書籍app】MS Excel 2007 Advance 2|最夯免費app

【實用書籍app】MS Excel 2007 Advance 2|最夯免費app

分享好友

【免費書籍App】MS Excel 2007 Advance 2-APP點子

Microsoft Office Excel 2007 provides options to protect your data from being changed or deleted by using worksheet element security and workbook element security. For other Microsoft Office Excel Tips and Tricks, see my other articles in the Microsoft Excel 2007 Tutorials series.

WORKSHEET ELEMENT SECURITY

On the worksheet that you want to protect, unlock any cells or ranges that you want other users to be able to change:

Select each cell that you want to unlock or select a whole range of cells.

On the Home tab, in the Cells group, click the Format button, then click Format Cells.

On the Protection tab, clear the Locked check box.

You can hide formulas that you don't want users to see:

Select the cells that contain the formulas you want to hide.

【免費書籍App】MS Excel 2007 Advance 2-APP點子

On the Home tab, in the Cells group, click Format, then click Format Cells.

On the Protection tab, select the Hidden check box, then click OK.

If you want to unlock objects like pictures, clip art, or shapes do the following:

Hold down [CTRL] while clicking each object that you want to unlock. The Picture Tools or Drawing Tools will be displayed, adding a Format tab. NOTE! Don't select objects of different types as the Dialog Box Launcher won't initialize.

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. If present, clear the Lock text check box.

Click the Close button.

On the Review tab, in the Changes group, click Protect Sheet.

【免費書籍App】MS Excel 2007 Advance 2-APP點子

In the Allow all users of this worksheet to list, select the elements that you want to allow users to change.

In the Password to unprotect sheet box, type a password for the sheet, click OK, then confirm the password. This is an optional password. If you don't use it, then any user can unprotect the sheet and change the protected elements.

【免費書籍App】MS Excel 2007 Advance 2-APP點子

免費玩MS Excel 2007 Advance 2 APP玩免費

免費玩MS Excel 2007 Advance 2 App

MS Excel 2007 Advance 2 APP LOGO

MS Excel 2007 Advance 2 LOGO-APP點子

MS Excel 2007 Advance 2 APP QRCode

MS Excel 2007 Advance 2 QRCode-APP點子
熱門國家系統支援版本費用APP評分上架日期更新日期
未知Android
Google Play
1.1
App下載
免費
1970-01-012015-01-14
台灣 TaiwanAndroid
Google Play
1.1
App下載
免費
2014-05-282015-03-12