www.howtogeek.com Open in urlscan Pro
3.222.102.97  Public Scan

Form analysis
2 forms found in the DOM

GET /search/?q=

<form method="get" class="search-form js-searchBox icon i-search" id="searchform2" action="/search/?q=">
  <input id="js-search-input" type="text" name="q" class="input-text search-input" autocomplete="off" placeholder="Search How-To Geek" autofocus="">
</form>

Name: articleNewsletterForm — POST

<form class="user-static-form user-content" enctype="multipart/form-data" id="articleNewsletterForm" method="post" name="articleNewsletterForm">
  <h2 class="newsletter-widget-title">The Best Tech Newsletter Around</h2>
  <p class="f-errors" id="f-validation"></p>
  <div class="form-group">
    <input maxlength="4000" id="newsletter-form-email" name="newsletter-form-email" placeholder="Email Address" required="" type="email">
  </div>
  <div class="form-group">
    <input class="main-cta primary-cta brand-cta" id="SubmitButton" name="SubmitButton" type="submit" value="Subscribe">
  </div>
  <div class="form-group">
    <p class="f-errors" id="newsletter-form-validation" style="margin-top: 1em; font-size: small; color: red"></p>
    <div class="g-recaptcha-container newsletter-form-captcha" hidden="">
      <div id="site_captcha_5"></div>
    </div>
  </div>
  <p class="content-note bottom-note">By subscribing, you agree to our <a href="/page/privacy-policy/">Privacy Policy</a> and may receive occasional deal communications; you can unsubscribe anytime.</p>
</form>

Text Content

HOW-TO GEEK

Newsletter
Log in
Trending Windows PC Optimization iPhone Android Streaming Deals
 * * Desktop
     * Windows
     * Mac
     * Linux
     * Chromebook
   * Mobile
     * Android
     * iPhone
     * Carriers
   * Hardware
     * Computer Hardware
     * Wi-Fi & Networking
     * Smart Home
     * eReaders
     * Audio
     * TVs
   * Web
     * Web Apps
     * Social Media
     * Computer History
     * Cyber Security
     * Google
     * Microsoft
     * Privacy & Security
   * Cutting Edge
     * EVs
     * Virtual Reality
     * AI & Machine Learning
     * Cryptocurrency
   * Lifestyle
     * Gaming
     * Streaming
     * Photography
     * DIY
   * Reviews
   * Buying Guides
   * Deals

 * Join Our Team
 * Newsletter
 * Advertise with us
 * Log in

 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 

 * Join Our Content Team
 * Home
 * Contact Us
 * Terms
 * Privacy
 * Copyright
 * About Us
 * Fact Checking Policy
 * Corrections Policy
 * Ethics Policy
 * Ownership Policy
 * Owned & Operated by Valnet Inc.


Copyright © 2024 www.howtogeek.com


 * Home
 * Microsoft Office


HOW TO MAKE A FAMILY TREE IN MICROSOFT EXCEL

By Sandy Writtenhouse
Published Oct 8, 2022


Create a family tree in Excel quickly and easily with these tips.


Readers like you help support How-To Geek. When you make a purchase using links
on our site, we may earn an affiliate commission. Read More.


QUICK LINKS

 * Use a Microsoft Excel Family Tree Template

 * Check Out Third-Party Family Tree Templates

 * Create a Family Tree From Scratch in Excel

Creating a family tree is a fun and interesting activity to do on your own or
with your family. It may even be homework for your child. Luckily, if you have
Excel, you can make a family tree easily.



We'll explain how to create a family tree with Microsoft's templates and show
you a few third-party templates for larger or more detailed family trees.

When you want to embrace your creative side, you'll also learn how to make a
family tree from scratch using Excel's built-in tools.


USE A MICROSOFT EXCEL FAMILY TREE TEMPLATE

Microsoft currently offers two different family tree templates for Excel. One
template is a basic three-generation family tree while the other allows you to
include photos of your family members.


FAMILY TREE GENERATOR

This first template includes tables for you to enter each generation into and
spots for spouses. Once you enter everyone on the Family Members sheet, click
"Create Family Tree" and jump to the Family Tree tab to see the finished
product.




The template is super easy to use and features lovely light colors.




PHOTO FAMILY TREE

This three-generation family tree template allows you to add your own photos.
Enter the names and birth years of each family member and use the Remove
Ancestors and Add Ancestors buttons for the number of people in your family.

To add a photo, right-click the placeholder, select "Change Picture," and find
the one you want.






CHECK OUT THIRD-PARTY FAMILY TREE TEMPLATES

Maybe you need a larger family tree that allows you to go back further than
three generations. Or, perhaps you'd like a template that offers room for more
details.

Here are a few options you can check out from Vertext42 and Free PowerPoint
Templates.


6-GENERATION FAMILY TREE TEMPLATE

This first template from Vertex42 allows you to include multiple generations and
photos of your family members.

Choose the sheet you want to use for six or seven generations and then add each
member of your family.



You can include whatever details you like below each family member's name, such
as their birth year and location. To insert a photo, right-click the image
placeholder, select "Change Picture," and locate the one you want to use.




FAMILY TREE TEMPLATE WITH PHOTOS

This template from Vertex42 features a more basic appearance but the photos are
larger for a wonderful overview of your family.

Start by adding your photos and details at the bottom and then work your way up
through the three generations of branches.



Again, simply right-click the image placeholders and pick "Change Picture" to
include your photos.


FAMILY TREE TEMPLATE FOR EXCEL

For a family tree that goes beyond just branches, check out this Family Tree
Template for Excel from Free PowerPoint Templates. You'll see a sheet for each
set of ancestors including parents, paternal grandparents, maternal
grandparents, and so on.

You can include photos, birth and death dates, locations, children with their
information, and notes.




Click the Back to Tree button at the top of that sheet or move to the Family
Tree tab to see the finished tree. The family tree also has buttons for Details
that open the corresponding sheet for each person.



If you want a family tree that gives you more room for additional details about
your family members, this is the template for you.




CREATE A FAMILY TREE FROM SCRATCH IN EXCEL

If you want to make your own family tree that you can customize to fit a
specific number of generations, you can create one from scratch.



Excel offers features and tools that make the process an enjoyable and creative
one.

Related: 7 Handy Microsoft Excel Features You May Have Missed

Open a blank workbook in Excel and head to the Insert tab. Select the
Illustrations drop-down arrow and pick "SmartArt."



When the SmartArt graphic window opens, pick "Hierarchy" on the left. You'll
then see a collection of organizational charts you can use for your family tree.

You'll see horizontal charts, those with rectangles or circles, and one that
uses pictures. To show an example, we'll use the Picture Organizational Chart.




Select the one you want, click "OK," and the SmartArt graphic pops into your
sheet. From there, you can use the SmartArt Design tab to spruce up the tree,
add more shapes for your family members, and change the colors.



Pick a text box to get started, such as the one at the top for your photo and
details. Click inside the text box and enter the information.

Alternatively, click the arrow on the left side of the chart to open the text
entry box and type the details there.




To add a shape for another family member, select a current text box and open the
Add Shape drop-down menu in the ribbon.

You can then add the shape after, before, above, or below. You can also use the
Add Assistant option for multiple marriages.



If you choose the Picture Organizational Chart, you can then either select the
image placeholder on the text box or in the text entry box on the left and
browse for your photo.




You can also make the family tree more attractive by removing the gridlines or
adding a picture background. There are plenty of options for customizing your
family tree in Excel, so have fun with it!

Related: How to Remove Gridlines in Microsoft Excel

Creating a family tree in Excel is super easy with templates and can be a
terrific creative project for you and your family if you make one from scratch.

Would you like to print and frame or share a copy of your family tree with
others? Learn how to print an Excel sheet with a background or how to set a
certain print area for the family tree on your sheet.




THE BEST TECH NEWSLETTER AROUND








