Sorting dates for research

Copper Contributor
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.