Hiding formulas in Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Can this be done in Excel 2000 ?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hiding formulas 2
Why does Excel print the whole worksheet? 7
hide, unhide column or row after protect worksheet 4
All my work has gone 1
Hide a Formula 3
Excel Protection 2
Conditional formula(s) & labelling 4
Hiding and protecting formula 1

Back
Top