The subject line may not be clear, but what I want to know is if there's an
option in Excel that aloows me to choose the arrangment of my spreadsheet
(either numerically or alphabetically). Can someone plese help me.

Yes. Look in HELP for Data/Sort

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=529436

I guess I should have told you, when you get the Sort dialogue box,
Choose Options and Select Left to Right rather than Top to Bottom.

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=529436

Okay, Sorry, ignore the last post (unless you want to sort columns vs
rows), I was just reading the another post & got my responses mixed
up....


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=529436

You need a VBA to sort your sheets alphabetically.

Sub SortALLSheets()
'sort sheets within a workbook in Excel 7 -- Bill Manville
'modified to sort all sheets instead of just worksheets
Dim iSheet As Integer, iBefore As Integer
For iSheet = 1 To ActiveWorkbook.Sheets.Count
Sheets(iSheet).Visible = True
For iBefore = 1 To iSheet - 1
If UCase(Sheets(iBefore).Name) UCase(Sheets(iSheet).Name) Then
ActiveWorkbook.Sheets(iSheet).Move
Befo=ActiveWorkbook.Sheets(iBefore)
Exit For
End If
Next iBefore
Next iSheet
End Sub

HTH

Gilles

"Kate" wrote in message
...
The subject line may not be clear, but what I want to know is if there's
an
option in Excel that aloows me to choose the arrangment of my spreadsheet
(either numerically or alphabetically). Can someone plese help me.

Sorry, you need to cut and paste from SUB to END SUB in your VBA editor: ALT
+ F11 and insert module in PERSONAL.XLS, that way the program shall be
available for all Excel files

Gilles
"Kate" wrote in message
...
The subject line may not be clear, but what I want to know is if there's
an
option in Excel that aloows me to choose the arrangment of my spreadsheet
(either numerically or alphabetically). Can someone plese help me.