Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 7th 05, 08:17 PM
Gordon
 
Posts: n/a
Default Sheet tabs not showing - 2003

I have a workbook in Excel 2003 where the only way I can get the sheet tabs
to show is by inserting a worksheet. If I then click on one of the "real"
worksheets, the tabs disappear! I do have "show worksheet tabs" checked in
Tools-options-view.
How do I correct this?

thanks.



  #2   Report Post  
Old July 7th 05, 08:23 PM
Gordon
 
Posts: n/a
Default

"Gordon" wrote in message
...
I have a workbook in Excel 2003 where the only way I can get the sheet tabs
to show is by inserting a worksheet. If I then click on one of the "real"
worksheets, the tabs disappear! I do have "show worksheet tabs" checked in
Tools-options-view.
How do I correct this?

thanks.


In fact it's quite weird - this only happens on one sheet. If I'm on that
sheet, then the worksheet tabs are missing - if I insert a sheet, the tabs
re-appear, and if I go to another sheet, the behaviour is normal!


  #3   Report Post  
Old July 7th 05, 08:51 PM
 
Posts: n/a
Default

Hi

Are you sure that there are no macros on the sheet that might be giving you
this strange behaviour?

Andy.

"Gordon" wrote in message
...
"Gordon" wrote in message
...
I have a workbook in Excel 2003 where the only way I can get the sheet
tabs to show is by inserting a worksheet. If I then click on one of the
"real" worksheets, the tabs disappear! I do have "show worksheet tabs"
checked in Tools-options-view.
How do I correct this?

thanks.


In fact it's quite weird - this only happens on one sheet. If I'm on that
sheet, then the worksheet tabs are missing - if I insert a sheet, the tabs
re-appear, and if I go to another sheet, the behaviour is normal!



  #4   Report Post  
Old July 8th 05, 08:18 AM
Gordon
 
Posts: n/a
Default

<Andy wrote in message ...
Hi

Are you sure that there are no macros on the sheet that might be giving
you this strange behaviour?

Andy.


No, there are no macros!


  #5   Report Post  
Old July 8th 05, 01:25 PM
Dave Peterson
 
Posts: n/a
Default

Any chance that the bottom scrollbar is just covering some of the tabs?

You can resize the scrollbar by dragging the left hand edge right or left.

Gordon wrote:

I have a workbook in Excel 2003 where the only way I can get the sheet tabs
to show is by inserting a worksheet. If I then click on one of the "real"
worksheets, the tabs disappear! I do have "show worksheet tabs" checked in
Tools-options-view.
How do I correct this?

thanks.


--

Dave Peterson


  #6   Report Post  
Old July 8th 05, 01:29 PM
Gordon
 
Posts: n/a
Default

"Dave Peterson" wrote in message
...
Any chance that the bottom scrollbar is just covering some of the tabs?

You can resize the scrollbar by dragging the left hand edge right or left.

Gordon wrote:

I have a workbook in Excel 2003 where the only way I can get the sheet

tabs
to show is by inserting a worksheet. If I then click on one of the

"real"
worksheets, the tabs disappear! I do have "show worksheet tabs" checked

in
Tools-options-view.
How do I correct this?

thanks.


--

Dave Peterson


I'm not sure what the problem was - I copied the data to a new sheet,
deleted the "offending" one, and all is now hunkey-dorey!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XP Sheet tabs JudithJubilee New Users to Excel 5 June 15th 05 08:16 PM
Impoting data from Sheet 1 to Sheet 2 a-leano Excel Discussion (Misc queries) 1 April 20th 05 01:05 AM
am unable to view or use sheet tabs dazed and confused New Users to Excel 3 April 12th 05 12:29 AM
I want to print out the sheet tabs (sheet names) Sundus Excel Worksheet Functions 3 February 23rd 05 08:34 PM
horizontal scroll bar and sheet tabs missing Cassandra Excel Discussion (Misc queries) 3 February 23rd 05 11:37 AM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017