excel2003 hidden formula
[Users questions | Browse:45 | Favorites]
Users questions: How to hide the formula
Experts answer: excel2003 use Excel lock, hide and protect worksheet function to hide and lock up the formula. 1, select the worksheet data area, implementation of the "Format Cells" command, open the "Format Cells" dialog box. 2, switch to "Protection" tab, clear the "lock" option check box in front of " " No. OK to return. 3, the implementation of the "Edit Location" command, open the "Location" dialog box, click one of the "positioning conditions" button, open the "positioning conditions" dialog box. 4, select one of the "formula" option, and OK to return, Once selected worksheet cells that contain formulas. 5, once again open the "Format Cells" dialog box, switch to "protect" tab, in the "locked" and "Hide" option in front of the check box to add the " " No. OK to return. 6, the implementation of the "Tools Protection Protect Sheet" command, open the "Protect Sheet" dialog box, enter a password, OK, and then make sure to enter a password, you can determine the return. Note: If they need to view or modify the formula, first implementation of the "Tools Protection remove worksheet protection" command, lifting the protection on the worksheet.
Experts answer: excel2003 use Excel lock, hide and protect worksheet function to hide and lock up the formula. 1, select the worksheet data area, implementation of the "Format Cells" command, open the "Format Cells" dialog box. 2, switch to "Protection" tab, clear the "lock" option check box in front of " " No. OK to return. 3, the implementation of the "Edit Location" command, open the "Location" dialog box, click one of the "positioning conditions" button, open the "positioning conditions" dialog box. 4, select one of the "formula" option, and OK to return, Once selected worksheet cells that contain formulas. 5, once again open the "Format Cells" dialog box, switch to "protect" tab, in the "locked" and "Hide" option in front of the check box to add the " " No. OK to return. 6, the implementation of the "Tools Protection Protect Sheet" command, open the "Protect Sheet" dialog box, enter a password, OK, and then make sure to enter a password, you can determine the return. Note: If they need to view or modify the formula, first implementation of the "Tools Protection remove worksheet protection" command, lifting the protection on the worksheet.
- Cell in Excel for graphics.
- domn down the word document, how to remove shading
- Download the Google input Thunder
- PPT pie method to do? Can quickly learn
- How to restore the default browser status ie
- WORD2003 program is broken
- the difference between word and wps?
- Ask CSS problems
- Hide Add Remove Programs
- Computer system and antivirus software
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.