A colleague shared an excel file with you, and you want to display a worksheet that is hidden in it. How you can do that?
On the Review tab, click Unhide Sheet.
On the Home tab, click Unhide.
On the View tab, click New Window.
Right-click on any worksheet tab and select Unhide