को अहम् ?
- Abhishek Patil
- Mumbai, India
- Hello Friends, I am Abhishek Patil from mumbai. I pretend to be a Jr. Solution Architect to my employer.I also pretend to be a blogger,a superman,Mr.Cool, and sometimes Santa too..... नमस्कार मित्र मैत्रिणिनो, माझ नाव अभिषेक पाटील, एक मुंबईकर, पोटापाण्यासाठी संगणकाच्या कळफ़लकावर रोज ८ तास अत्याचार करतो, आणि फ़ावल्या वेळात ब्लोगिंगच्या माध्यमाने आपली मते लोकांसमोर मांडतो...
My Blog
temp post
>> Wednesday, June 10, 2009
If you want to disable selection of only locked cells and not the whole sheet:
1. Select all cells in the sheet and uncheck "Locked" in Format | Cells | Protection Tab
2. Select only the range of cells you want to make readonly but this time check "Locked"
3. Now protect the whole sheet (with/without a password) and uncheck "Select locked cells"
1. Select all cells in the sheet and uncheck "Locked" in Format | Cells | Protection Tab
2. Select only the range of cells you want to make readonly but this time check "Locked"
3. Now protect the whole sheet (with/without a password) and uncheck "Select locked cells"
Subscribe to:
Posts (Atom)