View original (French)

Share only one sheet of a Google Sheet file.

angel1910 Posted messages 7 Status Member -  
 hkim -
Hello,

I would like to share only one sheet in read-only mode from my Google Sheets workbook, and ensure that the other sheets are not accessible or even visible. I would be the only one with access to the complete file (and possibly a few others on a case-by-case basis).

Is this possible?

Thank you in advance for your help!

2 answers

  1.
    warold Posted messages 79 Status Member 177
     
    Hello,

    On Google Sheets it's possible, right-click on the sheet tab and then protect the sheet. Then you manage the permissions as you wish.

    Have a nice day.
    0
    1. angel1910 Posted messages 7 Status Member 4
       
      Hello,

      By right-clicking, I can manage the editing permissions of the sheet but not the visibility.
      I would like the people with read access to the file to only see the first tab and not the others.
      4
    2. warold Posted messages 79 Status Member 177
       
      Indeed, there are only modification permissions. This feature is not yet offered by Google. Maybe in the future...
      0
    3. angel1910 Posted messages 7 Status Member 4
       
      Oh well, that's a shame...
      Well, I found an alternative by creating a second file and using the formula
      = IMPORTRANGE to transpose the data I want to share.

      Thanks anyway for your response.
      0
    4. easypask
       
      Thank you, I was also looking for this function, I will also use IMPORTRANGE in the meantime.
      0