How can I protect cells w/formulas from being typed over?

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

lucifuge

PLEASE BARE WITH ME!!!!

How can I block only the cell that contains the Formula but make it so
they can keep inputting the daily numbers (I am sharing a spreadsheet
that multiple people input daily numbers into. The thing is that
sometimes they type over the cell that contains the formula that runs
the whole sheet).
 
By default all cells on a sheet are locked when the sheet is protected.

CTRL + a(twice in 2003) to select all cells.

Format>Cells>Protection. Uncheck "locked" and OK

Now select the sections/rows/cells to protect and Format>Cells>Protection.
Check "locked" and OK

Tools>Protection>Protect Sheet

The section/row locking does not work if you don't protect the sheet.

BTW........I rarely get nekkid with anyone on a first date<g>


Gord Dibben MS Excel MVP

PLEASE BARE WITH ME!!!!

How can I block only the cell that contains the Formula but make it so
they can keep inputting the daily numbers (I am sharing a spreadsheet
that multiple people input daily numbers into. The thing is that
sometimes they type over the cell that contains the formula that runs
the whole sheet).
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top