Thanks for reviewing and explaining how to use this template. I created a 4 generation family tree in the same way as the example. You pointed out a few short comings and here are a few more with my solutions. Full names and years wont fit in the boxes. I changed the spreadsheet settings to "Show row and column headings". Now I can change the row height until the text fits and also set Word Wrap. Yes its a nuisance but if you have to run "Create Family Tree" you have to make the changes all over again. With some names this might chop up them up, then you might have to change the relevant column width. I would not reduce the font size as it makes printed versions harder to read as the tree gets wider. I had to change the tree page to Landscape each time I ran "Create Family Tree". Perhaps some VB proficient person would make the code changes to remove these chores (i.e. unless there is Microsoft embargo). Or record your own macro to make the changes. I don't like the drop-down connectors for people who are married or partnered, I would prefer a horizontal connector. I would compliment the template creator as it is quite a reasonable piece of work. Hope this is helpful.
No, unfortunately not with the Microsoft template. Check out my channel for videos where I show how to prepare your own template for different numbers of generations.
Is there non pedigree one? Looking for a template that have multiple person included. all if not most of your uncles/aunties, grandparents siblings too. That automatically Arranges the layout.
The excel templates works fine for what I use it for - so quick and easy. However, I keep getting errors on it and requires de-bugging - I have no idea how to do this? Any tips? "Runtime error 1004"
I also encountered errors with the generator. I think the problem is that the code is old. Unless Microsoft update it, there's nothing really that can be done.
No, this only works for 4 generations. However, we have a tutorial for those who want to create larger trees in Excel - here's the link: th-cam.com/video/lMQ5k09i9Wo/w-d-xo.html
Not what I was looking for but quite informative and well presented.
Great explanation thanks. Have you found a family tree template that allows you to enter birthdate and location per family member? TIA
Thanks for reviewing and explaining how to use this template.
I created a 4 generation family tree in the same way as the example.
You pointed out a few short comings and here are a few more with my solutions.
Full names and years wont fit in the boxes. I changed the spreadsheet settings to "Show row and column headings". Now I can change the row height until the text fits and also set Word Wrap. Yes its a nuisance but if you have to run "Create Family Tree" you have to make the changes all over again. With some names this might chop up them up, then you might have to change the relevant column width.
I would not reduce the font size as it makes printed versions harder to read as the tree gets wider.
I had to change the tree page to Landscape each time I ran "Create Family Tree".
Perhaps some VB proficient person would make the code changes to remove these chores (i.e. unless there is Microsoft embargo). Or record your own macro to make the changes.
I don't like the drop-down connectors for people who are married or partnered, I would prefer a horizontal connector.
I would compliment the template creator as it is quite a reasonable piece of work.
Hope this is helpful.
Than you for your helpful tips there!
How i want to get this template.. In my excel dont have it
Is it possible to add one more generation?
No, unfortunately not with the Microsoft template. Check out my channel for videos where I show how to prepare your own template for different numbers of generations.
Is there non pedigree one?
Looking for a template that have multiple person included. all if not most of your uncles/aunties, grandparents siblings too.
That automatically Arranges the layout.
You're looking for a vertical layout, which is only really suitable for a few generations in a spreadsheet.
The last family tree only supports one child per couple?
The excel templates works fine for what I use it for - so quick and easy. However, I keep getting errors on it and requires de-bugging - I have no idea how to do this? Any tips? "Runtime error 1004"
I also encountered errors with the generator. I think the problem is that the code is old. Unless Microsoft update it, there's nothing really that can be done.
My family have 16 generation. Can I use it?
No, this only works for 4 generations.
However, we have a tutorial for those who want to create larger trees in Excel - here's the link:
th-cam.com/video/lMQ5k09i9Wo/w-d-xo.html
Good video, instead of changing font size just wrap the text in the cell....no?
Yes you can @Tanko3691 or alternatively press + between first name and family name
Looks like a pain. Lol.