| 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) | |||
Hybrid Mode
