Excel help

[meeja]

When working with an ever-expanding workbook, is it possible to sort the worksheet tabs into alphabetical order?

[BliarOut]

Right click the tab and select move/copy.

[Big Al.]

Don't think so, but you can drag and drop!

[meeja]

That doesn't allow you to sort them alphabetically though, does it?

We have a workbook with around 50 worksheets, and although when the workbook was created, the sheets were entered alphabetically, murphy's law says sooner or later we will need to have a new sheet, and the tabs will no longer be alphabetical.... the new sheet will be at the extreme right.

I'm just looking for an easy way for users to be able to find the worksheet they need quickly and easily.

[meeja]

Big Al. said:

Don't think so, but you can drag and drop!

Damn, I was hoping that wasn't the answer!

[Raify]

meeja said:

That doesn't allow you to sort them alphabetically though, does it?

It does, just not automatically. You'll have to drag and drop the worksheets.

[meeja]

Raify said:

meeja said: That doesn't allow you to sort them alphabetically though, does it? It does, just not automatically. You'll have to drag and drop the worksheets.

Cheers.... that isn't so bad after all!

I had visions of cutting and pasting!

[Alex]

Try this, not tried it myself so can't say if it works!

[chim_knee]

You could try this


>> Edited by chim_knee on Monday 14th March 16:36

[Jay-Aim]

meeja said:

I'm just looking for an easy way for users to be able to find the worksheet they need quickly and easily.

if you have that many, you may find adding a front one and placing hyperlinks to all others a quicker route for the users

[atom290]

I could write you a macro to do it if you like?

That would do it very simply!!

[GMan 2112]

Does this help

www.exceltip.com/st/Sorting_Sheets_in_Ascending_Order/669.html

[meeja]

Thanks for the help guys.... all sorted now!

(We used one of the VB code links, and wrote a macro)

Cheers all!