ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to retrieve tabs (https://www.excelbanter.com/new-users-excel/247081-how-retrieve-tabs.html)

Jorge Cervantes

How to retrieve tabs
 
Hi,
I am using Excel 07 (with WinXP Pro).
In an excel file (xlsx), there are many tabs.
Right now, I do not see any tabs at all.
Please advise me how to view tabs.
Jorge



Bernard Liengme[_3_]

How to retrieve tabs
 
If you are asking about the worksheet tabs:
A worksheet can be either fill the Excel workspace (the workbook name will
show on the title bar above the Ribbon), or as an object within the
workspace (the workbook name is displayed on the worksheet title bar below
the Ribbon)
In the second case the worksheet can be move around and resized. This can
result in the worksheet tabs being hidden. On the title bar below the Ribbon
click the middle of the three icons to the far right -the Restore/Maximize
button. Now the worksheet occupies all the workspaces and tabs are visible

OR, it the worksheet is maximized:
Office button (pretty round icon on left of Ribbon)
Excel Options button in bottom of dialog
Advance tab in left side
Down to "Display Options for this Workbook"
Third item down "Show Sheet Tabs"

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Jorge Cervantes" wrote in message
...
Hi,
I am using Excel 07 (with WinXP Pro).
In an excel file (xlsx), there are many tabs.
Right now, I do not see any tabs at all.
Please advise me how to view tabs.
Jorge





All times are GMT +1. The time now is 09:29 PM.

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