This New Template Charts 5 Generations

Even after finding the Family Tree Generator Excel template, I needed another template. You see, the Excel template works best when you already know the names of the eldest generation. But while researching, you often know only the youngest generation.

When I research someone else's family, I create an Excel chart to keep track of their ancestors as I find them.

It was confusing—and a hassle—to build that chart from scratch each time. So I made my own Ancestor Chart template in Excel. It starts with the main person at the bottom, center. (The center is way over in column AH.) It has "father" and "mother" placeholders for five generations of ancestors. It goes all the way back to the main person's 3rd great grandparents.

This new template is perfect for use while researching an unrelated family tree.

Each generation is color-coded. Plus, the first column always tells you which generation is which. As you're researching, replace "father" or "mother" with the full name of the ancestor you've found.

I do more than keep track of my research in a spreadsheet like this. I give the finished chart to my client so they can visualize their ancestry. It's so helpful when they're reviewing the documents, translations, and explanations I provide.

This template is very wide, but you can print it if you like. Set your printer to landscape mode and this tree will span six pages.

Imagine using this template to work up from your DNA match until you reach your own ancestor.

Keep in mind that the main person doesn't have to be living. Often it's my client's grandparent or great grandparent. You can use this template to visualize any particular branch of a family. You can duplicate the chart to make separate trees for a husband and wife.

Download your copy of the file from Dropbox and let me know how you've used it. If you don't have spreadsheet software, you can copy and use this Google Sheets version of the same template.

Free and Easy-to-Use 4-Generation Family Tree Chart

I found a very nice family tree template in a surprising place. It seems perfect for those times when you're building a tree for a friend. Or showing a cousin why family trees are so amazing.

To find this free template, launch Microsoft Excel and click the link for More templates. Search for Family tree generator. (Or download it now.) When you open the template you'll see two tabs: Family Members and Family Tree. When you enter names on the Family Members tab, you're generating a chart on the Family Tree tab. It's pretty cool.

When you're explaining family relationships to someone, this simple visualization is a big help.

As an example, I entered a pair of my 4th great grandparents in the Grand Parents fields of the spreadsheet. Here are the steps to follow:

• Click the spreadsheet's Reset Family button to empty all the sample names from the fields.
• Enter the names of the ancestor couple you've chosen. For me, that's Francesco Iamarino and Cristina Iapozzuto. While the original template uses only first names, I want to use first and last names.
  • If you use both names, you'll need to turn on Wrap Text for the rows of names, and adjust the row height.
  • To do this, use your mouse to select rows 10 through 50 or so. Select Wrap Text (Home / Alignment section). Then select AutoFit Row Height (Home / Format in the Cells section).
• Each time you add a descendant, you can pull down a menu to choose their parents from a list. (Look for the arrow beside the Parents field.)
• Fill in names for each generation.
• Once you finish the "Third Generation Children," click the Create Family Tree button at the top.
• The names may appear cut off. If so, you need to turn on Wrap Text and change the Row Height. But you can't yet, because the row numbers and column letters are not visible.
  • Turn on the row and column headings by clicking the View menu and checking Headings in the Show section.
  • Set the Wrap Text as explained above, but this time, start at line 5.
  • Set the row height by clicking Format on the Home tab and choosing Row Height. I found that a row height of 50 worked well for the names I'd entered. You can experiment with different values until you're happy with the result.

Enter names for each generation, select their parents, then fine-tune your easy family tree chart.

When you save your Excel file, you'll see a message about your file containing macros. These macros are the functionality that generates the family tree chart. To keep the functionality:

• Choose Save As.
• Select the 2nd option in the list, Excel Macro-Enabled Workbook.

Now you can print the family tree chart as a PDF file to share. I chose the 11" x 17" tabloid setting and selected Fit Sheet on One Page. This way, I can print the tree onto two letter-sized pages and tape them together. Or I can find someone with a bigger printer tray.

Don't have Excel? Download the Family tree generator template and open it with your spreadsheet software. Let me know if that works or not.

The result is simple-looking (no photos or birth or death years). But what an easy way to help a friend or relative visualize their part of the family tree. Think how nice it would be to create a bunch of these charts for the holidays.

