How to show sheet tabs in Microsoft Excel

Shenda · External Since: Nov 18, 2005 Posts: 1

I seem to have lost the hoprizontal scroll bar in Excel worksheet and so
cannot access the sheet tabs

Elkar · External Since: Oct 21, 2005 Posts: 127

Select "Tools" --> "Options" --> "View" Tab

You should see checkboxes for "Scroll Bars" and "Sheet Tabs" in the
lower-right of the window. Make sure those are checked.

"Shenda" wrote:

> I seem to have lost the hoprizontal scroll bar in Excel worksheet and so
> cannot access the sheet tabs

Shenda · External Since: Nov 18, 2005 Posts: 4

Did as you said and all boxes were ticked. any more suggestions?

"Elkar" wrote:

> Select "Tools" --> "Options" --> "View" Tab
>
> You should see checkboxes for "Scroll Bars" and "Sheet Tabs" in the
> lower-right of the window. Make sure those are checked.
>
> "Shenda" wrote:
>
> > I seem to have lost the hoprizontal scroll bar in Excel worksheet and so
> > cannot access the sheet tabs

Elkar · External Since: Oct 21, 2005 Posts: 127

Ok, my next guess would be that you've dragged your workbook window down so
that the bottom is obscured. Try dragging the workbook window back up, or
Maximizing the window. (Note: I'm referring to the workbook window, not the
Excel window)

"Shenda" wrote:

> Did as you said and all boxes were ticked. any more suggestions?
>
> "Elkar" wrote:
>
> > Select "Tools" --> "Options" --> "View" Tab
> >
> > You should see checkboxes for "Scroll Bars" and "Sheet Tabs" in the
> > lower-right of the window. Make sure those are checked.
> >
> > "Shenda" wrote:
> >
> > > I seem to have lost the hoprizontal scroll bar in Excel worksheet and so
> > > cannot access the sheet tabs

Shenda · External Since: Nov 18, 2005 Posts: 4

Thanks Elkar, will try it out when i get back to my work computer on Monday

"Elkar" wrote:

> Ok, my next guess would be that you've dragged your workbook window down so
> that the bottom is obscured. Try dragging the workbook window back up, or
> Maximizing the window. (Note: I'm referring to the workbook window, not the
> Excel window)
>
> "Shenda" wrote:
>
> > Did as you said and all boxes were ticked. any more suggestions?
> >
> > "Elkar" wrote:
> >
> > > Select "Tools" --> "Options" --> "View" Tab
> > >
> > > You should see checkboxes for "Scroll Bars" and "Sheet Tabs" in the
> > > lower-right of the window. Make sure those are checked.
> > >
> > > "Shenda" wrote:
> > >
> > > > I seem to have lost the hoprizontal scroll bar in Excel worksheet and so
> > > > cannot access the sheet tabs

Dave Peterson · External Since: Jul 08, 2005 Posts: 16264

Window|Arrange|Horizontal
(maybe it's just off the viewable window???)

(resize the way you want later.)

Shenda wrote:
>
> I seem to have lost the hoprizontal scroll bar in Excel worksheet and so
> cannot access the sheet tabs

--

Dave Peterson

Shenda · External Since: Nov 18, 2005 Posts: 4

Thanks, will try it. I actually had the problem on my work computer, so will
have to wait til Monday before I can check if what you are suggesting works

"Dave Peterson" wrote:

> Window|Arrange|Horizontal
> (maybe it's just off the viewable window???)
>
> (resize the way you want later.)
>
> Shenda wrote:
> >
> > I seem to have lost the hoprizontal scroll bar in Excel worksheet and so
> > cannot access the sheet tabs
>
> --
>
> Dave Peterson
>

Randall.Senn · External Since: Nov 20, 2005 Posts: 5

Try Tools > Options > View and then check to see if the Horizontal
Scroll Bar and Sheet Tabs are both checked to be visible.

Shenda · External Since: Nov 18, 2005 Posts: 4

they are both checked to be visible

"Randall.Senn@excite.com" wrote:

> Try Tools > Options > View and then check to see if the Horizontal
> Scroll Bar and Sheet Tabs are both checked to be visible.
>
>

Doug K · External Since: Jun 20, 2005 Posts: 2

Hi, I had the same thing happen. I followed your advice and I still can not
see the sheet tabs or the bottom and side scrool bars along with the top of
the page.
--
Doug K

"Elkar" wrote:

> Select "Tools" --> "Options" --> "View" Tab
>
> You should see checkboxes for "Scroll Bars" and "Sheet Tabs" in the
> lower-right of the window. Make sure those are checked.
>
> "Shenda" wrote:
>
> > I seem to have lost the hoprizontal scroll bar in Excel worksheet and so
> > cannot access the sheet tabs

Don Guillett · External Since: Jan 04, 2006 Posts: 3013

could it be view>full screen??

--
Don Guillett
SalesAid Software
dguillett1.RemoveThis@austin.rr.com
"Doug K" wrote in message

> Hi, I had the same thing happen. I followed your advice and I still can
> not
> see the sheet tabs or the bottom and side scrool bars along with the top
> of
> the page.
> --
> Doug K
>
>
> "Elkar" wrote:
>
>> Select "Tools" --> "Options" --> "View" Tab
>>
>> You should see checkboxes for "Scroll Bars" and "Sheet Tabs" in the
>> lower-right of the window. Make sure those are checked.
>>
>> "Shenda" wrote:
>>
>> > I seem to have lost the hoprizontal scroll bar in Excel worksheet and
>> > so
>> > cannot access the sheet tabs

laurlang · Joined: Jul 02, 2008 Posts: 1

For anyone interested, I just had this issue and did everything I could do to try to fix it. I couldn't find anything online to help, but I did finally fix it. Basically, it's like I had split the screen although you never would have known it because it was as if the center vertical bar (that divides the screen when you split it) had been dragged all the way over to the left. Try hovering for the little double-sided arrow on the left side of the window, drag it to the right, then go to Tool Bar --> Window --> Unsplit Screen. It worked for me! Good luck...

adjabc · Joined: Oct 20, 2009 Posts: 1

I have the same problem and none of these suggestions are working. I've tried:

1. "Tools" --> "Options" --> "View" Tab
2. Tool Bar --> Window --> Unsplit Screen
3. Maximizing the screen
4. Re-starting my computer
5. Checking my C-Drive space

ANY OTHER SUGGESTIONS??????