Best Way to Do a Family Tree in Excel

Download Article

Download Article

Family trees are a mutual school projection, and a fun way to show people your ancestry. Excel is capable of more complex genealogy projects every bit well, only for longterm inquiry projects you may adopt specialized software.

1. 1

   Create a new document from template. Select File → New from Template if the option is nowadays. On some versions of Excel, only selecting File → New opens a pane where you can choose betwixt templates.

2. 2

   Search for a family tree template. The family tree template is not pre-installed, so you volition need to exist connected to the internet to find it. Search for "family unit tree" to observe two options available for free download. If you don't encounter a search bar, look under "Microsoft Role Online," "Office.com," or "Online templates," depending on your Excel version.^{[1] [2]} Select the "Personal" subsection, then browse for family tree templates.

   • If you're using Excel 2007 or before, you may not run into these options. Y'all can either search online for unofficial templates, or skip to the sections below for other options.

   Advertisement

3. three

   Try the bones family tree chart. The "Family tree nautical chart" template is a simple spreadsheet with colored cells to outline a family tree. There is only room for yourself and four generations of direct ancestors. This makes it a good option for school projects, but not extended genealogy research. To use information technology, merely click on the colored cells and type in the proper name of your family members.

   • To add cells for your siblings, re-create-paste "your" cell onto another cell in the same column to turn it the aforementioned green color. Similarly, you lot can copy-paste your parents' cells into the same column to make lighter green cells for your aunts and uncles.

4. iv

   Create larger family unit tree. If you're working on a more than circuitous tree, select the "Family tree" template instead. This uses the SmartArt feature, which requires Excel 2007 or afterward.^[three] Yous tin all the same click the squares and type in your relatives' names, just you lot've got many more than features likewise:

   • Click anywhere in the certificate to make the Text Pane appear. This lets yous edit the family tree through a simple, compact list. To add together another relative, press the + push button at the elevation of the pane. With the new prison cell selected, use the → or ← buttons to move it betwixt generations. Click and drag to move it below the proper noun of its son or daughter.
   • Above the document itself, the SmartArt ribbon menu has many visual options. For example, click the Bureaucracy icon to see a selection of ways to display the data.

   Advertizing

1. 1

   Click the SmartArt icon in the ribbon menu. In modern versions of Excel, you tin utilise a characteristic called "SmartArt" to make more attractive diagrams. Select "SmartArt" in the ribbon menu higher up a blank spreadsheet to get started.

   • In Excel 2007, instead select the Insert tab, and then observe SmartArt in the Illustrations group.^[4]

2. 2

   Create a hierarchy. Now that the ribbon bill of fare is displaying SmartArt options, select the Hierarchy icon, near the left side of the carte du jour. Select the visual style of your pick, and information technology will appear over the spreadsheet.

3. 3

   Fill up out the family tree. The new diagram can be dragged around and enlarged just like any Excel object. Click on each shape or blank line inside the diagram to type the name of your family tree.

   • Alternatively, utilize the Text Pane that appears when you select the diagram. Any change you make in the text pane volition instantly bear on the diagram's advent.

   Advertisement

1. 1

   Select Insert Shape. Create a new Excel spreadsheet. Click Insert on the top bill of fare or ribbon menu, then Shape . Cull a rectangle, oval, or any other shape.

2. 2

   Place it in the spreadsheet. Click and drag in the spreadsheet to "depict" the shape. To make information technology a perfect circumvolve or square, hold down ⇧ Shift as you drag.^[5]

3. 3

   Write your proper noun in the shape. Click on the lowest shape and type your name. Adjust the font size, color, and other styles if you would like earlier moving on to the side by side step.

4. 4

   Re-create and paste to create more shapes. Select the shape you just drew and copy it with Ctrl + C ( ⌘ Cmd + C on a Mac). Paste as many copies as y'all need past pressing Ctrl + V repeatedly.

5. 5

   Adapt them in a family tree. Click and drag the shapes into a family unit tree layout. Typically, y'all would put one shape at the bottom of the sheet, ii in a row in a higher place that, two more to a higher place each of them, etc. Click on each shape and type to write in the name of each relative.

6. 6

   Insert lines. Render to the Insert Shapes menu and select a zig zag line. Click and drag in the spreadsheet to draw a line connecting a shape with the 2 shapes (parents) above it. Equally before, copy-paste to create new lines and drag them into position.

7. 7

   Write in optional information. If you like, you can include nascence dates or notes below each name. You can either add this within the shape itself, or click on spreadsheet cells right below each name and type the info there.

   Advertisement

Add New Question

• Question

  How exercise I change the size of the text boxes?

  

  Select the text box that you want to enlarge. Click and drag the corners or the sides to enlarge the box. If yous increment the size of the box, you lot may desire to increase the size of the font as well.

• Question

  Can I download a template for a family tree on Excel?

  

  Yes, you can and it works well.

Ask a Question

200 characters left

Include your email address to get a bulletin when this question is answered.

Submit

Advertisement

Video

• PowerPoint too has a costless family tree template.

Thanks for submitting a tip for review!

Advertizing

Near This Article

Article Summary X

1. Open Excel.
two. Search for a family tree template.
3. Select a template.
4. Fill out the template.
5. Save the file.

Did this summary assistance you?

Thanks to all authors for creating a page that has been read 658,380 times.

Is this commodity upwards to date?

hughes-jonesroadvine1969.blogspot.com

Source: https://www.wikihow.com/Make-a-Family-Tree-on-Excel

Share this post