At the same time, you will get an email with the actions your colleagues perform in the document. Once they try to change something they will get a warning about editing the protected range and they will have to confirm the action. If you select the Show a warning when editing this range radio button, everyone with access to the file will have the access to this sheet as well.The next step would be to adjust the settings for the users. You can allow editing only particular cells of the table by checking the Except certain cells option and entering the cells or the ranges of cells. Make sure that the Sheet button is already pressed: Right-click the worksheet tab and choose to Protect sheet. Thus, you'll reduce the number of unintentional changes to the minimum.
Since we've already covered how to give access to your tables and what rights you can grant the users, the first very simple piece of advice would be this - try to allow viewing the table instead of editing. To avoid that, you can protect the data in Google Sheets. But it will take some time to look through the whole list and, besides, it will cancel the rest of the "right" changes. Of course, we can always view the revision history (more on that later) and undo the changes.
Well, one of your colleagues may happen to change or remove the data accidentally. When lots of people have access to your documents, you may want to protect the table, the worksheet or the range of cells.
Decide whether to give the person the rights to edit or comment on the table or only to view the data: To grant access to your tables, press the Share button at the upper right corner of the Google Sheets web-page and enter the names of those users who will work with the table.All you need to do is share Google Sheets documents and start working. There's no need to email the files or to guess what changes were made by your colleagues anymore. You will learn how to share, move and protect your data in Google Sheets.Īs I've already mentioned in my previous article, the main advantage of Google Sheets is the possibility for several people to work with the tables simultaneously. Moving on to another stop of our "Back to Basics" journey, today I will tell you more about managing your spreadsheets.