go to menu File -> Options to open Excel Options dialog.

choose Advanced and scroll to  Display section, select “Show sheet tabs”