And speaking of genealogy templates:

• How to Make Custom Family Trees for the Holidays
• This Chart Finds Hidden Relationships in Your Family Tree
• How to Visualize Your Ancestor-Finding Progress

Genealogy Projects: A Much Needed Distraction

Genealogy tasks and projects are the perfect antidote for a year of bad news. They're a distraction that takes you straight to your happy place.

This year you'd better not have any large gatherings for the holidays. But you can have your family time by working on your family tree.

Does 2020 make you want you chill? Replace the stress with these family tree projects.

If you don't have a handful of go-to genealogy tasks to keep you busy, try one or more of these projects:

Make a Custom, Keepsake Family Tree. You may start out making one of these unique family trees for a loved one. But I'll bet you'll want one for yourself.

Take Your Obsession to the Next Level. Poring over the vital records from one grandfather's hometown in Italy, something became very clear. The whole town was related! Neighboring families marrying their children to one another. Widowed in-laws marrying. The amount of interconnection was amazing. That's when I knew what I had to do. I had to document everyone in town and make an enormous family tree. What's your obsession with genealogy? What can you do to make it truly grand?

Serenity now! This genealogy therapy will actually calm you down.

Pay it Forward with Cemetery Photos. You may not be able to travel to your ancestor's cemetery, but I'll bet you have several nearby. Why not spend a day documenting one? You can check the Find a Grave or Billion Graves websites to see who's asking for a photo of a particular grave. Then go find it!

Help Out a Less-Experienced Genealogist. Have you developed a talent for reading old handwriting? Are you pretty darned good at finding someone in the census? Sharpen your skills while doing a good deed! Plenty of less-experience family tree buffs are out their asking for help. Try to solve their mystery for them.

Genealogy is the perfect escape from all your troubles. Which project will you choose first?

This Project Makes Your Family History Larger than Life

This is the next best thing to seeing and holding your ancestor's original documents.

You're so wrapped up in your genealogy treasures. And rightly so! You've found proof for all those birth names, birth dates, marriages, and deaths. You've got immigration and naturalization records. You've got military records and census sheets galore.

Then you visit your cousins and have no good way to share the enormous scope of your family history work. What can you do?

The answer is paper. At least, until I invent the family tree hologram. And big paper, at that.

I've lived my life at a computer keyboard since 1982. I prefer to keep every genealogy document in digital form. Named logically, filed logically, and backed up weekly. But sometimes paper is the most powerful way to share the joy of your family tree.

Here's a project that will help you get those cousins excited about your crazy, obsessive, endless hobby.

An inexpensive paper cutter makes this process so easy, you won't believe it.
Notice the 12" ruler at the top for scale.

This project has just a few steps:

• print
• trim
• tape
• file

You're going to print over-sized documents that your cousins can read. No magnifying glass required. You'll start with your closest relatives—the ones for whom you've found documents.

You can print across several sheets
of paper from certain programs.

My two grandfathers immigrated to the United States from Italy, so they're a great place for me to start. I can print out full-sized copies of all their major documents:

• ship manifests
• census sheets
• naturalization papers
• military documents
• birth, marriage, and death certificates

To make these big printouts at home, you have a couple of options.

Adobe Acrobat and Microsoft Paint (yes, plain old Paint) let you print your image on multiple sheets of paper. I like Acrobat because it can add "cut marks" that come in handy when you're ready to put the sheets together. In Paint, you can choose how many pages to print to. For example, you might find that 2-pages wide by 2-pages high is a good size. For Mac users, whichever application you use, look for Scale options in the Print dialog. Note: I was able to open a document image in Photoshop and export is as a PDF. This is my best option.

Once you print out your images, a paper cutter is the best tool for trimming off the excess. You can find low-priced paper cutters like this one from Overstock. I bought a similar one a few years ago for $15. They should have some in your local craft or sewing store, too.

Now line up your trimmed sheets, two at a time. You're going to want to tape them together on the back side. Don't skimp on the tape. It's going to form a very convenient fold-line for storing your oversized document.

These big documents are very impressive, and so much easier to read than a shrunken down version.

