Forum Discussion
Missing Tabs at Bottom of Excel Spreadsheet
This is my first post so I apologize if I'm seeking help on something that's obvious or simple.
I'm working on a Dell laptop and I've got the Microsoft suite, including Excel, loaded on it. I've been working on a particular Excel spreadsheet for years, updating it quarterly without problems. Each quarter, I've added a new tab at the bottom of the spreadsheet identified by the appropriate month/day/year. Recently, when I opened this spreadsheet, all the bottom tabs (with the dates) were missing. I've looked at my Advanced settings and I see that the box "Show Sheet Tabs" is checked, so I don't think that's the problem. Also, I see my bottom tabs remain on my other Excel documents so it's not a systemic problem, only a problem with this particular spreadsheet.
I'm working with a touchpad and not a mouse so if I need to touch the touch pad in a particular way, please let me know.
Please help.
Thank you!
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.
Does it help if you maximize or restore the workbook window?
- No, but YouTube was my friend. I watched a brief video that provided a solution. In my Excel spreadsheet, I had to go to "View," then "Arrange All," and finally click the box "Windows of active workbook." That fixed the problem. It wasn't intuitive.
