Skip to content
knowsheets.com
  • Categories
    • About Google Sheets
    • All About Formulas
    • Formatting Sheets
    • Using Buttons in Sheets
    • Apps Script Examples
    • Templates & Examples
  • About Us
  • Contact Us
  • Privacy Policy

knowsheets.com

  • Categories
    • About Google Sheets
    • All About Formulas
    • Formatting Sheets
    • Using Buttons in Sheets
    • Apps Script Examples
    • Templates & Examples
  • About Us
  • Contact Us
  • Privacy Policy

sharing

Protect a Range or a Sheet with Apps Script in Google Sheets

December 14, 2022 by Dave
Apps script to protect a sheet and exclude ranges from that protection

Google Sheets makes sharing your spreadsheets with other users easy. It only takes two or three clicks to give one of your contacts editor, commenter or view-only access to your sheet. But what if you want to go a little further? What if you want to protect parts of a sheet from being edited, but … Read more

Tags Apps Script, protection, sharing Leave a comment

How to Hide Formulas in Google Sheets From Other Users

December 16, 2022November 29, 2022 by Dave
Hidden formulas

If you don’t want viewers of your sheet seeing how you generate your data, you’ll need to hide your formulas. There are 2 ways to do just that. Which you choose will depend on how technical your users are and exactly what you want to accomplish. Hiding the formula bar is very simple (View > … Read more

Tags Formulas, sharing 2 Comments
  • TikTok
  • Facebook
  • Instagram
  • YouTube
Copyright © 2025 knowsheets.com