Results 1 to 4 of 4

Thread: Tabs missing in Excel worksheets

  1. #1
    Join Date
    Jun 2009
    Posts
    230

    Tabs missing in Excel worksheets

    I had a query about Microsoft Excel 2003. I have a ready workbook, when i opened it today, i found the tabs that displays at the bottom of the worksheet like sheet 1, sheet 2, etc.. is missing from my workbook. i than opened another workbook to see, is it there but i cant see it in any of the excel file on my system. How can i get this tabs back?

  2. #2
    Join Date
    May 2008
    Posts
    3,316

    Re: Tabs missing in Excel worksheets

    I have also faced this issue sometime with my excel worksheet. This might be because you may have large 'restored' sheet on a small screen..There should be two X's in the upper right corner of the screen, one red for excel and one black for the worksheet. Use these controls and make sure the worksheet is "maximized" in the window of excel. Or try this steps:- click 'Tools' menu, 'Options' option then 'View' tab. ensure that the 'Sheet tabs' option is selected. click OK. Thats it..

  3. #3
    Join Date
    May 2008
    Posts
    5,812

    Re: Tabs missing in Excel worksheets

    i don't think it should be with every workbook because when we make changes, may be accidentally, the setting stays with the workbook. Anyways try to resolve it from Options, View tab, and check Worksheet tabs. Or Go to Tools / Options / View. Under "Windows Options" make sure "Sheet Tabs" is clicked. Click Ok. You will now have sheet tabs at the bottom of your workbook. You can also modify the color palette on the menu Tools->Options->Color tab. The Modify button lets you personalize the selected color, and that color will be available in the workbook, so you can use it on your worksheet tabs.

  4. #4
    Join Date
    Feb 2009
    Posts
    673

    Re: Tabs missing in Excel worksheets

    I was also facing this problem in of my my workbook but i fixed it simply. heres what you can try to fix this: Under options->Advanced->Scroll down to Display options for this workbook.

Similar Threads

  1. Replies: 8
    Last Post: 04-12-2011, 11:24 AM
  2. cannot tab between worksheets in Excel 2007
    By MartinaMiranda in forum Windows Software
    Replies: 5
    Last Post: 06-04-2011, 08:43 PM
  3. Compare two Excel Worksheets on Mac
    By Claudius in forum Windows Software
    Replies: 2
    Last Post: 10-06-2009, 10:46 PM
  4. What is Workbook and Worksheets in Excel
    By Xylina in forum Windows Software
    Replies: 3
    Last Post: 06-06-2009, 07:13 PM
  5. Merging Excel worksheets
    By Alexxx in forum Tips & Tweaks
    Replies: 3
    Last Post: 03-03-2009, 08:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,714,054,224.54770 seconds with 16 queries