How to Unshare a Google Sheets Spreadsheet


Sharing a file from Google Drive is a simple and effective way to let other people see and edit your file. It’s great for teams that need to work on a document together, and is one of the best possible ways for a group of people to work on the same spreadsheet.

But occasionally you might need to make changes to the file without letting others do so as well, or you may have discovered that some people with whom you had previously shared the file should no longer have access. Fortunately it’s is possible to unshare a file in Google Sheets so that previous share permissions are no longer valid.

 

How to Stop Sharing a Google Sheets File

The steps in this article were performed in Google Sheets, but will also work in other desktop/laptop Web browsers like Firefox or Microsoft Edge. This guide assumes that you currently have a shared document in Google Sheets, and that you want to stop sharing it. Once you complete these steps, you will have stopped sharing the file with anyone who you no longer want to access the file.

Step 1: Sign into your Google Drive. You can access your Google Drive at https://drive.google.com/drive/my-drive.

 

Step 2: Select the currently-shared file that you would like to unshare. Shared files have an icon next to the file name that looks like two heads.

select a shared file in google docs

 

 

Step 3: Click the Share button at the top-right of the window.

click the sharing button

 

 

Step 4: Click the Advanced button at the bottom-right of the window.

open advanced sharing settings

 

 

Step 5: Click the x to the right of each person that you would like to stop sharing with.

how to unshare a file in google sheets

 

 

Step 6: Click the blue Save changes button at the bottom of the window to apply the changes.

click the save changes button

 

 

Note that if you had previously created a shareable link, then you may want to block that as well. You can do so by clicking the Get shareable link button at the top-right of the window.

click the get shareable link button

 

 

Then clicking the button at the top-right of that window to disable link sharing for the file.

turn off shareable link google sheets

 

 

Did you set permissions on your spreadsheet so that people couldn’t edit certain cells, but now you want them to be able to? Find out how to remove permissions in Google Sheets in order to make cells editable again.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.