Computing.Net > Forums > Office Software > Excel Erasure Protection

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel Erasure Protection

Reply to Message Icon

Name: Brian W
Date: April 2, 2009 at 18:48:45 Pacific
OS: Windows XP
CPU/Ram: 1.0 Gb
Product: Dell / INSPIRION
Subcategory: Microsoft Office
Comment:

What is the best way to protect formulas in Excel spreadsheets from being inadvertenly deleted by the end user?

Thank you.



Sponsored Link
Ads by Google

Response Number 1
Name: AAKaren
Date: April 2, 2009 at 19:03:36 Pacific
Reply:

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.


0

Response Number 2
Name: DerbyDad03
Date: April 2, 2009 at 20:00:46 Pacific
Reply:

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?


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Excel Erasure Protection

Excel Password protection www.computing.net/answers/office/excel-password-protection/2421.html

Word Excel to PDF www.computing.net/answers/office/word-excel-to-pdf/6340.html

excell protection www.computing.net/answers/office/excell-protection/3867.html