| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hiding formulas in Excel 2000
I want to hide my formulas (formuli ?) and leave everything else unprotected.
Can this be done in Excel 2000 ? |
|
#2
|
|||
|
|||
|
1. Press Ctrl+A (may have to do it twice) to select the sheet.
2. Press Ctrl+1. 3. On the Protection tab uncheck the "locked" box and press OK. 4. Press F5 Special. 5. Click Formulas and press OK. 6. Press Ctrl+1 again and click the "locked" and "hidden" boxes. Press OK. 7. Go to Tools Protection Protect Sheet. HTH Jason Atlanta, GA "HarryMangurian" wrote: I want to hide my formulas (formuli ?) and leave everything else unprotected. Can this be done in Excel 2000 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
| Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
| Excel 2000 running on Windows XP SP2 does not properly open CSV fi | Excel Discussion (Misc queries) | |||
| How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) | |||
| Excel, problem with hiding formulas.... please help! | Excel Worksheet Functions | |||
Linear Mode
