![]() |
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 |
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 |
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 |
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 |
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 |
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 |
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 08:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com