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.
Check these options and click OK button
- Show horizontal scroll bar
- Show Vertical scroll bar
- Show sheet tabs