disappearance worksheet listings
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Disappearance of the worksheet listings at the bottom of the wor

Disappearance of the worksheet listings at the bottom of the wor

resolvedResolved · High Priority · Version 2003

replyReply Mon 26 Apr 2010, 11:50Delegate Dee said...

Dee has attended:
Excel Advanced course
Excel Intermediate course

Disappearance of the worksheet listings at the bottom of the wor

Hi,

I've done something terribly wrong somewhere. I am working in a workbook with multiple worksheets. The listing of the worksheets, which is at the bottom so that I can move between worksheets, is gone. How can I get it back?

Cheers,

Dee

For upcoming training course dates see: Pricing & availability

replyReply Mon 26 Apr 2010, 13:04Trainer Anthony said...

RE: Disappearance of the worksheet listings at the bottom of the

Hi Dee, thanks for your query. On the Tools menu, click Options.
Then on the View tab, under Window options, make sure the Sheet tabs check box is ticked. That should bring them back.

Hope this helps,

Anthony

replyReply Mon 26 Apr 2010, 13:09Delegate Dee said...

RE: Disappearance of the worksheet listings at the bottom of the

Hi Anthony,

I looked at that and it was checked. I un-checked it, checked it again, but there are still no tabs at the bottom of the sheet. Any other ideas?

Dee

replyReply Mon 26 Apr 2010, 13:17Delegate Dee said...

RE: Disappearance of the worksheet listings at the bottom of the

I've got them back! Whew! There was a little bar at the bottom of where the tabs are, on the very left-hand side. When I moved that, it slid across where I could see the tabs. I must have tried to move the bar that I use to isolate the first two columns (forgot the name of that!), but grabbed the one for the tabs instead.

Thanks for the help. I didn't know about that bit in the tools section.

Dee

replyReply Mon 26 Apr 2010, 13:52Trainer Anthony said...

RE: Disappearance of the worksheet listings at the bottom of the

No problem, Dee. All's well that end's well!

Anthony

 

Please browse our web site to find out more about
excel consultant and other Microsoft training courses.

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard