Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

disappearance worksheet listings

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

ResolvedVersion 2003

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

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

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

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

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

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

Anthony

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.