• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Google Sheets: Protect Cells

Google Sheets: Protect Cells

Posted on March 18, 2020 by Mel Hawthorne Leave a Comment

Google Sheets is a great productivity tool with just about every function a user could want. Among the slightly lesser-known but easily most useful, is the ability to protect fields and data ranges.

This function allows you to protect certain fields from accidental editing while you work on them in a collaborative arrangement. You can stop others from editing some of the cells in the file. You can place all sorts of custom restrictions, and here’s how:

First, open your Google Sheets file and click on the Data option in the ribbon menu. Halfway down, you’ll find the option Protected sheets and ranges. Click on it.

Protected sheets and ranges

A side panel will open and show you the options for setting a protected range. Click into the text field there and select the sheet and cells you want to protect there.

Side panel

When you have your fields or sheets selected, click the Set permissions button at the bottom. You’ll then be prompted to restrict who can edit the fields. You will always be able to, but you can set custom restrictions on who else can and can’t. You can give permission to other users on a one by one basis, or you can just show a warning to anyone who wants to edit the field.

Protection options

Tip: You can set restrictions for individual cells, ranges of cells, or even entire sheets in one go if you want. Use the side panel to add restrictions to whatever you’d like!

To delete a range that you’ve already placed, use the side panel again – click on one that you’ve already created, and then click on the trashcan symbol in order to delete it!

Deleting a sheet or field range

You Might Also Like

  • Google Sheets: Set Cells to Same Size
    Google Sheets: Set Cells to Same Size
  • Google Sheets: Remove Formatting From Cells
    Google Sheets: Remove Formatting From Cells
  • How to Clear Google Search History to Protect Privacy
    How to Clear Google Search History to Protect Privacy
  • How to Enable/Disable Google Play Protect in Android
    How to Enable/Disable Google Play Protect in Android
  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix Guide
    Google Sheets Won't Let Me Type - Fix Guide
  • Troubleshooting Google Sheets Not Printing
    Troubleshooting Google Sheets Not Printing

Filed Under: Software Tagged With: Google Sheets

Reader Interactions

Did this help? Let us know! Cancel reply

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

  • Bitwarden: How to Manually Autofill a Login Form
  • Bitwarden: How to Copy the Username and Password of an Entry
  • Bitwarden: How to Open the URL Associated with an Entry
  • How to Increase the Size of Text on Any Website on iPad
  • Chrome: How to Fix Can’t Scroll Using Scrollbars
  • Samsung Galaxy S 21 Plus: How to Check How Much Memory Is Left
  • Google Photos: How to Export Your Albums
  • Bitwarden: How to Deauthorize All Sessions

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.

Follow me on Twitter, or visit my personal blog.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2021 Technipages · All Rights Reserved · Privacy