How To Use The Excel Family Tree Generator Template

The Excel Family Tree Generator Template uses a format that won’t suit many hobby genealogists. It is designed to work downward from one pair of grandparents. The tree can include their children, grandchildren, and great-grandchildren. The default format has only enough room to display first names. I’ll show you how to make the display work … Read more

Create A 7-Generation Pedigree Family Tree In Excel (Tutorial)

A seven-generation family tree goes back to sixty-four great-great-great-great-grandparents. Can you really squeeze it onto a single printed sheet in Excel? Yes you can! After a lot of experimentation, I’ve come up with the best format that displays and prints clearly. If you’re too busy for the twenty-one steps in this tutorial, jump down to the … Read more

Create A 6-Generation Pedigree Family Tree In Excel (Tutorial)

This tutorial walks step-by-step through creating a six-generation pedigree family tree in Microsoft Excel. A six-generation tree goes back to thirty-two great-great-great-grandparents. The challenge is how to get six generations to fit on a single printed page. The solution is to use the pedigree layout. Even with the pedigree layout, it’s a bit of a … Read more

Create A 5-Generation Pedigree Family Tree In Excel (Tutorial)

This tutorial walks step-by-step through creating a five-generation pedigree family tree in Microsoft Excel. A five-generation tree goes back to sixteen great-great-grandparents. The challenge is how to get five generations to fit on a single printed page. The solution is to use the pedigree layout. If you’re too busy for the twenty steps in this … Read more

Create A 4-Generation Vertical Family Tree In Excel (Tutorial)

This tutorial takes you step-by-step through creating a four-generation vertical family tree in Microsoft Excel. A four-generation tree goes back to eight great-grandparents. The challenge is how to get the details of eight people to fit across a single printed page. Sure, you can use a tiny font. But a family tree should be easy … Read more

Create A Simple 3-Generation Family Tree In Excel (Tutorial)

This tutorial takes you step-by-step through creating a simple three-generation family tree in Microsoft Excel. This type of tree is a great project for school or as a gift from children to grandparents. Our tips and tricks will help you avoid fiddling endlessly with dragging lines and positioning pictures in Excel. If you want more … Read more