How to Lock Cells in Excel

{ "@context": "https://schema.org", "@type": "HowTo", "name": "How to Lock Cells in Excel", "description": "Want to prevent edits in your Excel worksheet? Here's how to lock cells in Excel using Format Cells and sheet protection to keep your data safe.", "step": [ { "@type": "HowToStep", "name": "Select the cells you want to lock", "text": "Click and drag to highlight the specific cells you want to protect from editing in your worksheet." }, { "@type": "HowToStep", "name": "Open the Format Cells menu", "text": "Right-click the selected cells and choose Format Cells from the dropdown menu." }, { "@type": "HowToStep", "name": "Lock the selected cells", "text": "Go to the Protection tab and check the box for Locked, then click OK." }, { "@type": "HowToStep", "name": "Open the Protect Sheet menu", "text": "Go to the Review tab on the ribbon and click Protect Sheet." }, { "@type": "HowToStep", "name": "Set your protection preferences", "text": "In the popup, choose what actions (like formatting or sorting) are still allowed, and set a password if desired." }, { "@type": "HowToStep", "name": "Apply sheet protection", "text": "Click OK to activate protection. The locked cells can no longer be edited without removing protection." } ] }