When on the tab name of worksheet and the bottom and side scrollbar go missing. Making this work very difficult, this article I will introduce how to retrieve the list of worksheets and both scrollbars.

Open the Excel program first and go to the menu. File => Options => At the menu on left, choose Advanced => At the right option, go to the Display options for this workbook section.

How to recover missing Sheet tabs and Scrollbar

Check these options and click OK button

  • Show horizontal scroll bar
  • Show Vertical scroll bar
  • Show sheet tabs