I want to put all my movies that I have into a folder and then have them in
alphabetical order so they will be easy to find. I'm new to using any of
these programs. Just installed Office 2003 Basic.
Any help would be greatful, and please put in easy to understand
instructions, as I am slow understanding things.

Putting movie titles into a folder does not involve Excel.

Do you mean you want to list your movie titles in an Excel worksheet?

Type them into a column then select that column and DataSortAscending.


Gord Dibben MS Excel MVP

On Wed, 9 Jan 2008 09:11:03 -0800, Allan
wrote:

I want to put all my movies that I have into a folder and then have them in
alphabetical order so they will be easy to find. I'm new to using any of
these programs. Just installed Office 2003 Basic.
Any help would be greatful, and please put in easy to understand
instructions, as I am slow understanding things.

On Jan 9, 1:11*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Putting movie titles into a folder does not involve Excel.

Do you mean you want to list your movie titles in an Excel worksheet?

Type them into a column then select that column and DataSortAscending.

Gord Dibben *MS Excel MVP

On Wed, 9 Jan 2008 09:11:03 -0800, Allan
wrote:



I want to put all my movies that I have into a folder and then have them in
alphabetical order so they will be easy to find. I'm new to using any of
these programs. Just installed Office 2003 Basic.
* Any help would be greatful, and please put in easy to understand
instructions, as I am slow understanding things.- Hide quoted text -

- Show quoted text -
I'm having the same prolem. I want to sort movie titiles
alphabetically in Microsoft Excel, but movie titles that begin with
"the" are being sorted with the T's and I want them sorted as if the
title did not contain the "the". For instance I want the movie "The
Dirty Dozen" to be with movie titles beginning with D and not movie
titles beginning with T. Is there an way to do a sort such as this
without renaming the title without the "the" at the beginning??

bsp1913 wrote...
I want to put all my movies that I have into a folder and then have them in
alphabetical order so they will be easy to find. I'm new to using any of
these programs. Just installed Office 2003 Basic.
Any help would be greatful, and please put in easy to understand
instructions, as I am slow understanding things.- Hide quoted text -

I'm having the same prolem. I want to sort movie titiles
alphabetically in Microsoft Excel, but movie titles that begin with
"the" are being sorted with the T's and I want them sorted as if the
title did not contain the "the". For instance I want the movie "The
Dirty Dozen" to be with movie titles beginning with D and not movie
titles beginning with T. Is there an way to do a sort such as this
without renaming the title without the "the" at the beginning??

You will have to create a "helper column" for sorting
see "Sorting Titles" by Jim Cone
http://groups.google.com/group/micro...7f0b47bd354d4e


--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm