Create A Nine-Generation Pedigree Family Tree In Google Sheets

A nine-generation tree goes all the way up to 256 great-great-great-great-great-great-grandparents. Our family tree layout in Google Sheets prints across multiple portrait pages that can be taped together. If you’re too busy for the sixteen steps in this tutorial, jump down to the end to grab our “done for you” Google Sheets template bundle. Table of Contents The 9-Generation Pedigree Tree … Read more

Create A Large Ten-Generation Family Tree In Google Sheets

This tutorial shows you how to create a very large family tree in Google Sheets. A 10-generation tree goes back to 512 great-great-great-great-great-great-great-grandparents. This version prints across three A4 portrait pages wide and eight pages deep. If you’re too busy for the sixteen steps in this tutorial, jump down to the end to grab our “done for you” Google Sheets template … Read more

How To Create A Five-Generation Family Tree In Google Sheets

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

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

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

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

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

Create An 8-Generation Pedigree Family Tree In Excel (Tutorial)

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

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