Excel View Hidden Sheets. The third property value is very hidden. Apply the sort/filter that you want.
Open two excel files respectively.2. This method is more tedious than the above one, but it is always a good option to know different techniques. To completely lock a sheet for viewing, follow these steps: