Can't see worksheet tabs at the bottom (1 Viewer)

R

RexesOperator

Registered User.

Local time

Today, 00:10

Joined

Jul 15, 2006

Messages

604

• May 17, 2007

• #1

This is something of a mystery. I have tried looking in the various help files and searched on this forum, but I can't find a similar problem.

For some reason I can no longer see the worksheet tabs at the bottom of the workbook. In fact they're not visible anywhere that I can find. This is true wether there's only one worksheet or multiples - even after inserting a new worksheet.

I have tried maximizing and resizing the worksheet. When I do that the scroll bars appear only in the resized part of the worksheet. You'll also note there are no scroll bars otherwise. I think this is where the problem is, but I can't seem to fix it.

 

Attachments

• 
  Excel.jpg

  79.9 KB · Views: 1,368

Brianwarnock

Retired

Local time

Today, 05:10

Joined

Jun 2, 2003

Messages

12,701

• May 17, 2007

• #2

Normally people have problems with things dissappearing because they have clicked View Fullscreen , but you are only left with the menu bar then whereas you have other toobars. I'm puzzled also.

Brian

 

Brianwarnock

Retired

Local time

Today, 05:10

Joined

Jun 2, 2003

Messages

12,701

• May 17, 2007

• #3

Checkout the tools options View tab its all on there, somebody has been messing.

Brian

 

R

RexesOperator

Registered User.

Local time

Today, 00:10

Joined

Jul 15, 2006

Messages

604

• May 17, 2007

• #4

That was the key. Thanks. My hard drive crashed a while ago, and it occurs to me this started after that. I must have inadvertently selected an option during the re-install.

 

K

kaufman100

New member

Local time

Yesterday, 21:10

Joined

Jun 1, 2007

Messages

1

• Jun 1, 2007

• #5

I'm using Excel 2007 and all of a sudden, I can't see my worksheet tabs either. The problem occurs with any workbook that I open, not just one.

I went to Excel Options, Advanced and then under "Display options for the workbook" the "Show sheet tabs" box is checked. I tried unchecking it, closing, reopening, checking it again etc... but I still can not see my worksheet tabs.

Help!

 

L

lorlando

New member

Local time

Today, 00:10

Joined

Jul 10, 2008

Messages

1

• Jul 10, 2008

• #6

Maximize the workbook

Your workbook view probably extends down below the box. Try maximizing the workbook.

 

R

RicoT

New member

Local time

Today, 07:10

Joined

Aug 28, 2009

Messages

1

• Aug 28, 2009

• #7

Excel 2007, to reveal the sheet tabs, in excel click on the Office Button left top corner - select excel options at the bottom - select advanced on the left - scroll down to "display options for this workbook" - select check box "show sheet tabs" - click on OK and that's it your sheet tabs will now be visible.

 

T

tempusfugit

New member

Local time

Today, 05:10

Joined

Nov 30, 2009

Messages

1

• Nov 30, 2009

• #8

I think I've got it.

In Excel 2003, make sure you have checked the 'Tools-Options-View-Sheet tabs' box. Then simply click and drag on the far left of your bottom, horizontal scroll-bar. If you drag the handle (to the left of the scroll arrow) to the right then the tabs will be revealed!


Tempusfugit and don't fugitit!
Time flies when you are having fun.