Restrict the Viewable Area in a shared Excel Document

Question

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.

Answer 1

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:

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