Genealogy has long been a fascinating pursuit, and with the advent of digital tools like Microsoft Excel, it's easier than ever to create detailed family trees. This comprehensive guide will walk you through the process of making a family tree in Excel 2016, ensuring a well-organized and visually appealing result.
Before diving in, make sure you have Excel 2016 installed and ready, along with a basic understanding of its interface. You'll also need some preliminary information about your family, such as names, birthdates, parents, and siblings. Once you have your data, let's get started.
Setting Up Your Family Tree
Kickstart your family tree by setting up the initial structure. Begin by opening a new Excel workbook and removing any unwanted sheets until you only have one left.
In the first row, starting from column A, type in the following headers: 'Name', 'Birthdate', 'Father', 'Mother', 'Spouse', and 'Children'. These columns will provide a robust framework for your family tree, capturing both personal information and relationships.
Entering Family Data
Now that your sheet is set up, it's time to input your family's information. Start by typing a family member's name in the 'Name' column (A).
Next, record their birthdate in the corresponding 'Birthdate' column (B). You can format this cell as a date for clarity. For the remaining columns, type in the names of the respective family members. For instance, in the 'Father' column (C), input the father's name, and in the 'Mother' column (D), input the mother's name.
Organizing and Expanding Family Data
As you enter more family members, you'll notice that some names repeat. This is because Excel auto-fills down the column when you type a name that matches. This feature is crucial for maintaining consistency and accuracy in your family tree.
To expand your tree, continue typing names in the 'Spouse' column (E) and 'Children' column (F). Be sure to include grandparents, aunts, uncles, and cousins to create a comprehensive record of your family.
Formatting for Clarity and Style
With your data entered, the next step is to format your family tree for easy reading and a touch of elegance. Here are some formatting techniques to consider:
Freezing Panes
To make navigation smoother, freeze the top row with your headers. Click anywhere in the row below the headers and select 'View' > 'Freeze Panes' > 'Freeze Top Row'.
You can also freeze multiple rows or columns by selecting a range before using the 'Freeze Panes' option.
Conditional Formatting for Hierarchy
To illustrate familial hierarchy, apply conditional formatting based on the 'Generation' column. Insert this column (G) to the right of 'Children', and use formulas like 'IF(LEN(E2)>0, IF(F2>0, "Parent", "Child"), "Grandparent")' to categorize each family member.
Now, apply conditional formatting to 'Generation' by selecting 'Home' > 'Conditional Formatting' > 'Highlight Cells Rules' > 'Equal to'. Choose distinct colors for each generation to clearly denote familial hierarchy.
Formatting with Borders
Add borders to your data range for a polished look. Select your data, right-click, and choose 'Format Cells'. On the 'Border' tab, choose your preferred border style and color. Click 'OK' to apply.
Your family tree is now organized, formatted, and ready for admiration. Printing it out allows you to share your genealogy with loved ones, while having an electronic copy ensures your family history is well-preserved for generations to come. Happy digging!