Get Access to World’s largest Template Library & Tools

How to Create a Family Tree Chart in Excel, Word, Numbers, Pages, PDF – Tutorial

If you are looking forward to becoming your family’s genealogist, creating a family tree should be one of your significant steps towards achieving that. It would be sheer fun presenting the whole family tree to your relatives. This is because tracing your roots, extended family, cousins, or any 10 generation relatives is more of detective work. You just get some leads to uncover more relationship and ancestry information. Carrying out this task can be tedious, but it will be worth the trial in the end.

Microsoft Excel can produce complex family tree charts and can be used for the longest time as new generations come. Whether for a school project, history, preschool, or English classes, our free and fillable genelogy charts will help you complete the work in no time. Download blank copies and start following steps to guide you in creating a family tree.

Free English Blank Family Tree Chart Template

free family tree chart template
Details
File Format

Size: A4, US

Free Download

Family Relationship Tree Chart Template

family relationship tree chart templatengsgenealogy.org
Details
File Format
  • PDF

Size: 214 KB

Download Now

Family History Family Tree Chart Template

family history family tree chart templatecourts.ca.gov
Details
File Format
  • PDF

Size: 159 KB

Download Now

Genealogy Family Tree Chart Template

genealogy family tree chart templatecf.ltkcdn.net
Details
File Format
  • PDF

Size: 491 KB

Download Now

10 Generation Ancestry Family Tree Chart Template

0 generation ancestry family tree chart templatemarthastewart.com
Details
File Format
  • PDF

Size: 28 KB

Download Now

Fillable Family Tree Chart Template

fillable family tree chart templateklamathtribes.org
Details
File Format
  • PDF

Size: 10 KB

Download Now

Extended Family Relationship Tree Chart Template

extended family relationship tree chart templatemymcpl.org
Details
File Format
  • PDF

Size: 506 KB

Download Now

Cousins Family Tree Chart Template

cousins family tree chart templateuab.edu
Details
File Format
  • PDF

Size: 165 KB

Download Now

Pre School Project Family Tree Chart Template

pre school project family tree chart templateazwestern.edu
Details
File Format
  • PDF

Size: 55 KB

Download Now

Step 1: Create a New Spreadsheet

Launch a new Excel document by clicking the start button, and then click on Microsoft Office to select Microsoft Excel Templates. Once all that is done, click File from the menu and click New to select a template to create a family tree. In some versions of Excel, the options are different where a new pane is opened where you choose from various templates categories.

Alternatively, once you have opened a new spreadsheet, click Insert at the top of the menu bar or on the ribbon menu. Then, click Shape to choose the exact shape you want on your family tree sample. You can select between circular, triangular, or rectangular shapes.

create a new spreadsheet

Step 2: Insert the Shapes in the Spreadsheet

Next, hover the mouse on the shapes and make a selection of the desired shapes that you would like to insert in the family chart. After you have selected, drag the shapes into the Excel spreadsheet templates. In case you want to alter the shape and make it better, press Shift and drag the shape down in the Excel worksheet.

Step 3: Enter Text in the Shape

In the lowest shape on the spreadsheet, enter the family name or your own name. Then adjust the color, font size, and any other style that you want to be included in the name.

enter text in the shape

Step 4: Insert more Shapes into the Family Tree

There are a few techniques that you can use to add more shapes to the family tree. The easiest is by copying and pasting the shapes. Click on the shape that is already created. Right-click on the shape and select copy or alternatively press CTRL + C to copy and CTRL + V to paste repeatedly until you achieve the number of shapes you want.

Arrange the shapes you have created in order depending on the hierarchy you have set. You can choose to typically place two or more shapes above the shape at the bottom which comprises your name. However, this depends on the family you want to create. For a basic family, it is easier to place the shapes on top of others.

Step 5: Insert Joining Lines

Click again on the Shapes menu to select your ideal line. A zigzag line is mostly used to join or connect two shapes to each other. You can click on the zigzag shape every time you want to connect two shapes. Drag the line on the shape and adjust it to fit between the shapes. Copy and paste the zigzag line every time you add a shape to connect it.

You can choose to give more details on your family tree; birth dates, names, photos, hobbies among other details. This will give you an opportunity to study more about your family members

insert joining linesYou can choose to write the details within the shapes or in a cell within the spreadsheet. Excel gives you a chance to get more creative in creating amazing family tree charts.

More in Tutorials

How to Create a Professional Resume Using Microsoft Word - TutorialHow to Write a Cover Letter - Tutorial
How to Write a Professional Resignation Letter - TutorialHow to Make/Create a Thank You Letter for a Scholarship [Templates + Examples] 2023
How to Create a Lesson Plan in Word - TutorialHow To Make/Create a Business Letter [Templates + Examples] 2023
How to Create an Affirmative Action Plan - TutorialHow to Create a Gantt Chart in Excel Easily - Tutorial
How to Create a Resume on a Mac - TutorialHow to Create an Action Plan - Tutorial
How to Create a Lesson Plan for Elementary School - TutorialHow to Create a Family Tree Chart in Excel, Word, Numbers, Pages, PDF - Tutorial
How to Create a Pie Chart in Microsoft Excel - TutorialHow To Make/Create a Receipt [Templates + Examples] 2023
How to Create a Project Schedule in Excel - TutorialHow to Make a Certificate in Microsoft Word - Tutorial
How to Create a Calendar in Word - TutorialHow to Create a Birth Certificate using Word - Tutorial
How to Create a Calendar in Excel - TutorialHow to Make a Gift Certificate on Microsoft Word - Tutorial
How to Create a Family Tree in Microsoft Word - TutorialHow to Make/Create a Timeline in Microsoft Word [Templates + Examples] 2023
How to Create a TimeSheet in Excel - Tutorial5+ How to Make an Inventory Using Excel - Tutorial
How to Create an Invoice on ExcelHow to Create Receipts in Excel
How to Create a Family Tree in PowerPoint - TutorialHow to Use Bootstrap Tooltip
How to Use Glyphicons in Bootstrap 3How to Create Custom PHP Contact Forms
How to Use PHPBrew & VirtPHP - TutorialUnderstanding Bootstrap Grid - Column Wrapping
How to Create a Basic Timeline Template in Excel 2023 - Tutorial10 Top YouTube Channels for Game Development Tutorials in 2023!
What is a CSS Preprocessor and Why You Should Use IT?25+ Great Examples of InDesign In Use - Tutorials
Top Ui Photoshop Tutorials for Freshers5 Tips to Make Your Website Invincible From Hackers!
20 Easy Illustrator Tutorials For Beginners!19+ Illustrator Tutorials For Creating Isometric Illustrations!
20+ Useful Responsive Web Design TutorialsHow to Make an App - Free Online Tutorials
Html5 Tutorial for Beginners - Techniques and Examples
bottom banner