MS Excel 2003 usage (Sorting Worksheets)

[Djinni]

Started a "new" temp job today, and they got me working on a Excel workbook. Problem is it has like 500 worksheets and they are in no form of order at all... IS there any way I can sort these alphanumerically (the worksheets not the data in them) that won't take over an hour?

The data isn't "linked" each sheet can be treated as a discrete unit.

[Sephiracle]

Data, Sort.

/thread

[Djinni]

Data, Sort.

/thread

And if that worked :P I wouldn't have bothered posting lol....

Again.

I want to sort the WORKSHEETS. NOT the data in them. (IE organise those tabs that usually appear at the bottom of your well worksheet. Usually Labelled Sheet1, Sheet2, Sheet3 etc...)

[Sephiracle]

Oh sorry, for some reason I thought you meant the data....I need to go home, been a long day. -_-

I don't think you can but you could try here: http://www.ozgrid.com/forum/showthre...t=67446&page=1

They have some index thing you can make and that may make it a bit easier to navigate.

Also if you right click the arrows down there you can get a vertical list of them.

And whoever put 500 sheets in a excel book needs a fist to the face.

[Djinni]

Oh sorry, for some reason I thought you meant the data....I need to go home, been a long day. -_-

I don't think you can but you could try here: http://www.ozgrid.com/forum/showthre...t=67446&page=1

They have some index thing you can make and that may make it a bit easier to navigate.

Also if you right click the arrows down there you can get a vertical list of them.

And whoever put 500 sheets in a excel book needs a fist to the face.

Yeah well... the damage is done