Please Help!!!

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)
 
A

Alan

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
 

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
=AVERAGE (see underlying values?) 7
Excel Import Comments 3
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1
Help with formula 2
Building a Dynamic Sheet number in a formula 2
Quick VBA Worksheet Change Event or Selection Question: 1

Top