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.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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