Microsoft provides one family tree template for Excel. It’s quite limited. But if you only need a tree that goes up to your eight great-grandparents, then it’s pretty good. I find it easy to edit the name, date, and photo details. This article has some quick tips on setting up your tree. The main drawback … Read more

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

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

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

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

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

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