Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
"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
|
|||
|
|||
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
|
|||
|
|||
<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
|
|||
|
|||
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
|
|||
|
|||
"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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XP Sheet tabs | New Users to Excel | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
am unable to view or use sheet tabs | New Users to Excel | |||
I want to print out the sheet tabs (sheet names) | Excel Worksheet Functions | |||
horizontal scroll bar and sheet tabs missing | Excel Discussion (Misc queries) |