You are viewing the article How to Create a Family Tree in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
wikiHow is a “wiki” site, which means that many of the articles here are written by multiple authors. To create this article, volunteer authors have edited and improved the article over time.
This article has been viewed 29,164 times.
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.
Steps
Use templates
- On Excel 2007 and earlier, you may not see these options. Look for unofficial templates online, or see more below.
- 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.
- 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)
- On Excel 2007, you select the Insert tab (Insert), then find the SmartArt option in the Illustrations group. [4] X Research Sources
- 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
Advice
- PowerPoint also has a free family tree template.
wikiHow is a “wiki” site, which means that many of the articles here are written by multiple authors. To create this article, volunteer authors have edited and improved the article over time.
This article has been viewed 29,164 times.
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 Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: