Sorting in Excel

nisht · Mar 7th, 2002, 08:01 AM

I have written down following in excel row...

Sheet1
sheet3
sheet2
sheet10
sheet11
sheet12

now when i give sort command from excel .. excel sorts the items in following way...

sheet1
sheet10
sheet11
sheet12
sheet2
sheet3

I have written all charactes in lower case.

Actually the sorting should be in

sheet1
sheet2
sheet3
sheet10
sheet11
sheet12
sheet13

how should i overcome this problem

nishith desai

Anne Troy · Mar 7th, 2002, 08:13 AM

Then you need to name them that way:

sheet01
sheet02
sheet03
sheet10
sheet99

sheet001
sheet101
sheet358

lenze · Mar 7th, 2002, 08:21 AM

If this is a sort you use often, you might consider creating a custom sort list. See help file for info.

Mar 7th, 2002, 08:13 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Then you need to name them that way: sheet01 sheet02 sheet03 sheet10 sheet99 sheet001 sheet101 sheet358 __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 08:01 AM	#1
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	I have written down following in excel row... Sheet1 sheet3 sheet2 sheet10 sheet11 sheet12 now when i give sort command from excel .. excel sorts the items in following way... sheet1 sheet10 sheet11 sheet12 sheet2 sheet3 I have written all charactes in lower case. Actually the sorting should be in sheet1 sheet2 sheet3 sheet10 sheet11 sheet12 sheet13 how should i overcome this problem nishith desai

Mar 7th, 2002, 08:21 AM	#3
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	If this is a sort you use often, you might consider creating a custom sort list. See help file for info.