Protecting Cells in Excel 1

[Eytch]

I created a worksheet with five columns of data. The data in the third column is the result of subtraction of the data in the second column from the first. Data in the first, second, fourth, and fifth columns is entered by the user. I highlighted these columns before applying protection. Because the data in column three is the result of a calculation I did not highlight it before applying the protection (I want protection applied to column three). However, after applying the protection and deleting the data in columns one, two, four and five the formula in column three is wiped out and I can again enter data into the cells that make it up. Any suggestions as to how to protect the third intervening column without losing the formula applied to it when data in the other columns is deleted?

Thanks,
Tripoli

 

[SkipVought]

Hi,

You Protect a worksheet NOT cells.

Cells are either Locked or Not Locked, and protecting the sheet prohibits changes to Locked cells.

Format/Cells/Protection Tab

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[davidmunoz]

Skip is correct below in that when you apply protection via cell properties, security, it pertains to the entire workbook. If I'm understanding you correctly you want to allow changes to A1,A2,A4,A5 while keeping A3 unable to delete formula. Well then you need to select all the cells using the CTRL key to select non-consecutive cells, and go into properties and uncheck the Locked box (which is default selected). You could then select A3 only and check Hidden so as to hide your formula from being displayed when worksheet is protected.

The thing is you cannot delete a row of information becuase one of the fields is locked;A3.

Hope this helps!