CODEWITHSUNDEEP
excelpasswordsrestriction
physlexic
physlexic

Reputation: 868

Restrict the Viewable Area in a shared Excel Document

I have been searching all morning for a way to restrict the viewable area in a shared excel document. I have found how to restrict opening the workbook as a whole and how to restrict editable areas by password, and a few that allude to restricting visible areas but not very clear.

Is this even possible?

Thanks.

Upvotes: 0

Views: 832

Answers (1)

Samuel Hulla
Samuel Hulla

Reputation: 7099

Just hide all the cells or columns manually and then protect the Worksheet.

  1. Click on the column A and press CTRL + SHIFT + 🠊
  2. Hide the columns ( CTRL + 0 )
  3. Protect the worksheet with your desired permission

Now whenever soembody tries to view the Worksheet, they need to unprotect it first via password:

enter image description here

Obviously, you don't have to hide entire worksheet, perhaps just some parts depending on your specific needs

Upvotes: 1

Related Questions