How to Lock Cells in Excel

Learn how to lock cells in Excel if you are using Excel to hold your data. This is a very useful technique that will protect your workbook, especially when other users are editing your workbook before passing it over to you.

Click here for more Excel Guides

You just need to learn how to lock cells in Excel, which thankfully, is a pretty easy process anyway. See the below steps to secure your workbook:

ADVERT

How to Lock Cells in Excel

How to Lock Cells in Excel
Credit: Microsoft

This is a very useful technique that will protect your workbook, especially when other users are editing your workbook before passing it over to you. You just need to learn

  • Step 1: Select the cells you want to lock so that they are highlighted. 
  • Step 2: On the Home tab, on the toolbar, find the Alignment group and select the small arrow to open the Format Cells pop-up window.
  • Step 3: Locate the Protection tab, then select the Locked checkbox, and hit OK.
  • Step 4: You can open the Review tab in the ribbon, locate the Changes group, and see if Protect Sheet or Protect Workbook is selected, then reapply protection if needed. This is especially useful if cells you know are not locked, and are seemingly locked on the sheet.

Microsoft Excel recommends that you unlock any cells you may want to change before you protect a worksheet or workbook. You can do so after you have applied protection. And with that, your Excel sheet will have locked cells that nobody else can edit!

The fighting in Ukraine is causing families to flee their homes. Please give now to save lives and protect people in need. Donate today!

ADVERT

Keep the conversation going by heading over to our Facebook and Twitter pages. You can also find us on Instagram, TikTok, and YouTube. Be sure to also check out our friends over on GameByte and Sporf.

Along with the latest games, merch, and accessories, the GameByte Shop has an epic Loyalty Points Scheme – earning you points for every £1 you spend. Sign up to hear about exclusive deals, PS5 console drops, and more!

<div class=”klaviyo-form-VAkrCV”></div>

ADVERT

Featured Image Credit: Microsoft