Lassho.edu.vn - Various useful general information portal

How to Create a Family Tree in Excel

by

You are viewing the article How to Create a Family Tree in Excel  at Lassho.edu.vn you can quickly access the necessary information in the table of contents of the article below.

Family trees are a popular school project and a fun way to let people know your ancestors. While Excel is capable of complex genealogy work, for long-term research projects you should use specialized software.

Use templates

Image titled Make a Family Tree on Excel Step 1

Image titled Make a Family Tree on Excel Step 1

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6b/Make-a-Family-Tree-on-Excel-Step-1-Version-3.jpg/v4-460px- Make-a-Family-Tree-on-Excel-Step-1-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6b/Make-a- Family-Tree-on-Excel-Step-1-Version-3.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-1-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser-output”></div>”}
Create a new document from a template. Click File → New from Template if the option is available. On some versions of Excel, you just need to choose File → New and a frame of templates will appear for you to choose from.
Image titled Make a Family Tree on Excel Step 2

Image titled Make a Family Tree on Excel Step 2

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c4/Make-a-Family-Tree-on-Excel-Step-2-Version-3.jpg/v4-460px- Make-a-Family-Tree-on-Excel-Step-2-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c4/Make-a- Family-Tree-on-Excel-Step-2-Version-3.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-2-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser-output”></div>”}
Find a sample of a family tree. The family tree template is not pre-installed, so you need to search online. Use the keyword “family tree” to find and download two options available for free. If you don’t see the search bar, look under the headings “Microsoft Office Online”, “Office.com” or “Online templates” depending on your version of Excel. [1] [2] Select the “Personal” subsection, then browse the family tree sample.

  • On Excel 2007 and earlier, you may not see these options. Look for unofficial templates online, or see more below.
Image titled Make a Family Tree on Excel Step 3

Image titled Make a Family Tree on Excel Step 3

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/68/Make-a-Family-Tree-on-Excel-Step-3-Version-3.jpg/v4-460px- Make-a-Family-Tree-on-Excel-Step-3-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/68/Make-a- Family-Tree-on-Excel-Step-3-Version-3.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-3-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser-output”></div>”}
Try a traditional family tree diagram. The “Family tree chart” template is a simple spreadsheet with colored cells outlining the family tree. There is only the box for you and the four generations of direct ancestors. This template is suitable for school projects and cannot be extended to genealogy research. To use, you just need to click on the colored box and enter the family member’s name.

  • To add a cell for siblings, copy the “your” cell and paste it into another cell in the same column to make it the same green cell as yours. Similarly, you can copy your parent’s cell and paste it into another cell in the same column to create a light green box for aunt/uncle.
READ More:   Lorenzo de’ Medici
Image titled Make a Family Tree on Excel Step 4

Image titled Make a Family Tree on Excel Step 4

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/18/Make-a-Family-Tree-on-Excel-Step-4-Version-3.jpg/v4-460px- Make-a-Family-Tree-on-Excel-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/18/Make-a- Family-Tree-on-Excel-Step-4-Version-3.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-4-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser-output”></div>”}
Create a larger family tree. If you are working with a more complex family tree, choose the “Family tree” template. This template uses the SmartArt feature that is only available in Excel 2007 and later. [3] You can click on the squares and enter the names of relatives, besides you have many more features such as:

  • Click anywhere on the document to display the Text Pane text frame. This feature allows you to edit your family tree through a simple and concise list. To add a relative, click the + button at the top of the frame. With the new cell selected, you can use the → or ← buttons to move between generations. Click and drag the mouse to move the box below the boy or girl’s name.
  • Right on the document, the SmartArt ribbon menu also has many options for the appearance. For example, if you click on the Hierarchy icon, a choice of how to display the data will appear.

Using SmartArt (Excel 2007 and later)

Image titled Make a Family Tree on Excel Step 5

Image titled Make a Family Tree on Excel Step 5

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/36/Make-a-Family-Tree-on-Excel-Step-5-Version-3.jpg/v4-460px- Make-a-Family-Tree-on-Excel-Step-5-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/36/Make-a- Family-Tree-on-Excel-Step-5-Version-3.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-5-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the SmartArt icon in the ribbon bar. On the new version of Excel, you can use the “SmartArt” feature to create better-looking charts. Choose “SmartArt” in the ribbon menu above the blank worksheet to get started.

  • On Excel 2007, you select the Insert tab (Insert), then find the SmartArt option in the Illustrations group. [4]
Image titled Make a Family Tree on Excel Step 6

Image titled Make a Family Tree on Excel Step 6

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4e/Make-a-Family-Tree-on-Excel-Step-6-Version-3.jpg/v4-460px- Make-a-Family-Tree-on-Excel-Step-6-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4e/Make-a- Family-Tree-on-Excel-Step-6-Version-3.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-6-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser-output”></div>”}
Create a hierarchy table. In the SmartArt options that show up on the ribbon menu, select the Hierarchy icon near the left side of the menu. Then select the type of hierarchy that you want to use in the spreadsheet.
Image titled Make a Family Tree on Excel Step 7

READ More:   What is a mini washing machine? Should I buy a mini washing machine?