An accordion folder is an easy way to carry a huge number of big documents to your next family gathering.

Print and assemble all the documents you like for a particular ancestor. Then fold them down, clip them together, and put them into an accordion folder. Fill your accordion folder with documents and bring it with you the next time you visit your relatives.

I dare your cousins not to light up at the sight of these big, old-timey documents with their ancestor's name on them!

And speaking of showing off your family tree:

• How to Share Your Family Tree Research with Relatives
• Who's Borrowing Your Family Tree?
• Share Your Family Tree Names in a Word Cloud

How to Make Custom Family Trees for the Holidays

On Friday I watched a presentation by a woman who creates one-of-a-kind family tree charts. (You can see it now.)

Her designs inspired me to work on a special family tree design for my sister-in-law. We're going to her place for a party soon. My husband is making a traditional Japanese dish they grew up with. Me? I'm carrying the bottle of wine.

Now I'm thinking, why not give her a keepsake she'll treasure? I can create a custom family tree chart for her. Wouldn't this be a unique and heartfelt gift for someone on your gift list? (If you answered "no", see How to Share Your Family Tree Research with Relatives.)

I don't own a separate program for making family tree charts. I have only what's built into Family Tree Maker. But after seeing that online presentation, I want more than Family Tree Maker can offer.

Imagining the Family Tree Chart

I'm envisioning a tree with my father- and mother-in-law in the center, his family to the left, and her family to the right. I'd like to add some photos and more details for special memories.

Now I need to figure out a good format to use. One where I can have design freedom.

Earlier in my career I had a lot of desktop publishing experience. I created brochures and newsletters for big companies. But now I design web pages, not print pages.

What software do I have that I can use for this? Microsoft Publisher comes free with my Office 365 subscription, but I've never used it. I launch it and start looking at templates. When I type in "family tree", Publisher offers me a PowerPoint template.

That can work. I've done some design in PowerPoint when I needed to produce PDFs for my current company.

I open up the PowerPoint family tree template, and it looks like this:

This family tree is a free PowerPoint template.

I can use these elements to make the type of tree I have in mind.

Print Considerations

Before I go any further, I have to think about how I'll print this tree. My husband has access to a plotter at work with a 24" maximum width. He'll be more than happy to print a chart for his sister.

You may not have access to someone's plotter at the office. But you should have some nearby commercial options. The first time I printed a big family tree, it was 2 feet wide and 5 feet long. I had 40 copies printed at Kinko's (now called FedEx Office Print & Ship Center) and gave them out to all the cousins.

Your local FedEx, Staples or UPS store can take your digital file and print it out on a big plotter. Check with them for their requirements and size limitations.

Design Time

Start by looking for inspiration. Watch the video linked at the top of this article, Google family tree charts, or check Pinterest. You're bound to find something you like.

I want to include my in-laws' wedding photo and any photos I have of their parents. I want to make room for my late father-in-law's 5 siblings and my late mother-in-law's 7 siblings.

I begin by changing the page size in my PowerPoint file. I copy the tree format, then flip the copy so I wind up with a bow-tie tree format. I take out the template's colors and go with grayscale. Here's how my template looks now:

You can duplicate and move pieces of the template to create what you want.

I want to add some more space at the bottom for photos and captions. But first, I can fill in all the names I have. Here's how it looks with a tall stack of my in-laws' siblings in the center:

I used an unusual format to accommodate lots of siblings.

The template comes with a sample paragraph. I add some formatting to the paragraph so I can use it to add captions to the photos I'll choose.

I find a generic Japanese landscape photo to use as the background of my sister-in-law's tree. I fade it way back and push it to the bottom layer. All the text boxes and photos are in front of the image, so it doesn't interfere with anything. Here's my final product:

The final product didn't need a plotter. It fit on an 11"x17" sheet of paper.

With the holidays upon us, it's best not to get too caught up in what's missing from the tree. Focus instead on the personalized touches you can add that will make your loved one so happy. Those touches can include:

• A special family photo
• Their parents' marriage certificate
• A war hero's military record
• A picture of the family home

Which family tree chart do you want to create first?