• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Google Sheets: How to Lock Rows

Google Sheets: How to Lock Rows

July 28, 2022 by Judy Sanhz Leave a Comment

Knowing how to lock rows in Google Sheets can be helpful. If you’re collaborating on a document, others may need to edit some things on the file. But, there may be some rows or cells you don’t want anyone to touch. The good news is that there is a way you can protect a specific cell, column, or entire row. Here are the steps to follow.

How to Prevent Editing in Google Sheet Cells

Locking a cell or row in Google Sheets will help keep your information safe. Someone may not want to intentionally change something, but accidents do happen. You think you’re editing the right cell to only later realize you were too tired to see you were editing the wrong one. Here’s how you can protect specific information.

Once you have the Google Sheets file open, right-click on a cell, and when the list of options appears, choose View more actions options. It is going to be at the bottom of the list.

Google Sheets Lock options

Click on the Protect Range option when the side menu appears. You should now see the Protected sheets and ranges options. You can manually enter a range of the number of cells you want to protect. Or, you can select the cells you want to lock. Once you choose them, they will be entered into the range automatically.

Google Sheets lock range

Click on the Set permissions option at the bottom right. Here you can set things up so only you can edit or have Google Sheets show a warning to anyone wanting to edit anything. That way, they know what info to keep in mind before they change anything.

Google Sheets Permissions

If you want to allow others to edit the cell, click on the dropdown menu to the right of where it says Only You. Choose the Custom option and add those you want to give editing access to. You’ll need to enter their email address.

Google Sheets Editing Lock

Locking Columns

It’s also possible to lock columns as well. Make sure you’ve selected the column you want to lock. You can right-click on the column, or you can click on the dropdown menu icon that appears when you place the cursor on the cell. Whatever is easier for you.  Both options take you to the same place.

Google Sheets Column lock

When the list of options appears, click on the one that says View more column options, followed by Protect Range. Here you can set the permission just like you would with the cells in the previous section. If you want to lock an entire sheet, click on the sheet tab and choose the set permissions tab to decide who can do what on your sheet. If you want to lock non-contiguous cells, you’ll need to do that individually since there is no option to do that in one step.

You can set things up so you’re the only one who can edit or allow others to edit. You can also have Google Sheets show a warning before anyone changes anything. One more thing to keep in mind is that locking cells, columns, or sheets in Google Sheet is something that can currently be done on the Android or iOS app.

Unlocking

If, after a while, you want to remove the lock, it’s possible. To unlock the cell, row, or sheet, right-click on any cell and go to:

  • View more cell actions
  • Protect range

These are the steps you followed to lock the cell, but these steps also take you to everything else you’ve already locked. To the right, you’ll see everything you’ve blocked. Click on the one you want to unlock and click on the trash icon at the top right. You’ll get a confirmation message, and if you’re sure that you want to undo this, click on the remove button.

Unlock Google Sheet Cell

Conclusion

When it comes to locking on Google Sheets, you have different choices. You can lock a single cell, a row, or even the entire sheet. You can also decide what you want others to be able to do with the file. You can also block everyone out and be the only person who can change anything. How useful do you find this option? Share your thoughts in the comments below, and don’t forget to share the article with others on social media.

You Might Also Like

  • Hide and Unhide Rows and Columns in Google Sheets
    Hide and Unhide Rows and Columns in Google Sheets
  • Excel Header
    Excel: Unhide Rows or Columns
  • Excel Header
    Freeze or Unfreeze Panes, Columns, and Rows in Excel
  • google sheets can't type fix
    Google Sheets: How to Use the Google Translate Formula
  • How to Bypass Google FRP (Google Lock) on Android for Free
    How to Bypass Google FRP (Google Lock) on Android for Free
  • Google Sheets Header
    Google Sheets: Remove Formatting From Cells

Filed Under: Internet

Reader Interactions

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • How to Send HD Pictures and Videos on WhatsApp
  • How to Share Files Using Google Nearby Share
  • Android Battery Will Not Charge Fix
  • Turning on Triple Touch Zoom on Android
  • How to Connect Outlook 2023 to Gmail
  • Netflix: Change Password
  • Step-by-Step Guide: How to Use WhatsApp on Your Computer
  • Android: Enable or Disable Background Data

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy