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?
Right-click on any worksheet tab and select Unhide
On the Review tab, click Unhide Sheet.
On the Home tab, click Unhide.
On the View tab, click New Window.