Hiding formulas in Excel 2000

H

HarryMangurian

I want to hide my formulas (formuli ?) and leave everything else unprotected.

Can this be done in Excel 2000 ?
 
J

Jason Morin

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
 
Top