ExcelBanter - arranging sheets alphabatically

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - arranging sheets alphabatically (https://www.excelbanter.com/excel-worksheet-functions/203374-arranging-sheets-alphabatically.html)

Thakur Praveen Kumar

arranging sheets alphabatically

I have opened 54 sheets in a worksheet. Please tell me how to arrange them
alphabatically?

Sheeloo[_2_]

arranging sheets alphabatically

Praveen,

You need to use a macro to do that.

Visit http://www.ozgrid.com/VBA/sort-sheets.htm for a complete solution.

"Thakur Praveen Kumar" wrote:

I have opened 54 sheets in a worksheet. Please tell me how to arrange them
alphabatically?

Bob Phillips[_3_]

arranging sheets alphabatically

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

--
__________________________________
HTH

Bob

"Thakur Praveen Kumar" <Thakur Praveen
wrote in message ...
I have opened 54 sheets in a worksheet. Please tell me how to arrange them
alphabatically?

All times are GMT +1. The time now is 12:22 AM.