• 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 SizeGoogle Sheets: Set Cells to Same Size
  • Google Sheets: Remove Formatting From CellsGoogle Sheets: Remove Formatting From Cells
  • How to Clear Google Search History to Protect PrivacyHow to Clear Google Search History to Protect Privacy
  • How to Enable/Disable Google Play Protect in AndroidHow to Enable/Disable Google Play Protect in Android
  • How to Convert Google Sheets to PDFHow to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other RowGoogle Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes BlankTroubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix GuideGoogle Sheets Won't Let Me Type - Fix Guide
  • Troubleshooting Google Sheets Not PrintingTroubleshooting 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

  • WhatsApp Self-Destructing Messages: What You Need to Know
  • Spotify: How to Merge Playlists
  • Google Duo on Android: How To Add Automatic Captions To Video and Audio Messages
  • Slack: How To Disable Notifications for Threads You’re Following
  • Slack: How To Configure Your Status
  • Google Duo: How To Prevent Other People From Seeing Your Video Before They Pick up Your Call
  • Slack: How To Configure Notification Keywords
  • How to Tell If Your Phone Is Dual-SIM

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