Possible to arrange spreadsheet by either name or date?

[Guest]

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.

 

[gjcase]

Yes. Look in HELP for Data/Sort

---GJC

 

[gjcase]

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.

---GJ

 

[gjcase]

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....

 

[Gilles Desjardins]

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
Before:=ActiveWorkbook.Sheets(iBefore)
Exit For
End If
Next iBefore
Next iSheet
End Sub

HTH

Gilles

 

[Gilles Desjardins]

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