Excel Erasure Protection

Dell / INSPIRION
April 2, 2009 at 18:48:45
Specs: Windows XP, 1.0 Gb
What is the best way to protect formulas in Excel spreadsheets from being inadvertenly deleted by the end user?

Thank you.


See More: Excel Erasure Protection

Report •


#1
April 2, 2009 at 19:03:36
Highlight the cells you don't care if they are deleted, can hold down Control and click each cell one by one to highlight ones that aren't side by side. Right click, Format cells, Protection and uncheck the locked button.

Once done select the cells that you don't want to be deleted in the same manner. Go to top of sheet click on Tools, Protection, protect sheet. It will then ask for a password, enter that, then enter again when prompted and there you go. only the cells you did first will be the ones you can change he text inside of.


Report •

#2
April 2, 2009 at 20:00:46
re: Once done select the cells that you don't want to be deleted in the same manner.

Please explain why these cells need to be selected.

Wouldn't protecting the sheet after the other cells are unlocked protect all the locked cells - without them being selected?


Report •

Related Solutions


Ask Question