ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I arrange worksheets alphabetically in Excel? (https://www.excelbanter.com/excel-worksheet-functions/125837-how-do-i-arrange-worksheets-alphabetically-excel.html)

Rosa

How do I arrange worksheets alphabetically in Excel?
 
How do I arrange worksheets alphabetically in Excel?

Dave Peterson

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

Jim Cone

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