I have a spreadsheet for a timetable where about 5 people work on. I want only the spreadsheet owner can view and edit certain (confidential) data. This confidential data is needed for formula's in other sheets in the spreadsheet.

What I do now is, using IMPORTRANGE(). With IMPORTRANGE(), in a separate sheet and make this invisible for other users.

What I look for is a method to make one sheet of a spreadsheet (or columns) invisible for a certain group of users.

1 Answer 1


The best and safest way is to have your confidential data (formulae) on a separate spreadsheet (note: not separate sheet) and use IMPORTRANGE() to import it where it's needed to be injected. Hiding and/or protecting a sheet within the same spreadsheet is not a bullet-proof solution at all and it can be easily compromised.

  • thank Mark, but that's exactly what I'm doing now. The problem is that every workday we get a new spreadsheet,. So I rather want to do this all in one spreadsheet. Jan 14, 2019 at 9:57
  • @Richard yeah, and thats what you should do. but if you are happy with less safe solution you can create hidden & protected sheet which will contain your confidential formulas and set it up with white font on white background with row hight 2px and sheet name containing "hard to produce" symbols
    – user0
    Jan 14, 2019 at 10:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.