Excel Family Tree Template

The Excel use is tremendous. It is not only limited to the business world but is also for personal use. For example, managing a personal financePersonal FinancePersonal Financing is a way of saving, investing, and growing an individual’s money. It can be for an individual or a family as a whole and requires some level of financial literacy such as tax laws, investment opportunities, etc.read more budget will also draw the family tree. We can draw a family tree template in Excel to track the family members. Going back to the family’s history, we can be “Genealogists.” To draw a family tree, you need to identify where to start. So, it has to start with the grandparents’ level.

How to Create a Family Tree Excel Template?

We can create a family tree in Excel by using two methods.

Method #1

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. Once the order is determined, the skill of drawing shapes needs some intelligence.

  • 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. Then, we must select the shape and draw, as shown below. Once the oval shape is drawn, insert the text in the oval box as “Grand Father” and “Grand Mother,” respectively. Then, select the connector line. Now, we must add a connector line between these two shapes. As per the family and how many children they have, we must draw ovals for each child of the grandfather and grandmother. Each child has a wife, so draw four more oval shapes with connectors. 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. We need to draw a connector line for your “Elder Brother,” “You,” and “Younger Sister” from here on.

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.

We cannot keep on drawing the shapes from the Insert tabInsert TabIn excel “INSERT” tab plays an important role in analyzing the data. Like all the other tabs in the ribbon INSERT tab offers its own features and tools. Under Insert Tab we have several other groups including tables, illustration, add-ins, charts, Power map, sparklines, filters, etc.read more. 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.

This article is a guide to the Family Tree Excel Template. We discussed making a family tree in Excel using shapes with examples and downloadable Excel templates. You may learn more about Excel from the following articles: –

  • Blank Invoice Excel TemplateFlowchart Examples ExcelTypes of Excel ChartsFind & Select in ExcelODD Function in Excel