✦Template Printable Ideas Insights

How to Create a Family Tree in Excel

By

Ever wondered about your family's history but found the idea of tracing it back intimidating? It's time to make it manageable and even fun with Excel. This guide will walk you through the process of creating a family tree in Microsoft Excel, step by step.

Before we dive in, ensure you have Excel installed and open to a new workbook. Here's how you can start: on the 'Home' tab, click 'Cells' in the 'Editing' group, then 'Format as Table'. This will transform your raw data into a manageable table.

Setting Up Your Family Tree

For an effective family tree, you'll need specific columns: 'First Name', 'Last Name', 'Birth Year', 'Death Year', and 'Parent' (for mothers and fathers separately). You can add more columns for detailed information later.

How to Make a FAMILY TREE in EXCEL (Using Free Templates or from Scratch)
How to Make a FAMILY TREE in EXCEL (Using Free Templates or from Scratch)
How To Make a Family Tree in Microsoft Excel (Plus Tips) Family Tree Templates, Family Tree Spreadsheet Template, How To Make A Family Tree On Powerpoint, Family Tree Spreadsheet, How To Make A Family Tree On Computer, Genealogy Excel Template, Family Tree Template Google Sheets, Family Tree Excel, How To Create Tree Diagrams In Excel
How To Make a Family Tree in Microsoft Excel (Plus Tips) Family Tree Templates, Family Tree Spreadsheet Template, How To Make A Family Tree On Powerpoint, Family Tree Spreadsheet, How To Make A Family Tree On Computer, Genealogy Excel Template, Family Tree Template Google Sheets, Family Tree Excel, How To Create Tree Diagrams In Excel
How to Create a Family Tree Chart in Excel, Word, Numbers, Pages, PDF - Tutorial
How to Create a Family Tree Chart in Excel, Word, Numbers, Pages, PDF - Tutorial

Starting with your immediate family, fill in the information correctly. For instance, if you're making a family tree for yourself, your name would go first, followed by your parents' and so on.

Entering Data

Start by entering your full name, birth year, and the columns for your parents. If you know their death years, fill those in too. For the 'Parent' columns, just enter 'Self' for both.

How to Make a FAMILY TREE in EXCEL (Using Free Templates or from Scratch)
How to Make a FAMILY TREE in EXCEL (Using Free Templates or from Scratch)
How to Make a Family Tree in Excel | Edrawmax Online
How to Make a Family Tree in Excel | Edrawmax Online
HOW TO MAKE A FAMILY TREE IN EXCEL ANY EDITION EASY
HOW TO MAKE A FAMILY TREE IN EXCEL ANY EDITION EASY

Next, fill in your parents' information. In their 'Parent' columns, enter your name. Continue this pattern for your siblings, grandparents, aunts, uncles, and so on.

Formatting Your Data

To turn data into a visual representation, group and subtotal. Select your table, go to the 'Home' tab, and click 'Format as Table'. Choose a table style. Then, go to the 'Design' tab that appears, and click 'Group & Outline' in the 'Show' group. Choose 'Autofit Column Width' to display all data.

Select the 'First Name' column, hold 'Shift' to select the entire table, and right-click to display 'Format Cells as Table'. Click 'Number' on the 'Category' list, then 'Format' on the 'Number' grid, and choose 'Date'. Finally, click 'OK' twice. This will ensure dates appear consistently.

How to… Get Organized with Researching My Family Tree
How to… Get Organized with Researching My Family Tree
3 Ways to Make a Family Tree on Excel - wikiHow
3 Ways to Make a Family Tree on Excel - wikiHow
Create and Print a Family Tree Online - Free
Create and Print a Family Tree Online - Free
Family Tree Maker In Excel | Visualize Your Entire Family Structure Perfectly
Family Tree Maker In Excel | Visualize Your Entire Family Structure Perfectly
Family Tree Template (Excel)
Family Tree Template (Excel)
41 Free Family Tree Templates (Word, Excel, PDF, PowerPoint)
41 Free Family Tree Templates (Word, Excel, PDF, PowerPoint)

Crafting Your Family Tree

To make your data look like a tree, use the 'AutoFilter' feature and a little creativity. Right-click anywhere in your table's column header area, and select 'Sort and Filter'. Click the first box in the first row to add a dropdown filter. Do this for all columns with family member names. This lets you show or hide branches of your tree.

Now, sort your data by selecting the 'First Name' column, clicking 'Sort & Filter' in the 'Home' tab, then 'Sort' > 'More Sort Options'. In the dialog box, select 'Custom List' and click 'OK'. Then, click 'OK' again. Now, your family tree will display in a logical order.

Displaying Your Family Tree

The key to displaying your family tree is to remove rows you don't want to display. Excel will hide rows when you sort or group, but it won't remove them. So, add a row below the last person in your tree, then look at your 'Filter' dropdowns. Click 'X' to remove all filters, revealing all hidden rows.

How to Make a Family Tree in Microsoft Excel
How to Make a Family Tree in Microsoft Excel
Family Tree Maker With Photos - Automatic Excel Template
Family Tree Maker With Photos - Automatic Excel Template
Use a Spreadsheet to Analyze Your Family Tree
Use a Spreadsheet to Analyze Your Family Tree

Highlight all your data, then remove the extra rows. Here's how: press 'Alt + =' to enter 'Structured References' mode. In the formula bar, highlight 'Table1' and press 'Ctrl + -', then 'Ctrl + X' to cut all extra rows. Press 'Esc' twice to exit 'Structured References'.

Adding Visuals

Add a touch of panache with a name chart, snake chart, or a symbol family tree. To create a symbol family tree, insert a 'Shape' and use 'Format > Group' to add other shapes. 'Format > Merge Shapes' can create relation lines. Customize with colors and line styles for a unique look.

Your family tree is now ready to share. Print it, save it as a PDF, or share it via email. It's a great educational and fun tool that can inspire conversations and connect generations. Happy tracking!