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.
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
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
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....
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
"Kate" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks