How to set the default "Show Sheet Tabs" behavior every time I open a new Excel file?

[bebo021999]

I encountered this situation in Excel 2016.

Whenever I open a new blank file, the default sheet tab (at the bottom, displaying sheet names like Sheet1, Sheet2, etc.) is hidden.

I have to go to File/Options/Advanced and check the "Show sheets tab" box to make the sheet names appear.

However, when I open a new file (Ctrl-N) or open a new one from the Excel icon, I have to manually select the option, as it's not the default behavior.

Has anyone else experienced this issue? Please share your insights.

Thank you.

 

[vladimiratanasiu]

I encountered this situation in Excel 2016.

Whenever I open a new blank file, the default sheet tab (at the bottom, displaying sheet names like Sheet1, Sheet2, etc.) is hidden.

I have to go to File/Options/Advanced and check the "Show sheets tab" box to make the sheet names appear.

However, when I open a new file (Ctrl-N) or open a new one from the Excel icon, I have to manually select the option, as it's not the default behavior.

Has anyone else experienced this issue? Please share your insights.

Thank you.

View attachment 98030

Did you try all these methods ? https://thegeekpage.com/missing-sheet-tabs-in-microsoft-excel/

 

[bebo021999]

Did you try all these methods ?

Unfortunately, all of them were unsuccessful.

 

[MARK858]

Are you saving the file after you have changed the options, in your Excel Start folder (as a replacement for the Book file already there, save under a different name, delete the old file, rename the new file as the old files name)?

 

[bebo021999]

Are you saving the file after you have changed the options, in your Excel Start folder (as a replacement for the Book file already there, save under a different name, delete the old file, rename the new file as the old files name)?

Thank you for your response. I have tried everything as you suggested, and it still hasn't worked. Every time I create a new file, I have to go into the Options to set it up again

 

[RoryA]

Do you have a book.xltx template file?

 

[johnnyL]

Can you post a screen shot of the top part of your excel window?

 

[bebo021999]

Dear all,
After several unsuccessful attempts, I had to reinstall MsOffice, and everything is working fine now. Thanks to everyone for your kind support!

 

[johnnyL]

ok