This is a step-by-step guide to creating a family tree in Google Sheets. This tree goes back five generations to great-great-grandparents. It fits on a single printed page. You can leave out the last level for a four-generation tree. If you’re too busy for the fifteen steps in this tutorial, jump down to the end to grab our “done for … Read more
A ten-generation family tree goes back to 512 great-great-great-great-great-great-great-grandparents. This tutorial shows you how to create this very large tree in Microsoft Excel. Our version prints across twenty-four portrait pages arranged as three pages wide and eight pages deep. The printed pages can be taped together to put up on a wall as a single … Read more
A nine-generation family tree goes back to 256 great-great-great-great-great-great-grandparents. This tutorial shows you how to create this large tree in Microsoft Excel. Our version prints across twelve portrait pages arranged as three pages wide and four pages deep. The printed pages can be easily taped together to put up on a wall as a single … Read more
An eight-generation family tree goes back to 128 great-great-great-great-great-grandparents. This tutorial shows you how to create one in Microsoft Excel that prints across four portrait pages. The printed pages can be easily taped together to put up on a wall as a single display. If you’re too busy for the eighteen steps in this tutorial, jump … Read more
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