How do I put movie titles in alphabetical order

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.
   
0
Allan (61)
1/9/2008 5:11:03 PM
excel.newusers 15348 articles. 2 followers. Follow

3 Replies
916 Views

Similar Articles

[PageSpeed] 51

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 Data>Sort>Ascending.


Gord Dibben  MS Excel MVP

On Wed, 9 Jan 2008 09:11:03 -0800, Allan <Allan@discussions.microsoft.com>
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.
>   

0
Gord
1/9/2008 6:11:32 PM
On Jan 9, 1:11=A0pm, 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 Data>Sort>Ascending.
>
> Gord Dibben =A0MS Excel MVP
>
> On Wed, 9 Jan 2008 09:11:03 -0800, Allan <Al...@discussions.microsoft.com>=

> 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.
> > =A0 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??
0
bsp1913 (1)
2/24/2008 1:11:55 AM
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/microsoft.public.excel.newusers/browse_frm/thread/caa500ca56c1091e/c57f0b47bd354d4e#c57f0b47bd354d4e


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

 

0
2/24/2008 2:12:40 AM
Reply:

Similar Artilces:

PUTTING NUMBERS IN A CELL
I AM TRYING TO ENTER A NUMBER THAT BEGINS WITH ZERO'S AFTER I ENTER IT THE ZERO'S DISAPPEAR, HOW DO I KEEP THEM IN Please turn off the CAPS Lock, more than two lines would be extremely difficult to read. Reading caps is annoying. Format the column as text, if the leading zero is important to you then it is an identification not a number. The default alignment for text is left aligned which is also better for most identification "numbers". Credit card numbers are 16 digits, are identification and can not be entered as numbers, ever, because Excel only retains 15 si...

alphabetize within a cell
if i have a list of letters in a cell, is it possible to alphabetize them? example: ADCB --> ABCD On Thu, 14 Feb 2008 12:31:05 -0800 (PST), hiflyinskiier@gmail.com wrote: >if i have a list of letters in a cell, is it possible to alphabetize >them? > >example: ADCB --> ABCD If your cells are contiguous and in a single column, here is a method that will sort each cell and write the result into the cell in the adjacent column. It can be easily modified for different situations. To enter this Sub, <alt><F11> opens the VB Editor. Ensure your project is highlighte...

Can you put white space outside a textbox?
When I put pictures in my publisher file, sometimes I want captions for the pictures. So I make a tiny textbox that I put under the picture, and type in a caption into that textbox. The problem is that I can make the picture have some space to left and right of it so that text doesn't crowd into the picture, but I can't do that with the textbox containing the caption. Is there any way to prevent outside text from crowding the borders of a textbox? You can move that textbox wherever you need. You don't need to leave space inside when you can steer clear of the textbox itself. ...

Add Path to Title Bar
How can I add path and file name to title bar of Excel 2002 workbook? Please let me know. Thanks in advance. Jack, Take a look at: Application.Caption ActiveWindow.Caption Application.Caption = ThisWorkbook.Path & "\" & ThisWorkbook.Name Activewindow.Caption = "" John Jack Mills wrote: > How can I add path and file name to title bar of Excel > 2002 workbook? Please let me know. Thanks in advance. John, I'm new enough to Excel 2002 that I haven't any idea where to start adding your suggested information to all of my workbooks. ...

Save record order in main table
Hi, I have a form which displays four field from a table. On the form I have 4 sort buttons which sorts the form based on the field selected. My table also has a field for a sequence number. Based on the sort order selected I would like the sequence number field for each record in the table to correspond to the record number shown on the form. In other words, based on the sort the first record shown on the form would get a sequence number of 1 in the table, the second record shown would get a 2, etc. Is this possible and if so could someone help with the code. Your help woul...

Where to put SQL statements in VC++ Application
I am wondering if putting all my SQL statements in the string table is a good idea. Is there a better place to store these statements?? Thanks in advance for any responses. Dominic Inline in the code, they arnt particually helpful to put in the string table. -- - Mark Randall http://zetech.swehli.com "Those people that think they know everything are a great annoyance to those of us who do" Isaac Asimov <dominicgualtieri@hotmail.com> wrote in message news:1129050897.519688.176820@g49g2000cwa.googlegroups.com... >I am wondering if putting all my SQL statements in...

"Purchase Order Processing setup information is missing or damaged" Error
Hi, I tried to Open the "Payment Document Setup" form or the "Payment Document User Preference" form from the "Setup" module of "Purchasing" then an error message "Payment Document Management Setup is missing or damaged" gets displayed. and when I tried to Open the "Receivings Transaction Entry" form from the "Transactions" module then an error message ""Purchase Order Processing setup information is missing or damaged" gets displayed. Go to Setup>Payment Document Setup, uncheck and then re-check ...

Put app and icon in task bar?
I have an MFC application that I want to be able to put in the task bar as a small icon and have it pop up the dialog when selected from the task bar. This app is intended to be run from the start up menu and be minimized in the task bar along with all the other start items... Pointers on how to please... By default app goes on the task bar. Do you mean system tray (that by default appears on the bottom right of the screen)? -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "ShipHead" <GoAway@SpamBoy.com> wrote in message news:#g1K8UgEFHA.2700@TK2MSFTNGP14.phx.gbl... > I...

outlook ka-put
After I installed the service pack updates for Microsoft XP, my Outlook has been uable to send or receive any email. I have gotten a few error messages: "unable to connect to network," "server found but did not respond." etc. What the heck do I do? ...

Search Open Order receipts
My customer requires customers to put a deposit on Orders. They receive these deposits on the Sales Transaction Entry window in the Amount Received field. This works fine but there is not an easy way (that I can find) to search for these receipts (by amount, by date, by customer name). Besides I only want to search receipts that are on open orders (orders not yet converted to invoices). Any ideas on how to accomplish the above? -- Japheth Nolt MCP Microsoft GP/SBF Specialist Landis Computer http://landiscomputer.com Japheth Nolt, You can search the Receipts th...

Title Column
Hi all. simple question.... how would i go about making column A title column so when i move along, say to column z i can still see th titles in column A. :confused -- jhome ----------------------------------------------------------------------- jhomer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2397 View this thread: http://www.excelforum.com/showthread.php?threadid=37596 Select column B Window>Freeze panes Does that help? Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: htt...

Where to put error handler code for "No current record" error?
Hello, to brighten the essence of my current problem I woud like to describe the situation from scratch. I use Acess 2007. I have two tables 'tblOrders' and 'tblOrderDetails' linked as ODBC tables from MS SQL 2000 Server. Both tables have primary keys: 'tblOrders' has 'orderId' primary key and 'tblOrderDetails' has a pair 'orderId' and 'itemId' as primary key. On server there is also a foreign key constraint defined on key 'orderId' between both tables. In access I have a main form 'frmOrders' bounded to 'tblOr...

Graph reverse order changes series order but not legend order
Hi, If I change the order of a graph in the axis properties the order o the series is reversed as well as the order of the data, but not th order of the legend. Is there any way to reverse the order of the grap and keep the series order synchronized with the legend order beside rebuilding the data set backwards? Thanks, Aaro -- Message posted from http://www.ExcelForum.com ...

I can't read titles
As soon as I installed Office:Mac Home and Student on my Apple I noticed that when on Safari all of the Titles/Headings were not readable. It's as if all the letters were placed right on top of each other. Please, can anyone help > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3283956105_10196180 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit On 1/23/08 3:36 PM, in article ee8a30e.-1@webcrossing.caR9absDaxw, "Jaclyn_H@officeformac.com" <...

GRID with title and records
Hi. Could you please advise me of what kind of grid should I use to have titles and records below. I need to have a "view"/grid where I have on product as title and below the suppliers for that product. The thing is that I must have to have access to the records in order to select one of the suppliers for product. Thanks, Marco ...

How can I reverse the order of a column of numbers . . . #2
I want to turn a long column of numbers upsidedown so that the last entries become the first vice versa. You could do this with a helper column. In a blank column next to the column you want to reverse: Type 1 in the first cell, 2 in the second cell. Then, select both cells and double-click on the Fill Handle to fill a series of increasing numbers. Then, Sort Desceding by the new column. When you are done, you can delete the helper column. tj "buckeye999" wrote: > I want to turn a long column of numbers upsidedown so that the last entries > become the first vice versa. ...

How do I put it back?
In Microsoft money 2003. Used to: When I put on my paycheck I would have a window pop up with seperate catagories, "taxes", "healthcare", ect. there were four of them. Now when I put them in I just get one "spit catagories" window. I don't know how I changed it or how to change it back. I can't even find any support that can/ will help me. If anyone knows Please let me know. I will be greatly indeted to you. thank You. Derek "Derek" <Derek@discussions.microsoft.com> wrote in message news:D9D38C7E-D837-4376-99D3-79C760EC4F85@mic...

how to put constraints in excel
how to put constraints in excel You need to be more specific in your question. Perhaps Data Validation, on the Data menu, will do what you want. This will allow users to enter only values in a range of numbers in a cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "structures" <structures@discussions.microsoft.com> wrote in message news:EFC87EE4-BC1A-4F88-9E35-0EB42F42881C@microsoft.com... > how to put constraints in excel ...

print multiple emails in specific order
Hi there, In Outlook 2003, is it possible to print multiple emails in a specified order as one consecutive item? That is, each email should NOT be on a separate page. Thanks! E. L. Brother ...

Put % in ( )
Dear all, Is it possible to format a cell to stay like it: ( -10% )? With this format (0%), the excel shows this - (10%) Thanks a lot!!! Andr=E9. Try this Custom Number Format: Select the cell(s) to be impacted From the Excel Main Menu: <format><cells><number tab> Category: Custom Type: (0%);(-0%);(0%) Click [OK] Those settings will display: 10% as (10%) -10% as (-10%) 0% as (0%) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) <gatarossi@ig.com.br> wrote in message news:4188b0ad-a272-455...

How do put a Logo on the Receipt
Is there anyway I acn put a logo on my Receipt. If I remember I simply copied out the file pos_symbol.gif in C:\Program Files\Microsoft Retail Management System\Store Operations\HTML\Images to get the size, and then renamed that file, uploaded one of my own. Chris "al" wrote: > Is there anyway I acn put a logo on my Receipt. that did not worked, can you be more detailed about it "Chris" wrote: > If I remember I simply copied out the file pos_symbol.gif in C:\Program > Files\Microsoft Retail Management System\Store Operations\HTML\Images to get > the ...

Title page header
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) How do I change the header on only the title page of a document? <Arthur_Lyons@officeformac.com> wrote: > > How do I change the header on only the title page of a document? You could make a section break after your title page. This should enable you to use different headers after the first page. Corentin -- --- Office:Mac MVP http://www.cortig.net/wordpress/ --- http://www.mvps.org - http://mvp.support.microsoft.com MVPs are not MS employees - Les MVP ne travaillen...

putting photos into autoshapes
I publish a newsletter for a charity and would like to improve and vary the presentation. How do I make a standard photo go into an oval or other autoshape? I have done it once but can't recreate it. I have windows XP, publisher 03 and works suite 04. My photos are usually JPEG. Select the shape, fill, fill effects, picture tab. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "christiredlady(removethis)@aol.com" <christiredlady(removethis)@aol.com@discussions.microsoft.com> wrote in message news:069B7725-3...

Force Close Manfuacturing Order(s)
I've got a handful of Manufacturing Orders that are complete and need to be closed. However, many of the items still have a quantity shortage on the picklist and therefore cannot be closed. The reason for this is that the client has asked for these to be closed as they are old and everything has been processed. So I'd like to just force it closed without having to fix the shortages (as they have already been accounted for). The message I am getting when I try to close is "You can't close this manufacturing order because there is a quantity shortage for at least one ...

Inserting More Than 1 Chart Title
Can anyone tell me if it is possible to insert more than 1 chart title, and if so how. Les. To add more text to a chart, select the chart, and type the text. As you type, you'll see the text in the formula bar. When you press the Enter key, a textbox will appear in the chart. You can drag this to a new location in the chart, and format it with the buttons on the formatting toolbar. Les wrote: > Can anyone tell me if it is possible to insert more than > 1 chart title, and if so how. > Les. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech...