Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > Alphabetise spreadsheets in Excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Alphabetise spreadsheets in Excel

Reply to Message Icon

Name: luckypingudog
Date: December 1, 2004 at 14:32:37 Pacific
OS: WIN XP Pro SP2
CPU/Ram: 2GHZ 1GB
Comment:

I have an excel 2000 document with about 30 separate spreadsheets. I access the different sheets by clicking on the tabs towards the bottom of the screen.
Is it possible to alphabetically sort these tabs?

I'm not young enough to know everything.



Sponsored Link
Ads by Google

Response Number 1
Name: Bryco
Date: December 1, 2004 at 16:49:19 Pacific
Reply:

ASAP Utilites has that as one of the over 300 functions not found in Excel. It is free and pretty good to have around.

Sorting sheets is found under Sheets, Sort all sheets in alphabetical order.

Regards,
Bryan


0

Response Number 2
Name: MaHubbard
Date: December 2, 2004 at 08:31:25 Pacific
Reply:

The only way I know to put Excel spreadsheets into alphabetical order is to click and drag them into place.

I am using Office XP but am pretty sure I used to be able to do this with Excel 2000.

Simple - unless you are constantly changing the names of sheets.

Cheers.


0

Response Number 3
Name: luckypingudog
Date: December 3, 2004 at 16:19:37 Pacific
Reply:

Thanks guys for your ideas.
I tried ASAP but couldn't get it to install properly, so I think click and drag is the way to go.

I'm not young enough to know everything.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: Alphabetise spreadsheets in Excel
Can't change cell color in Excel www.computing.net/answers/office/cant-change-cell-color-in-excel/4723.html

Reverse rows in Excel 2003 www.computing.net/answers/office/reverse-rows-in-excel-2003/7798.html

In excel automatically Sorting a row by date www.computing.net/answers/office/in-excel-automatically-sorting-a-row-by-date/9133.html