![]() |
How do I arrange worksheets alphabetically in Excel?
How do I arrange worksheets alphabetically in Excel?
|
How do I arrange worksheets alphabetically in Excel?
You can click and drag them by the tabs and move them to their rightful
locations--or you could run 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 Rosa wrote: How do I arrange worksheets alphabetically in Excel? -- Dave Peterson |
How do I arrange worksheets alphabetically in Excel?
Drag each sheet to the position desired.
or Use VBA code to do it. Chip Pearson has some here... http://www.cpearson.com/excel/sortws.htm or The free Excel add-in XL Extras will sort sheets ascending or descending plus do some other nice stuff. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Rosa" wrote in message How do I arrange worksheets alphabetically in Excel? |
All times are GMT +1. The time now is 12:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com