✦Template Printable Ideas Insights

"Create Family Tree in Excel with Pictures: Step-by-Step Guide"

By

Create a visually appealing and organized family tree in Excel with these step-by-step instructions and with pictures! Having a well-structured family tree helps you preserve your family history and is an excellent tool for genealogy research. So, let's dive right into it.

Before you start, make sure to have Excel installed in your computer. For this tutorial, we'll use Excel 2016, but the process is quite similar in other versions. Let's prepare our Excel canvas and get started.

Setting Up Your Excel Sheet

First, open Microsoft Excel. Click on 'Blank workbook' to create a new Excel file. This will serve as the base for your family tree. We'll use this to insert our data and images.

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
Create and Print a Family Tree Online - Free
Create and Print a Family Tree Online - Free

Resizing the columns to suit your needs is crucial at this stage. To do this, simply hover your cursor over the line between two columns (e.g., between Column A and B), then drag it to the desired size. Customize your columns according to the amount of information you plan to include for each family member.

Adding Family Member Details

At the intersection of Row 1 and Column A, enter the words 'Family Tree' as the title of your chart. Click on the cell and press 'Enter' to confirm. Now, from column A to E, start listing down the details you want to include - such as Name, Date of Birth, Place of Birth, etc.

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 (Using Free Templates or from Scratch)
How to Make a FAMILY TREE in EXCEL (Using Free Templates or from Scratch)
Family Tree Maker: Excel Template with Photo Upload
Family Tree Maker: Excel Template with Photo Upload

Beneath 'Name', type 'Mother', 'Father', 'Siblings', 'Spouse', 'Children' as subheadings for the data that you'll be inputting. Each of these categories will represent one branch of your family tree.

Adding Pictures to Your Family Tree

To add pictures to your Excel family tree, click on the cell where you want the image to appear. In this case, you might want to place the picture under the 'Name' column. Navigate to the 'Insert' tab in the ribbon, then click on 'Pictures'. Choose the picture from your computer you'd like to add.

To ensure the pictures are all roughly the same size and look consistent, click on any of the inserted images, then go to the 'Format' tab in the ribbon. Here, you can adjust the height and width of the picture to match the rest.

HOW TO MAKE A FAMILY TREE IN EXCEL ANY EDITION EASY
HOW TO MAKE A FAMILY TREE IN EXCEL ANY EDITION EASY
Family Tree Maker With Photos - Automatic Excel Template
Family Tree Maker With Photos - Automatic Excel Template
3 Ways to Make a Family Tree on Excel - wikiHow
3 Ways to Make a Family Tree on Excel - wikiHow
a screenshot of a computer screen showing the user's name and date selection
a screenshot of a computer screen showing the user's name and date selection
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
How to Make a Family Tree in Microsoft Excel
How to Make a Family Tree in Microsoft Excel

Creating Your Family Branches

Once you've added all the information and images you want, it's time to create the branches of your tree. In the cell where you want your first branch to start, click and input the information for that person, such as their name and details.

To start a new branch, right-click on the cell below the current row and select 'Insert'. This will create a new row where you can input the information for the next family member. Repeat this process for each branch of your family tree.

Creating Sub-branches

For members who have their own children, you'll need to create sub-branches. Right-click on the cell below the last child member (so the insertion will happen 'after' and not 'between' existing rows). This new row labeled 'x/y' indicates where new rows will be added.

Family Tree Maker In Excel | Visualize Your Entire Family Structure Perfectly
Family Tree Maker In Excel | Visualize Your Entire Family Structure Perfectly
How to Make a Family Tree in Microsoft Excel
How to Make a Family Tree in Microsoft Excel
Automatic Family Tree Maker - Excel Template
Automatic Family Tree Maker - Excel Template

In the new row, input the information for the first child. Continue creating rows and inputting your family member's information until you've covered all branches and sub-branches.

Removing Empty Rows

After you've finished creating all your branches and sub-branches, you may notice some empty rows between sections. To clear these out, click inside any empty row, then right-click and choose 'Delete'. You'll be presented with a menu - select 'Shift Cells Up' to delete the empty row without disrupting your data.

Congratulations! You've successfully created a family tree in Excel with pictures! Now, save your document, and you'll always have a beautiful visual representation of your family history at your fingertips.

But why stop at your immediate family? You could continue tracing your lineage back through your parents, grandparents, great-grandparents, and beyond. Each time you uncover more of your family history, don't forget to update and expand your Excel family tree!