Family Tree in Excel Template

Family tree is a chart representing the family members’ relation. It is also called as pedigree chart.

Excel is not only used to manage personal finance budget but we can also use Excel to create family tree template. To draw a family tree, we need to identify where to start. So, in this article, we will learn how to create family tree template in excel starting with the grandparents’ level.

Method #1

The following are the steps for the first method:

1. To draw the first family member, we must go to the “Insert” tab. Then, from “Illustrations,” go-to “Shapes” and draw two oval-shaped shapes.

2. Then, we must select the shape and draw, as shown below.

3. Once the oval shape is drawn, insert the text in the oval box as “Grand Father” and “Grand Mother,” respectively.

4. Then, select the connector line.

5. Now, we must add a connector line between these two shapes.

6. As per the family and how many children they have, we must draw ovals for each child of the grandfather and grandmother.

7. Each child has a wife, so draw four more oval shapes with connectors.

8. Out of four kids, the grandmother and grandfather have three boys and one girl as their kids. So from here on, we will concentrate solely on the family.

Suppose you are the child of “Kid 2,” then draw branches in front of “Kid 2.” Based on the number of kids your parents have. For example, assume your parents have 3 kids, then draw three oval shapes in front of “Kid 2,” i.e., your parents.

9. We need to draw a connector line for your “Elder Brother,” “You,” and “Younger Sister” from here on.

Method #2 – Create a Family Tree using the Copy-Paste Method

When we are drawing the family tree, the first step is to decide on the hierarchy of the family.

We cannot keep on drawing the shapes from the Insert tab. Once the shape is drawn, we can replicate the same shape for all the other shapes. So we must go back to the “Insert” tab whenever we are required to draw the shapes.

One way of replicating the same shape is traditional copying and pasting.

But we have another technique that is best suited for us: Select the shape, hold the “Ctrl” key and drag the shape with a left click of the mouse. As a result, we can get the shape replica.

A similar technique can also be employed to draw connector lines.

The next thing we need to learn is the alignment of shapes. For example, after drawing four shapes for four kids of “Grand Father” and “Grand Mother,” in the above steps, we may illustrate them like this.

As we can see, those shapes are not in order. Arranging them with the mouse is almost impossible with perfection, so how do we align these shapes in order?

First, we must select all the shapes at once. Then, hold the “Shift” key and left-click on the shapes we want to set to choose all the shapes.

Once the shapes are selected, we must go to “FORMAT” > “Arrange” > “Align.”

Click on the ” Align ” drop-down list and select “Align Left.”

As soon as we click on “Align Left,” we can see all the shapes are aligned properly from the left view.

Now, the shapes are aligned properly from the left side. Now, we need to align them vertically. For this, by selecting the shapes under “Align,” we must choose “Distribute Vertically.”

Now, the shapes are placed perfectly.

Like this, we can use shape and alignment options to set the placement of the shapes flawlessly.

• Apart from managing, analyzing data, we can use Excel to create family tree.
• The Family Tree chart (pedigree chart) can be created from grandparents level in Excel.
• We can easily align the shapes used in the family tree template in excel.