Please Help!!!

  • Thread starter Thread starter lucifuge
  • Start date Start date
L

lucifuge

BARE WITH ME!!!!

How can I block only the cell that contains the Formula but make it s
they can keep inputting the daily numbers (I am sharing a spreadshee
that multiple people input daily numbers into. The thing is tha
sometimes they type over the cell that contains the formula that run
the whole sheet)
 
Highlight the whole sheet by clicking the box to the left of column A and
above Row1
In the highlighted area, right click > Format Cells > Protection > Uncheck
'Locked' > OK
On the top toolbar, go Edit > Go To > Click 'Special' > Check 'Formulas' >
OK
In one of the highlighted cells, right click >Format Cells > Protection >
Check 'Locked'
Go 'Tools' > Protect Sheet > Enter a password if you want one > OK
Regards,
Alan.
All cells are n
 
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

How can I protect cells w/formulas from being typed over? 3
Help please!!! writing excel formula..... 6
Check arrays for value. 4
need some basic help 4
Excel Import Comments 3
Excel lookup across entire workbook 1
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1
Hide zero values 2

Back
Top