{"id":499421,"date":"2022-10-08T20:00:06","date_gmt":"2022-10-08T17:00:06","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-make-a-family-tree-in-microsoft-excel\/"},"modified":"2022-10-08T20:00:06","modified_gmt":"2022-10-08T17:00:06","slug":"how-to-make-a-family-tree-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-family-tree-in-microsoft-excel\/","title":{"rendered":"#How to Make a Family Tree in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a291c23de6c9\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a291c23de6c9\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-family-tree-in-microsoft-excel\/#%E2%80%9CHow_to_Make_a_Family_Tree_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Make a Family Tree in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-family-tree-in-microsoft-excel\/#Use_a_Microsoft_Excel_Family_Tree_Template\" >Use a Microsoft Excel Family Tree Template<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-family-tree-in-microsoft-excel\/#Family_Tree_Generator\" >Family Tree Generator<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-family-tree-in-microsoft-excel\/#Photo_Family_Tree\" >Photo Family Tree<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-family-tree-in-microsoft-excel\/#Check_Out_Third-Party_Family_Tree_Templates\" >Check Out Third-Party Family Tree Templates<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-family-tree-in-microsoft-excel\/#6-Generation_Family_Tree_Template\" >6-Generation Family Tree Template<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-family-tree-in-microsoft-excel\/#Family_Tree_Template_with_Photos\" >Family Tree Template with Photos<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-family-tree-in-microsoft-excel\/#Family_Tree_Template_for_Excel\" >Family Tree Template for Excel<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-family-tree-in-microsoft-excel\/#Create_a_Family_Tree_From_Scratch_in_Excel\" >Create a Family Tree From Scratch in Excel<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Make_a_Family_Tree_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Make a Family Tree in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone wp-image-829342 size-full\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2018\/06\/excel-header.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Excel Logo on Windows Blue Background.\" width=\"1200\" height=\"675\"\/><\/p>\n<p>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.<\/p>\n<p>We\u2019ll explain how to create a family tree with Microsoft\u2019s templates and show you a few third-party templates for larger or more detailed family trees.<\/p>\n<p>When you want to embrace your creative side, you\u2019ll also learn how to make a family tree from scratch using Excel\u2019s built-in tools.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_a_Microsoft_Excel_Family_Tree_Template\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_0\">Use a Microsoft Excel Family Tree Template<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Microsoft currently offers two different family tree <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/templates.office.com\/en-us\/charts\">templates for Excel<\/a>. One template is a basic three-generation family tree while the other allows you to include photos of your family members.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Family_Tree_Generator\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Family Tree Generator<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/templates.office.com\/EN-US\/family-tree-generator-TM89758537\">first template<\/a>\u00a0includes tables for you to enter each generation into and spots for spouses. Once you enter everyone on the Family Members sheet, click \u201cCreate Family Tree\u201d and jump to the Family Tree tab to see the finished product.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833556\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/MSFamilyTreeGeneratorMembers-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft family tree template member sheet\" width=\"650\" height=\"352\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The template is super easy to use and features lovely light colors.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833555\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/MSFamilyTreeGenerator-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft family tree template\" width=\"650\" height=\"267\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Photo_Family_Tree\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Photo Family Tree<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This three-generation\u00a0<a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/templates.office.com\/EN-US\/photo-family-tree-TM88904269\">family tree template<\/a> allows you to\u00a0add 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.<\/p>\n<p>To add a photo, right-click the placeholder, select \u201cChange Picture,\u201d and find the one you want.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833554\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/MSPhotoFamilyTree-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft photo family tree template\" width=\"621\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Check_Out_Third-Party_Family_Tree_Templates\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Check Out Third-Party Family Tree Templates<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe you need a larger family tree that allows you to go back further than three generations. Or, perhaps you\u2019d like a template that offers room for more details.<\/p>\n<p>Here are a few options you can check out from Vertext42 and Free PowerPoint Templates.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6-Generation_Family_Tree_Template\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_4\">6-Generation Family Tree Template<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/redirect.viglink.com\/?key=204a528a336ede4177fff0d84a044482&amp;u=https%3A%2F%2Fwww.vertex42.com%2FExcelTemplates%2Ffamily-tree-template.html&amp;cuid=xid:{xid}&amp;___trxnet=vg\">first template from Vertex42<\/a>\u00a0allows you to include multiple generations and photos of your family members.<\/p>\n<p>Choose the sheet you want to use for six or seven generations and then add each member of your family.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833560\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/Vertex426Generation-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Vertex42 6-generation family tree template\" width=\"650\" height=\"460\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can include whatever details you like below each family member\u2019s name, such as their birth year and location. To insert a photo, right-click the image placeholder, select \u201cChange Picture,\u201d and locate the one you want to use.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Family_Tree_Template_with_Photos\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_5\">Family Tree Template with Photos<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This\u00a0<a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/redirect.viglink.com\/?key=204a528a336ede4177fff0d84a044482&amp;u=https%3A%2F%2Fwww.vertex42.com%2FExcelTemplates%2Ffamily-tree-template.html&amp;cuid=xid:{xid}&amp;___trxnet=vg\">template from Vertex42<\/a>\u00a0features a more basic appearance but the photos are larger for a wonderful overview of your family.<\/p>\n<p>Start by adding your photos and details at the bottom and then work your way up through the three generations of branches.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833559\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/Vertex42WithPhotos-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Vertex42 photo family tree template\" width=\"650\" height=\"494\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Again, simply right-click the image placeholders and pick \u201cChange Picture\u201d to include your photos.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Family_Tree_Template_for_Excel\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_6\">Family Tree Template for Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For a family tree that goes beyond just branches, check out this <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.free-power-point-templates.com\/articles\/family-tree-template-for-excel\/\">Family Tree Template for Excel<\/a> from Free PowerPoint Templates. You\u2019ll see a sheet for each set of ancestors including parents, paternal grandparents, maternal grandparents, and so on.<\/p>\n<p>You can include photos, birth and death dates, locations, children with their information, and notes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833558\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/FPPTMembers-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"FPPT family tree template members sheet\" width=\"493\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>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.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833557\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/FPPTFamilyTree-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"FPPT family tree template\" width=\"520\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want a family tree that gives you more room for additional details about your family members, this is the template for you.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_a_Family_Tree_From_Scratch_in_Excel\"><\/span>Create a Family Tree From Scratch in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>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.<\/p>\n<p>Excel offers <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/807862\/handy-excel-features\/\">features and tools that make the process an enjoyable and creative one.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>7 Handy Microsoft Excel Features You May Have Missed<\/em><\/strong><\/p>\n<p>Open a blank workbook in Excel and head to the Insert tab. Select the Illustrations drop-down arrow and pick \u201cSmartArt.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-833568 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/IllustrationsSmartArt-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"SmartArt in the Illustrations menu\" width=\"649\" height=\"280\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the SmartArt graphic window opens, pick \u201cHierarchy\u201d on the left. You\u2019ll then see a collection of organizational charts you can use for your family tree.<\/p>\n<p>You\u2019ll see horizontal charts, those with rectangles or circles, and one that uses pictures. To show an example, we\u2019ll use the Picture Organizational Chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833562\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/SmartArtGraphics-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"SmartArt Graphics window\" width=\"650\" height=\"369\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select the one you want, click \u201cOK,\u201d 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.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833561\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/SmartArtDesignTab-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Picture organizational chart in Excel\" width=\"650\" height=\"247\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>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.<\/p>\n<p>Alternatively, click the arrow on the left side of the chart to open the text entry box and type the details there.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833566\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/TextEntryBox-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Text entry box for a SmartArt graphic in Excel\" width=\"650\" height=\"277\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To add a shape for another family member, select a current text box and open the Add Shape drop-down menu in the ribbon.<\/p>\n<p>You can then add the shape after, before, above, or below. You can also use the Add Assistant option for multiple marriages.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833565\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/AddShape-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add a shape to the SmartArt graphic\" width=\"650\" height=\"479\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>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.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-833564\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/AddPhotos-ExcelFamilyTree.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Photos added to the family tree in Excel\" width=\"650\" height=\"311\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>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!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Remove Gridlines in Microsoft Excel<\/em><\/strong><\/p>\n<p>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.<\/p>\n<p>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\u00a0or how to set a certain print area for the family tree on your sheet.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/833544\/how-to-make-a-family-tree-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Make a Family Tree in Microsoft Excel&#8221; 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\u2019ll explain how to create a family&#8230;<\/p>\n","protected":false},"author":1,"featured_media":499422,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2018\/06\/excel-header.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-499421","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/499421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=499421"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/499421\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/499422"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=499421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=499421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=499421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}