ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 not showing tabs (https://www.excelbanter.com/excel-discussion-misc-queries/159967-excel-2007-not-showing-tabs.html)

Dale

Excel 2007 not showing tabs
 
I have just installed Office 2007 and when I went to open one of my older
spreadsheets none of the page tabs are showing. When I open the spreadsheet
on another machine the tabs are still there.
How do I get page 2, 3 and so on to appear as tabs at the bottom?

Any suggestions are greatly appreciated

Thanks
Dale

Wondering[_2_]

Excel 2007 not showing tabs
 
Office Button/Excel Options/Advanced/Display options for this workbook -
Check Show sheet tabs

"Dale" wrote in message
...
I have just installed Office 2007 and when I went to open one of my older
spreadsheets none of the page tabs are showing. When I open the
spreadsheet
on another machine the tabs are still there.
How do I get page 2, 3 and so on to appear as tabs at the bottom?

Any suggestions are greatly appreciated

Thanks
Dale




Dale

Excel 2007 not showing tabs
 
I went there and that option was already checked, I unchecked it, closed and
reopened then rechecked it and still no tabs. Again I can go to another
machine that has 2007 on it and the tabs display there. Any other thoughts?

"Wondering" wrote:

Office Button/Excel Options/Advanced/Display options for this workbook -
Check Show sheet tabs

"Dale" wrote in message
...
I have just installed Office 2007 and when I went to open one of my older
spreadsheets none of the page tabs are showing. When I open the
spreadsheet
on another machine the tabs are still there.
How do I get page 2, 3 and so on to appear as tabs at the bottom?

Any suggestions are greatly appreciated

Thanks
Dale





Wondering[_2_]

Excel 2007 not showing tabs
 
Another possiblity is that your scroll bar at the bottom of the worksheet
which is on the same line as the tabs is extended all the way to the left,
completely hiding the tabs and the tab controls. If the left-pointing arrow
on the scroll bar is at the extreme left, click just to the left of the
arrow and drag the bar to the right and make it smaller to unhide the tab
controls and the tabs. Do the tabs show in other workbooks?

"Dale" wrote in message
...
I went there and that option was already checked, I unchecked it, closed
and
reopened then rechecked it and still no tabs. Again I can go to another
machine that has 2007 on it and the tabs display there. Any other
thoughts?

"Wondering" wrote:

Office Button/Excel Options/Advanced/Display options for this workbook -
Check Show sheet tabs

"Dale" wrote in message
...
I have just installed Office 2007 and when I went to open one of my
older
spreadsheets none of the page tabs are showing. When I open the
spreadsheet
on another machine the tabs are still there.
How do I get page 2, 3 and so on to appear as tabs at the bottom?

Any suggestions are greatly appreciated

Thanks
Dale







Dale

Excel 2007 not showing tabs
 
No scroll bar appears on the worksheet I'm having problems with, that same
worksheet can be put on another workstation and it appears normally. On the
workstation that is having this issue I can open a few other spreadsheets
normally and a few of the other spreadsheets are having the same issue

"Wondering" wrote:

Another possiblity is that your scroll bar at the bottom of the worksheet
which is on the same line as the tabs is extended all the way to the left,
completely hiding the tabs and the tab controls. If the left-pointing arrow
on the scroll bar is at the extreme left, click just to the left of the
arrow and drag the bar to the right and make it smaller to unhide the tab
controls and the tabs. Do the tabs show in other workbooks?

"Dale" wrote in message
...
I went there and that option was already checked, I unchecked it, closed
and
reopened then rechecked it and still no tabs. Again I can go to another
machine that has 2007 on it and the tabs display there. Any other
thoughts?

"Wondering" wrote:

Office Button/Excel Options/Advanced/Display options for this workbook -
Check Show sheet tabs

"Dale" wrote in message
...
I have just installed Office 2007 and when I went to open one of my
older
spreadsheets none of the page tabs are showing. When I open the
spreadsheet
on another machine the tabs are still there.
How do I get page 2, 3 and so on to appear as tabs at the bottom?

Any suggestions are greatly appreciated

Thanks
Dale







Wondering[_2_]

Excel 2007 not showing tabs
 
You're saying some of the workbooks have tabs and scroll bars and some don't
on this particular workstation and yet all of the same workbooks have tabs
and scrollbars on the other workstations?

"Dale" wrote in message
...
No scroll bar appears on the worksheet I'm having problems with, that same
worksheet can be put on another workstation and it appears normally. On
the
workstation that is having this issue I can open a few other spreadsheets
normally and a few of the other spreadsheets are having the same issue




Dale

Excel 2007 not showing tabs
 
Yes that is correct, wish I could post screen shots in here.
The workstation in question will display this one worksheet with no scroll
bar and no tabs even though the options are checked in the worksheet to have
those displayed. I can put that worksheet on a thumbdrive go to another
workstation with 2007 installed, open it and the tabs and scrol bars are
there. At the workstaion in question I can open other worksheets and they
appear normally.
Is there a way to import the data from this worksheet to another excel
worksheet to see if when re creating the data it will then create the tabs?

Thanks
Dale

"Wondering" wrote:

You're saying some of the workbooks have tabs and scroll bars and some don't
on this particular workstation and yet all of the same workbooks have tabs
and scrollbars on the other workstations?

"Dale" wrote in message
...
No scroll bar appears on the worksheet I'm having problems with, that same
worksheet can be put on another workstation and it appears normally. On
the
workstation that is having this issue I can open a few other spreadsheets
normally and a few of the other spreadsheets are having the same issue






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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com