ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Tabs in alphabetical order (https://www.excelbanter.com/excel-worksheet-functions/127404-tabs-alphabetical-order.html)

exrailman

Tabs in alphabetical order
 
Hi Group,

When I have made a worksheet, with many tabs along the bottom, is there a
way in which I can then re-arrange the tabs into alphabetical order?

Many thanks

Jim.



Pete_UK

Tabs in alphabetical order
 
Hi Jim,

check out this link:

http://www.cpearson.com/excel/sortws.htm

Hope this helps.

Pete

exrailman wrote:

Hi Group,

When I have made a worksheet, with many tabs along the bottom, is there a
way in which I can then re-arrange the tabs into alphabetical order?

Many thanks

Jim.



ShaneDevenshire

Tabs in alphabetical order
 
Nothing built into XL. (Not in 2007 either)

You need a macro.

--
Cheers,
Shane Devenshire


"Pete_UK" wrote:

Hi Jim,

check out this link:

http://www.cpearson.com/excel/sortws.htm

Hope this helps.

Pete

exrailman wrote:

Hi Group,

When I have made a worksheet, with many tabs along the bottom, is there a
way in which I can then re-arrange the tabs into alphabetical order?

Many thanks

Jim.




Jim Cone

Tabs in alphabetical order
 
Jim,
The free Excel add-in "XL Extras" sorts sheets when you right-click a
sheet tab and choose sort.
It can also do other nice stuff.
Download from... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"exrailman"
wrote in message
Hi Group,
When I have made a worksheet, with many tabs along the bottom, is there a
way in which I can then re-arrange the tabs into alphabetical order?
Many thanks
Jim.



Jim Cone

Tabs in alphabetical order
 
Hi Shane,
During my "married period", a long time ago in another universe, I lived
almost next door to you in Lafayette, CA.
Regards,
Jim Cone


"ShaneDevenshire"

wrote in message
Hi Jim,
I'm just across the bay in Walnut Creek, Hi!
--
Cheers,
Shane Devenshire


"Jim Cone" wrote:
Jim,
The free Excel add-in "XL Extras" sorts sheets when you right-click a
sheet tab and choose sort.
It can also do other nice stuff.
Download from... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"exrailman"
wrote in message
Hi Group,
When I have made a worksheet, with many tabs along the bottom, is there a
way in which I can then re-arrange the tabs into alphabetical order?
Many thanks
Jim.




ShaneDevenshire

Tabs in alphabetical order
 
Hi Jim,

In my unmarried life, also many moon ago, I live in San Francisco from 1964
off and on till 1990.

--
Thanks,
Shane Devenshire


"Jim Cone" wrote:

Hi Shane,
During my "married period", a long time ago in another universe, I lived
almost next door to you in Lafayette, CA.
Regards,
Jim Cone


"ShaneDevenshire"

wrote in message
Hi Jim,
I'm just across the bay in Walnut Creek, Hi!
--
Cheers,
Shane Devenshire


"Jim Cone" wrote:
Jim,
The free Excel add-in "XL Extras" sorts sheets when you right-click a
sheet tab and choose sort.
It can also do other nice stuff.
Download from... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"exrailman"
wrote in message
Hi Group,
When I have made a worksheet, with many tabs along the bottom, is there a
way in which I can then re-arrange the tabs into alphabetical order?
Many thanks
Jim.






All times are GMT +1. The time now is 07:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com