Can't see the tabs of my spreadsheet.

General discussion on MS Excel and its spreadsheets.

Can't see the tabs of my spreadsheet.

Postby kaie12 » Wed Nov 07, 2012 10:35 am

Hello friends, I'm having a strange problem in my excel spreadsheet. I can't see the tabs of my spreadsheet. It seems like they have been disappeared or deleted. As far as I know I didn't delete them. But I have no idea where they've gone. Please help me.
kaie12
 
Posts: 6
Joined: Tue Oct 30, 2012 11:39 am
Location: Canada

Re: Can't see the tabs of my spreadsheet.

Postby forforumsysinfo » Wed Nov 07, 2012 10:57 am

Are you sure that you haven't deleted the tabs from your excel sheet? If you haven't then they must have been disappeared or the file is damaged that's why the tabs are not appearing. First make sure that the tabs are still there or not? You can see all objects of an excel spreadsheet by Excel Visual Basic Editor.
N. Semm
Site Administrator
To know more about Data Recovery Services, visit SysInfoTools Data Recovery & Email Management Services.
forforumsysinfo
Site Admin
 
Posts: 158
Joined: Sun Mar 21, 2010 10:32 pm
Location: United Kingdom

Re: Can't see the tabs of my spreadsheet.

Postby kaie12 » Wed Nov 07, 2012 11:05 am

Thanks for your response. Yes, I'm absolutely sure, I haven't deleted them. Where I can find Excel Visual Basic Editor? I've never used it.
kaie12
 
Posts: 6
Joined: Tue Oct 30, 2012 11:39 am
Location: Canada

Re: Can't see the tabs of my spreadsheet.

Postby forforumsysinfo » Wed Nov 07, 2012 11:29 am

Follow the steps shown below:
  1. Open your MS Excel. Click on Office button.
  2. From the list, click on Excel Options button.
  3. Excel Options window will be appeared. Click on Popular. Check on the box of Show Developer tab in the Ribbon. Click on OK.
  4. Select the Developer tab from the tool bar. Then click on Visual basic option in the code group.
Excel Visual Basic Editor will be appeared. Now you can see all the objects of your spreadsheet. Hope this will be helpful.
Regards. :)
N. Semm
Site Administrator
To know more about Data Recovery Services, visit SysInfoTools Data Recovery & Email Management Services.
forforumsysinfo
Site Admin
 
Posts: 158
Joined: Sun Mar 21, 2010 10:32 pm
Location: United Kingdom

Re: Can't see the tabs of my spreadsheet.

Postby kaie12 » Wed Nov 07, 2012 11:37 am

Thanks a lot for this information. I can see all the tabs of my sheet. What shall I do now to have them back? Please help me.
kaie12
 
Posts: 6
Joined: Tue Oct 30, 2012 11:39 am
Location: Canada

Re: Can't see the tabs of my spreadsheet.

Postby forforumsysinfo » Wed Nov 07, 2012 11:46 am

Which version of MS Office are you using?
Regards. :)
N. Semm
Site Administrator
To know more about Data Recovery Services, visit SysInfoTools Data Recovery & Email Management Services.
forforumsysinfo
Site Admin
 
Posts: 158
Joined: Sun Mar 21, 2010 10:32 pm
Location: United Kingdom

Re: Can't see the tabs of my spreadsheet.

Postby kaie12 » Wed Nov 07, 2012 11:49 am

I'm using MS Office 2007.
kaie12
 
Posts: 6
Joined: Tue Oct 30, 2012 11:39 am
Location: Canada

Re: Can't see the tabs of my spreadsheet.

Postby forforumsysinfo » Wed Nov 07, 2012 12:57 pm

For MS Office 2003 users:
  1. Go to Tools > Options.
  2. A window will pop-up. View tab will be would be already selected there, if not then click on View.
  3. You will see on bottom right Sheets Tabs. If the box is unchecked, then check the box.
  4. Click on OK and all disappeared tabs will now be reappeared.

You need to save the file before you do anything else.
For MS Office 2007 users:
  1. Click on the Office button, which can be found on the top of left side.
  2. Click on Excel Options.
  3. In the advanced category, under display options for this workbook check the box show sheet tabs. Then click OK.
You need to save the file before you do anything else.
Hope this will be helpful.
Regards. :)
N. Semm
Site Administrator
To know more about Data Recovery Services, visit SysInfoTools Data Recovery & Email Management Services.
forforumsysinfo
Site Admin
 
Posts: 158
Joined: Sun Mar 21, 2010 10:32 pm
Location: United Kingdom

Re: Can't see the tabs of my spreadsheet.

Postby kaie12 » Wed Nov 07, 2012 1:02 pm

Thanks for this useful information. Thanks a lot. :)
kaie12
 
Posts: 6
Joined: Tue Oct 30, 2012 11:39 am
Location: Canada


Return to MS Excel- Help Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron