Help!

How to show sheet tabs in Microsoft Excel

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions RSS
Next:  Inserting fillable Rows within a Protected Worksh..  
Author Message
Shenda
External


Since: Nov 18, 2005
Posts: 1



PostPosted: Fri Nov 18, 2005 4:09 pm    Post subject: How to show sheet tabs in Microsoft Excel
Archived from groups: microsoft>public>excel>worksheet>functions (more info?)

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


Since: Oct 21, 2005
Posts: 127



PostPosted: Fri Nov 18, 2005 4:17 pm    Post subject: RE: How to show sheet tabs in Microsoft Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Shenda
External


Since: Nov 18, 2005
Posts: 4



PostPosted: Fri Nov 18, 2005 4:31 pm    Post subject: RE: How to show sheet tabs in Microsoft Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Elkar
External


Since: Oct 21, 2005
Posts: 127



PostPosted: Fri Nov 18, 2005 5:03 pm    Post subject: RE: How to show sheet tabs in Microsoft Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Shenda
External


Since: Nov 18, 2005
Posts: 4



PostPosted: Fri Nov 18, 2005 6:38 pm    Post subject: RE: How to show sheet tabs in Microsoft Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Dave Peterson
External


Since: Jul 08, 2005
Posts: 16264



PostPosted: Fri Nov 18, 2005 7:01 pm    Post subject: Re: How to show sheet tabs in Microsoft Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Shenda
External


Since: Nov 18, 2005
Posts: 4



PostPosted: Fri Nov 18, 2005 7:01 pm    Post subject: Re: How to show sheet tabs in Microsoft Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
>
Back to top
Randall.Senn
External


Since: Nov 20, 2005
Posts: 5



PostPosted: Sun Nov 20, 2005 11:59 pm    Post subject: Re: How to show sheet tabs in Microsoft Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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


Since: Nov 18, 2005
Posts: 4



PostPosted: Mon Nov 21, 2005 6:13 pm    Post subject: Re: How to show sheet tabs in Microsoft Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.
>
>
Back to top
Doug K
External


Since: Jun 20, 2005
Posts: 2



PostPosted: Mon Jan 16, 2006 12:01 pm    Post subject: RE: How to show sheet tabs in Microsoft Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Don Guillett
External


Since: Jan 04, 2006
Posts: 3013



PostPosted: Mon Jan 16, 2006 2:39 pm    Post subject: Re: How to show sheet tabs in Microsoft Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

could it be view>full screen??

--
Don Guillett
SalesAid Software
dguillett1@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
Back to top
laurlang



Joined: Jul 02, 2008
Posts: 1



PostPosted: Wed Jul 02, 2008 8:21 pm    Post subject: Just in case anyone's still trying to solve this issue [Login to view extended thread Info.]

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...
Back to top
adjabc



Joined: Oct 20, 2009
Posts: 1



PostPosted: Tue Oct 20, 2009 6:01 pm    Post subject: [Login to view extended thread Info.]

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??????
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum