Sorting dates for research

%3CLINGO-SUB%20id%3D%22lingo-sub-2321065%22%20slang%3D%22en-US%22%3ESorting%20dates%20for%20research%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2321065%22%20slang%3D%22en-US%22%3EHi!%3CBR%20%2F%3ESo%20I'm%20working%20on%20this%20research-project%20involving%20a%20large%20number%20of%20newspaper-articles%20and%20i'm%20trying%20to%20sort%20them%20by%20date.%20I%20put%20the%20entries%20as%20DATE%20-%20NAME%20OF%20PAPER%20-%20PAGE%20%23%20-%20TITLE%20-%20SUMMARY%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20here's%20my%20problem%3A%3CBR%20%2F%3EI%20did%20a%20control%20test%20in%20which%20I%20added%20the%20entries%20in%20random%20order%2C%20and%20then%20I%20tried%20to%20have%20Excel%20sort%20them%20by%20date.%20But%20when%20I%20did%20that%2C%20the%20dates%20got%20organized%20but%20not%20the%20rest%20of%20the%20entries%2C%20so%20now%20everything%20is%20mixed.%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20do%20i%20avoid%20this%20problem%3F%3CBR%20%2F%3E%3CBR%20%2F%3ENB%3A%20some%20of%20these%20test-entries%20were%20from%20clippings%20without%20dates%20(was%20gonna%20add%20those%20later)%20and%20so%20i%20just%20put%20an%20X%20in%20the%20date-column%2C%20maybe%20that%20added%20to%20the%20problem%2C%20should%20i%20just%20leave%20those%20blank%20until%20i%20find%20their%20dates%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2321065%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2321162%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20dates%20for%20research%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2321162%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1044473%22%20target%3D%22_blank%22%3E%40Scot94%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20you%20sort%2C%20do%20%3CSTRONG%3Enot%3C%2FSTRONG%3E%20select%20just%20the%20column%20with%20the%20dates.%20Either%20click%20in%20a%20cell%20in%20the%20date%20column%2C%20or%20select%20the%20entire%20range%20and%20use%20the%20tab%20key%20to%20make%20a%20cell%20in%20the%20date%20column%20the%20active%20cell%20within%20the%20selection.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi!
So I'm working on this research-project involving a large number of newspaper-articles and i'm trying to sort them by date. I put the entries as DATE - NAME OF PAPER - PAGE # - TITLE - SUMMARY

So here's my problem:
I did a control test in which I added the entries in random order, and then I tried to have Excel sort them by date. But when I did that, the dates got organized but not the rest of the entries, so now everything is mixed.

How do i avoid this problem?

NB: some of these test-entries were from clippings without dates (was gonna add those later) and so i just put an X in the date-column, maybe that added to the problem, should i just leave those blank until i find their dates?
1 Reply

@Scot94 

When you sort, do not select just the column with the dates. Either click in a cell in the date column, or select the entire range and use the tab key to make a cell in the date column the active cell within the selection.