Follow us on Youtube.  | Follow Website !

Search Suggest

Posts

Instructions to display Excel Sheet Tab when 100% hidden OK

You have 1 excel file downloaded online, you want to open VBA of Tab sheet Excel in this file, but you can't see the Excel Sheet Tab display. So how to be show Excel Sheet Tab when hidden here.

Check out the article below to get a quick answer.

Tutorial steps to display Excel Sheet Tab when quickly hidden

Step 1: Open that Excel file first. Choose to File> Options

Instructions to display Excel Sheet Tab when hidden

Step 2: The Options interface is displayed, select the tab Advanced.

Instructions to display Excel Sheet Tab when hidden

Step 3: Scroll down the section Display options for this workbook > check the box before the item Show sheet tabs

Instructions to display Excel Sheet Tab when hidden

Finally press OK, got it to save the changes.

Instructions to display Excel Sheet Tab when hidden

Now go back to your excel file. The sheet has been displayed.

Instructions to display Excel Sheet Tab when hidden

Pretty simple, isn't it. With the above steps, you have quickly show Excel Sheet Tab when hidden and that.

I wish you successful implementation.

Post a Comment