LinkBack URL
About LinkBacks
I have a few cells in my spreadsheet which contain formulas and I would like to protect those cells from being accidentally edited. Is there a way to do this?
Excel 2000
I have a few cells in my spreadsheet which contain formulas and I would like to protect those cells from being accidentally edited. Is there a way to do this?
Excel 2000
Last edited by Garren1013; 04-27-2010 at 03:39 PM.
Yes, First select the entire worksheet and format cells>Protection and uncheck "Locked"
Then select the cells you want to protect and do the same but Lock them. Then Protect worksheet with a password. Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Right click -> Format cells -> protection -> Uncheck Locked
then
Review -> Protect sheet -> Select Locked or Unlocked cells (wich you want to be selected or not)
Never use Merged Cells in Excel
Thanks. Now, how do I make it say "SOLVED" in these forums?
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks