Forum Discussion
Missing Tabs at Bottom of Excel Spreadsheet
This happened to me, here's the solution to my issue. I have multiple sheets in the workbook, but only one was not showing the sheet tabs. This sheet along with one or two others had split screen (vertical) enabled. Because I'd moved the vertical split so only one cell was visible on the left side of the vertical split, the tabs were not shown. The three horizontal dots could be selected, which then showed three other horizontal dots, which when selected sent me to another sheet in the workbook. BUT THE SOLUTION IS TO MOVE THE VERTICAL SPLIT MORE TO THE MIDDLE OF YOUR SHEET, THIS ALLOWS THE SHEET TABS TO BE VISIBLE ON THE LEFT HAND SIDE OF THE SPLIT SCREEN (WHERE THEY ARE KEPT, OR APPEAR IN SPLIT SCREEN MODE). The other fixes found are important to check as well, => View => Arrange All=>Windows of active workbook. But this had not been changed for the workbook. The vertical split screen was too tight on the left side of the sheet, and the other sheet tabs couldn't fit into the space at the bottom of the sheet. Hope this helps somebody.
Rich W.