Image titled Make a Family Tree on Excel Step 7

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/01/Make-a-Family-Tree-on-Excel-Step-7-Version-3.jpg/v4-460px- Make-a-Family-Tree-on-Excel-Step-7-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/01/Make-a- Family-Tree-on-Excel-Step-7-Version-3.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-7-Version-3.jpg”,”smallWidth”:460 ,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser-output”></div>”}
Fill in the family tree. You can drag the new chart around and zoom in like other Excel objects. Click on each blank figure or line in the chart to enter a name for the family tree.

  • Or, you can use the Text Pane while selecting the chart. Any changes you make in the text frame will also affect the graph.

Use a traditional spreadsheet

Image titled Make a Family Tree on Excel Step 8

Image titled Make a Family Tree on Excel Step 8

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9a/Make-a-Family-Tree-on-Excel-Step-8.jpg/v4-460px-Make-a- Family-Tree-on-Excel-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9a/Make-a-Family-Tree-on-Excel- Step-8.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-8.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight” :551,”licensing”:”<div class=”mw-parser-output”></div>”}
Select Insert Shape. Create a new Excel spreadsheet. Click Insert in the top menu or ribbon menu, then choose Shape . You can choose rectangle, oval or any other shape.
Image titled Make a Family Tree on Excel Step 9

Image titled Make a Family Tree on Excel Step 9

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e3/Make-a-Family-Tree-on-Excel-Step-9.jpg/v4-460px-Make-a- Family-Tree-on-Excel-Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e3/Make-a-Family-Tree-on-Excel- Step-9.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-9.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight” :551,”licensing”:”<div class=”mw-parser-output”></div>”}
Place the figure in the spreadsheet. Click and drag on the worksheet to “draw” the pattern. If you want to create a nice circle or square, hold down the ⇧ Shift key while dragging the mouse. [5]
Image titled Make a Family Tree on Excel Step 10

Image titled Make a Family Tree on Excel Step 10

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3d/Make-a-Family-Tree-on-Excel-Step-10.jpg/v4-460px-Make-a- Family-Tree-on-Excel-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3d/Make-a-Family-Tree-on-Excel- Step-10.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-10.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight” :551,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter your name in the picture . Click on the bottom of the image and enter your name. Then customize the font size, color, and style to your liking before proceeding to the next step.
Image titled Make a Family Tree on Excel Step 11

Image titled Make a Family Tree on Excel Step 11

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ea/Make-a-Family-Tree-on-Excel-Step-11.jpg/v4-460px-Make-a- Family-Tree-on-Excel-Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ea/Make-a-Family-Tree-on-Excel- Step-11.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-11.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight” :551,”licensing”:”<div class=”mw-parser-output”></div>”}
Copy and paste to create more shapes. Select the shape you just drew and press Ctrl + C (or ⌘ Cmd + C on a Mac) to copy. Press Ctrl + V to paste the corresponding number of shapes you need.
Image titled Make a Family Tree on Excel Step 12

Image titled Make a Family Tree on Excel Step 12

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/67/Make-a-Family-Tree-on-Excel-Step-12.jpg/v4-460px-Make-a- Family-Tree-on-Excel-Step-12.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/67/Make-a-Family-Tree-on-Excel- Step-12.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-12.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight” :551,”licensing”:”<div class=”mw-parser-output”></div>”}
Arrange the shapes in the family tree. Click and drag the shapes together to make a fake tree layout. Usually, you can place one shape at the bottom of the sheet, two in the top row, two more at the top, and so on. Then, click on each picture and enter the names of the relatives.
Image titled Make a Family Tree on Excel Step 13

READ More:   Pam Dawber

Image titled Make a Family Tree on Excel Step 13

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/dc/Make-a-Family-Tree-on-Excel-Step-13.jpg/v4-460px-Make-a- Family-Tree-on-Excel-Step-13.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/dc/Make-a-Family-Tree-on-Excel- Step-13.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-13.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight” :551,”licensing”:”<div class=”mw-parser-output”></div>”}
Insert line. Return to the Insert Shapes menu and select the zig zag line. Click and drag your mouse on the sheet to draw a line connecting the bottom shape with the two top shapes (parents). Just like before, you copy and paste to create new lines and drag to drop into place.
  • Image titled Make a Family Tree on Excel Step 14

    Image titled Make a Family Tree on Excel Step 14

    {“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a2/Make-a-Family-Tree-on-Excel-Step-14.jpg/v4-460px-Make-a- Family-Tree-on-Excel-Step-14.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a2/Make-a-Family-Tree-on-Excel- Step-14.jpg/v4-728px-Make-a-Family-Tree-on-Excel-Step-14.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight” :551,”licensing”:”<div class=”mw-parser-output”></div>”}
    Enter more information if necessary. If you like, you can add a date of birth or a note under each name. You can also add this information to the image, or click in the worksheet cell directly below each name and enter the information.

    • Advice

    • PowerPoint also has a free family tree template.

    Family trees are a popular school project and a fun way to let people know your ancestors. While Excel is capable of complex genealogy work, for long-term research projects you should use specialized software.

    Thank you for reading this post How to Create a Family Tree in Excel at Lassho.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

    Related Search:

    Related Posts

    How to Create Curved Text in Photoshop
    How to fall asleep faster
    How to Install FBReader to Read eBooks