Home |
Search |
Today's Posts |
#1
|
|||
|
|||
protect formula in cell and still allow data deletion
I need to be able to protect the formulas in a cell while still being able to
delete the data. |
#2
|
|||
|
|||
protect formula in cell and still allow data deletion
All cells are locked by default, so when you protect the
worksheet, all cells are protected. To accomplish what you want, go to the Edit menu, choose Goto, click Special and then choose Formulas. Then, go to the Format menu, choose Cells, and then the Protection tab. There, uncheck the locked option. Now protect your sheet. All formulas will be locked, but all other cells will be unlocked. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Shawna" wrote in message ... I need to be able to protect the formulas in a cell while still being able to delete the data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|