Digital collaboration · Digital communication, collaboration and participation (participating) · Digital creation · Digital creation, innovation and scholarship (creative production) · Digital research and scholarship · Google · ICT proficiency · Working with Data

#114 Allow editing only in certain cells using Google Sheets

Google Sheets (Google’s answer to Excel), is a really useful online spreadsheet. You’ll need a free Google Drive account to use it, but it has lots of great features – check out these other 1MinuteCPD videos to see what I mean: 1MinuteCPD posts on Google

In this post I’ll show you how to set up a Google Sheet where editing is only permitted in certain cells. This is great for collaborative research, either between colleagues or students. You can allow anonymous editing, or only invite specific people.

Take a look, it’ll only take a minute….

Featured Image: “protected” by Andreas Sautner licenced under  CC BY-NC 2.0


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s