Sorting file names

[Gordon]

Up to now file namwes have been in alphabetical order. Now they are mixed.
How do I sort the file names into alphabetical order?

[Max]

"Gordon" wrote
> Up to now file names have been in alphabetical order.
> Now they are mixed.
> How do I sort the file names into alphabetical order?

If you mean worksheet names, try Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Gord Dibben]

If you mean filenames in a folder, perhaps you sorted them by "date" or
another means.

Try sorting by "name"


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 09:02:56 +0800, "Max" <[email protected]> wrote:

>"Gordon" wrote
>> Up to now file names have been in alphabetical order.
>> Now they are mixed.
>> How do I sort the file names into alphabetical order?
>
>If you mean worksheet names, try Chip Pearson's:
>http://www.cpearson.com/excel/sortws.htm
>--
>Rgds
>Max
>xl 97
>---
>Singapore, GMT+8
>xdemechanik
>http://savefile.com/projects/236895

[Gordon]

Thanks Gord (and also Max) - Yes I do mean file names in a folder. Perhaps I
am slow but can't see a sort tab/icon
Gordon

"Gord Dibben" wrote:

> If you mean filenames in a folder, perhaps you sorted them by "date" or
> another means.
>
> Try sorting by "name"
>
>
> Gord Dibben Excel MVP
>
> On Wed, 30 Nov 2005 09:02:56 +0800, "Max" <[email protected]> wrote:
>
> >"Gordon" wrote
> >> Up to now file names have been in alphabetical order.
> >> Now they are mixed.
> >> How do I sort the file names into alphabetical order?
> >
> >If you mean worksheet names, try Chip Pearson's:
> >http://www.cpearson.com/excel/sortws.htm
> >--
> >Rgds
> >Max
> >xl 97
> >---
> >Singapore, GMT+8
> >xdemechanik
> >http://savefile.com/projects/236895
>
>

[Max]

In Windows Explorer,
Click on the folder
Click View > Arrange Icons by
and you should see the droplist options to arrange by:
Name, Size, Type, Modified
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Gordon" <[email protected]> wrote in message
news:[email protected]...
> Thanks Gord (and also Max) - Yes I do mean file names in a folder. Perhaps
I
> am slow but can't see a sort tab/icon
> Gordon