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 ?
|