Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I arrange my tabs in alphabetical order all at once?
I have a different sheet for each person in an Excel workbook, and I have
named them in the format: "Last Name, First". Is there a way to arrange them all in alphabetical order at one time, or do I need to move each tab individually? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I arrange my tabs in alphabetical order all at once?
You could use a macro:
Zara wrote: I have a different sheet for each person in an Excel workbook, and I have named them in the format: "Last Name, First". Is there a way to arrange them all in alphabetical order at one time, or do I need to move each tab individually? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I arrange my tabs in alphabetical order all at once?
You could use a macro:
Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel...#sortallsheets If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Zara wrote: I have a different sheet for each person in an Excel workbook, and I have named them in the format: "Last Name, First". Is there a way to arrange them all in alphabetical order at one time, or do I need to move each tab individually? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I arrange my tabs in alphabetical order all at once?
There is no built-in function to do that.
However, the free Excel add-in "Excel Extras" will do it. Plus it can create a worksheet Table of Contents and do other nice stuff. Comes with install/use Word.doc file. Download from... http://www.realezsites.com/bus/primitivesoftware Jim Cone San Francisco, USA "Zara" wrote in message I have a different sheet for each person in an Excel workbook, and I have named them in the format: "Last Name, First". Is there a way to arrange them all in alphabetical order at one time, or do I need to move each tab individually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i re-sort multiple worksheets into alphabetical order | Excel Discussion (Misc queries) | |||
How do I arrange worksheet tabs In alpha order | Excel Worksheet Functions | |||
How do I arrange sheets in alphabetical order? | Excel Discussion (Misc queries) | |||
How do I arrange sheets in alphabetical order? | Excel Discussion (Misc queries) | |||
how do i arrange column A (last name) in alphabetical order? t. | Excel Discussion (Misc queries) |