Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Microsoft Office & spreadsheets

May 15, 2005 10:09PM PDT

Have Windows XP, with SP2. Have Microsoft Works/Word 2000. No working knowledge of Microsoft Office. Am researching family tree, and have started a spreadsheet of all info from birth, marr., death certs.(now into hundreds).

Problem is, I want to sort all columns in s/s, not just two, which seems to be case with Works. For example, can sort surname,(column A, or Christian name
(column B), but no other columns.

Want to investigate pattern, within branches of family. For example, would like to know, which individuals with name Smith, were born, married or died at Acacia Avenue. This list would, ideally, be in chronological order. Will Microsoft Office, or any other software let me check this out. The more columns I can sort at one time would be ideal.

Hope someone can help.

Discussion is locked

- Collapse -
Re: Excel
May 16, 2005 8:24AM PDT

With Excel 2000 (spreadsheet) you can sort a 'database' on three columns, and filter on values. So the specific example you name could be done.

But for this data processing purposes I would advocate database software like MS Access, or - maybe even better - dedicated software like the programs found with http://www.google.com/search?q=family+tree+software and comparable searches. I don't have any experience with that kind of software myself, however, so I can't recommend anything. Maybe try another forum, or do some research yourself.

Kees

- Collapse -
Spreadsheets
May 17, 2005 6:24AM PDT

Thanks for the info. Family Tree software is not a problem, as I have one which suits me fine.

I had hoped that by sorting more than just a couple of columns I might have built up some kind of social history, regarding residence etc

Thanks again.