Latest ads

Premium Land with House for Sale
- anil1961
- Updated: Friday at 10:15 AM
AWS Certified Solutions Architect-Associate + AWS Certified Cloud Practitioner
- Sanjeewani95
- Updated: Wednesday at 8:16 PM
🚀 එක පැකේජ් එකයි - මාසෙටම Unlimited Internet! 🌐
- sayuru bandara
- Updated: Tuesday at 10:57 AM
🎬 CapCut Pro 1 Month Access! LKR 600
- sayuru bandara
- Updated: Tuesday at 10:55 AM
🚀 Google One AI PRO Plan (Gemini Pro Activation) – 18 Months Access! LKR 2200
- sayuru bandara
- Updated: Tuesday at 10:53 AM

Reply to thread

Message: <blockquote data-quote="MacroMP" data-source="post: 15911603" data-attributes="member: 463565"><p><span style="font-size: 15px"><u>Machan, Try Below Method to Protect the Sheet and set a Password.</u></span></p><p></p><p><span style="font-size: 15px">To lock or unlock a cell:</span></p><p><span style="font-size: 15px"><span style="color: blue">Select the cell(s) you want to lock or unlock.</span></span></p><p><span style="font-size: 15px"><span style="color: blue"></span></span></p><p><span style="font-size: 15px"><span style="color: blue">Right-click the cell(s) you selected.</span></span></p><p><span style="font-size: 15px"><span style="color: blue"></span></span></p><p><span style="font-size: 15px"><span style="color: blue">From the drop-down list, select Format Cells....</span></span></p><p><span style="font-size: 15px"><span style="color: blue"></span></span></p><p><span style="font-size: 15px"><span style="color: blue">Select the Protection tab.</span></span></p><p><span style="font-size: 15px"><span style="color: blue"></span></span></p><p><span style="font-size: 15px"><span style="color: blue">Lock or unlock the cell(s).</span></span></p><p><span style="font-size: 15px"><span style="color: blue"></span></span></p><p><span style="font-size: 15px"><span style="color: blue">To lock the cell, place a check in the Locked check box.</span></span></p><p><span style="font-size: 15px"><span style="color: blue"></span></span></p><p><span style="font-size: 15px"><span style="color: blue">To unlock the cell, clear the Locked check box.</span></span></p><p><span style="font-size: 15px"><span style="color: blue"></span></span></p><p><span style="font-size: 15px"><span style="color: blue">Click OK.</span></span></p><p></p><p></p><p></p><p></p><p><span style="font-size: 15px">To protect cells</span>:</p><p></p><p><span style="font-size: 15px"><span style="color: Blue">View the protect sheet options.</span></span></p><p><span style="font-size: 15px"><span style="color: Blue"></span></span></p><p><span style="font-size: 15px"><span style="color: Blue">In 2007/2010:</span></span></p><p><span style="font-size: 15px"><span style="color: Blue">Select the Review tab.</span></span></p><p><span style="font-size: 15px"><span style="color: Blue"></span></span></p><p><span style="font-size: 15px"><span style="color: Blue">In the Changes group, click the Protect Sheet button.</span></span></p><p><span style="font-size: 15px"><span style="color: Blue"></span></span></p><p><span style="font-size: 15px"><span style="color: Blue">Place a check in the Protect worksheet and contents of locked cells check box.</span></span></p><p><span style="font-size: 15px"><span style="color: Blue"></span></span></p><p><span style="font-size: 15px"><span style="color: Blue">In the Password to unprotect sheet: text box, type your password.</span></span></p><p><span style="font-size: 15px"><span style="color: Blue"></span></span></p><p><span style="font-size: 15px"><span style="color: Blue">Click OK.</span></span></p><p><span style="font-size: 15px"><span style="color: Blue"></span></span></p><p><span style="font-size: 15px"><span style="color: Blue">In the Reenter password to proceed. text box, type your password again.</span></span></p><p><span style="font-size: 15px"><span style="color: Blue"></span></span></p><p><span style="font-size: 15px"><span style="color: Blue">Click OK.</span></span></p><p><span style="font-size: 15px"><span style="color: Blue"></span></span></p><p><span style="font-size: 15px"><span style="color: Blue">You Can Unlock it; Go to Review Tab, Then Click Unprotect Sheet. </span></span></p><p><span style="font-size: 15px"><span style="color: Blue"></span></span></p><p></p><p><span style="font-size: 15px">ලැබීම හෝ වියදම enter කරලා නැති raws දිගටම අන්තිම ශේෂය පෙන්නන් නැතුව තියෙන්න නම් column එක පහලට අදින්නේ නැතුව තියන්න තමා වෙන්නේ. එත් ඕකට If Formula එකක් තියෙන්න ඕනේ ... මම හම්බ වුනොත් දාන්නම් මචන්...</span></p></blockquote><p></p>

Verification: Dahaya deken beduwama keeyada?

Top Bottom