software

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: www.excelforum.com/member.php...oamp;userid=26061
View this thread: 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: www.excelforum.com/member.php...oamp;userid=26061
View this thread: 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 amp; got my responses mixed
up....--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=529436You 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) gt; 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

quot;Katequot; gt; wrote in message
...
gt; The subject line may not be clear, but what I want to know is if there's
gt; an
gt; option in Excel that aloows me to choose the arrangment of my spreadsheet
gt; (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
quot;Katequot; gt; wrote in message
...
gt; The subject line may not be clear, but what I want to know is if there's
gt; an
gt; option in Excel that aloows me to choose the arrangment of my spreadsheet
gt; (either numerically or alphabetically). Can someone plese help me.