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.
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?
Summary: Hi Guys, Some time ago I created a spreadsheet containing numerous formulas. As the file was shared with other users on the network I password protected it and yes you've guessed it I have forgotten t...
Summary: Can you not 1) create the form in Excel, 2) protect the form(workbook), 3) unprotect the cells your reader needs to add data into 4) post it to your website ...
Summary: This is how to do it in Excel 2003. If you have a different version, the instructions may vary a little. when you are ready to save your speadsheet go to File, Save, give it a name and click on the To...