worksheet tabs not visible

**mahoni** · 01-03-2008, 08:53 PM

I can only view one worksheet at a time with a particular spreadsheet. There are no tabs to click at the bottom of the screen to view the other worksheets. In excel 2007, if I click on View, then Full Screen, I get the tabs (so I can view the different worksheets) but then I lose the menu and formula bar (so when I click on a cell I can only see its contents and not the formula). I need to see the formula that is applied. This has not happened with other S/Sheets, just this particular one. Anyone have any idea what else I can do to view the worksheet tabs without full screen view?
Mahoni

**Paul** · 01-04-2008, 12:18 AM

Hi Mahoni,

Have you checked here:

Excel Options -> Advanced -> under "Display options for the workbook" -> "Show sheet tabs" box needs to be checked

(Or in Excel 2003, Tools -> Options -> View tab -> Window Options section -> Sheet Tabs should be checked)

**mahoni** · 01-04-2008, 02:56 AM

Yes I forgot to mention that I had checked this. Still doesn't show the tabs.
Mahoni

**royUK** · 01-04-2008, 06:04 AM

Are you sure that the Sheets are not Hidden?

**ChemistB** · 01-04-2008, 05:22 PM

Based on what you said about them appearing full Screen, then they are just out of view. Is there a scroll bar on the right side of the screen? or are they hidden off screen (grab the title bar and move it up) or under the QuickLaunch Toolbar?

To get around this, you can use CNTRL + Page Down to move to the next tab (Page Up for previous tab).

Good luck!

ChemistB