Excel spreadsheet for organising data

[estiman]

Hi all,

Just seen the request. I can't attach an example of what you can do. So, send me a pm with contact details and I'll forward a 'template'.
It's very flexible - play with it to meet your needs. I colour code to make it easier to see things and the line connections help a lot if you are following something through. Obviously I use separate sheets within the workbook for each branch of the family.

[estiman]

I've used excel for family tree but I'm now curious as to how to do the line with arrow which goes from one person to another to show their relationship?

Annie

Just activate the drawing toolbar. Select the line option (you can choose a colour), click where you want to start and drag to the destination. The 'handles' at each end enable you to fine tune. I find this invaluable for following through and cross-referencing.

[Mcapper]

Hi estiman, thanks for your message. I am unable to reply to it. My email address is mcapper@btopenworld.com

[jess5athome]

Hi estiman, thanks for your message. I am unable to reply to it. My email address is mcapper@btopenworld.com

Hi Mcapper, that will be because you need to make at least 3 posts before the PM is allowed, just reply to this and that should enable you to use it.
You need to edit your post to remove your email address as well, this is just one of the guidelines to prevent spam emails etc.

Regards
Frank.

[Rosinish]

I've used excel for family tree but I'm now curious as to how to do the line with arrow which goes from one person to another to show their relationship?

Just activate the drawing toolbar. Select the line option (you can choose a colour), click where you want to start and drag to the destination. The 'handles' at each end enable you to fine tune. I find this invaluable for following through and cross-referencing.

Thanks estiman for your reply although I've yet to try it (new laptop & still finding my way round) & have only just downloaded excel to it.

Very helpful for others too.

Annie

[gerry_unicorn]

Hello estiman, I am really interested in obtaining your excel spreadsheet. I have tried for 5 years to try and create one and saw yours and this is what I have been looking for. I would appreciate it if it is at all possible.
Thank you.

(*) Moderator Comment: e-mail removed in accordance with RootsChat policy,
to avoid spamming and other abuses.
Please use the Personal Message (PM) system for exchanging personal data.

[estiman]

Sent you a PM

[JACK GEE]

I use EXCEL for all of my trees.
I run a large number of trees and so easy to swap material between them.

cheers Jack Gee