By subscribing, you agree to our Privacy Policy and may receive occasional deal
communications; you can unsubscribe anytime.

Share Share Share Share Share
Copy
Email
Share

Share Share Share Share Share
Copy
Email
Link copied to clipboard
Related Topics
 * Microsoft Office
 * Microsoft Excel
 * Features
 * minimize

About The Author
Sandy Writtenhouse (600 Articles Published)





Close



RECOMMENDED ARTICLES

Chrome

GOOGLE CHROME'S SEARCH JUST GOT BETTER

Google is rolling out three new search features to Chrome.


AR

I'VE TRIED MOST SMART GLASSES (AND AR GLASSES JUST AREN'T READY YET)

As we inch closer to augmented reality in our glasses these are the current
products leading the way.


Cutting Edge

WHY I LOVE WORKING IN VR

Step into my virtual office.


Microsoft Excel

EXCEL OPENING BLANK DOCUMENTS? TRY THESE TIPS TO FIX THE PROBLEM

No more blank sheets!


Cutting Edge

MOBILE WORD, POWERPOINT, AND EXCEL NOW HAVE COPILOT (WITH A CATCH)

It might come for everyone soon, though.


Internet

WI-FI CONNECTED BUT NO INTERNET ACCESS? 10 TIPS TO FIX IT ON WINDOWS 11

Reconnect your device to the internet.




 * ANDROID


 * IPHONE

GOOGLE’S LATEST PIXEL FEATURE DROP ENHANCES YOUR PHONE AND WATCH

44 minutes ago

THUNDERBIRD FOR ANDROID CREEPS CLOSER WITH NEW ACCOUNT SETUP SYSTEM

2 hours ago

MOTOROLA STILL MAKES PHONES, AND THEY'RE PRETTY GREAT

2 days ago

IS IT STILL WORTH REPLACING THE DEFAULT ANDROID KEYBOARD?

3 days ago

5 AWESOME ANDROID WALLPAPER APPS TO FRESHEN UP YOUR PHONE

4 days ago

YOU CAN DITCH GOOGLE ASSISTANT FOR MICROSOFT’S COPILOT AI ON ANDROID

6 days ago
See More

SETAPP WILL BE AN ALTERNATIVE APP STORE FOR IPHONES

3 days ago

HOW TO COMPRESS A VIDEO ON IPHONE

Feb 23, 2024

WHAT IS REVERSE WIRELESS CHARGING?

Feb 22, 2024

HOW TO EXPORT APPLE NOTES ON AN IPHONE OR MAC

Feb 19, 2024

HOW TO SET UP RECURRING REMINDERS ON IPHONE AND IPAD

Feb 2, 2024

HOW TO OPEN THE HIDDEN SCIENTIFIC CALCULATOR ON IPHONE

Jan 31, 2024
See More


TRENDING NOW

HOW-TO GEEK'S BEST OF MWC 2024 AWARD WINNERS



TOP TECH DEALS: SAMSUNG THE FRAME 55-INCH TV, APPLE WATCH SERIES 8, GALAXY BUDS
2, AND MORE



VIVALDI 6.6 ADDS CHROME EXTENSIONS TO WEB PANELS




 * Join Our Content Team
 * Home
 * Contact Us
 * Terms
 * Privacy
 * Copyright
 * About Us
 * Fact Checking Policy
 * Corrections Policy
 * Ethics Policy
 * Ownership Policy
 * Owned & Operated by Valnet Inc.

Copyright © 2024 www.howtogeek.com

Now Playing

WATCH
NEXT
Video Player is loading.
Play Video
Play
Unmute

Current Time 0:00
/
Duration -:-
Loaded: 0%


Stream Type LIVE
Seek to live, currently behind liveLIVE
Remaining Time -0:00
 
1x
Playback Rate

Chapters
 * Chapters

Descriptions
 * descriptions off, selected

Captions
 * captions off, selected

Audio Track

Picture-in-PictureFullscreen

This is a modal window.


Advertisement





Skip Ad
5



Sign in with Google