ExcelBanter - Hiding formulas in Excel 2000

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hiding formulas in Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/26426-hiding-formulas-excel-2000-a.html)

HarryMangurian

Hiding formulas in Excel 2000

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

Can this be done in Excel 2000 ?

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

"HarryMangurian" wrote:

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

Can this be done in Excel 2000 ?

All times are GMT +1. The time now is 03:58 PM.