{"id":87471,"date":"2020-10-12T13:24:26","date_gmt":"2020-10-12T10:24:26","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-make-a-title-line-on-an-excel-spreadsheet\/"},"modified":"2020-10-12T13:24:26","modified_gmt":"2020-10-12T10:24:26","slug":"how-to-make-a-title-line-on-an-excel-spreadsheet","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-title-line-on-an-excel-spreadsheet\/","title":{"rendered":"#How to Make a Title Line on an Excel Spreadsheet"},"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-6a2a39df16d6f\" 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-6a2a39df16d6f\" 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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-title-line-on-an-excel-spreadsheet\/#Adding_a_Header_in_Excel\" >Adding a Header in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-title-line-on-an-excel-spreadsheet\/#Adding_an_Always-Visible_Top_Row\" >Adding an Always-Visible Top Row<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Make a Title Line on an Excel Spreadsheet&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-401979 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/01\/xoffice_excel_lede-1.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.Bi7kk-HHRf.png\" alt=\"Microsoft Excel Logo\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>There are several ways to add a customized title to a spreadsheet in Microsoft Excel. Titles aren\u2019t just for file names\u2014you can place one right above your spreadsheet data so viewers can understand it more easily.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Adding_a_Header_in_Excel\"><\/span>Adding a Header in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To add a header title, click the \u201cInsert\u201d tab at the top left of the workbook.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-691554 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/insert.png.pagespeed.ce._OfQSOeT9q.png\" alt=\"Clicking &quot;Insert&quot; on the Excel ribbon.\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click the \u201cText\u201d menu toward at the right side of the ribbon and click the \u201cHeader &amp; Footer\u201d option.<\/p>\n<p>You\u2019ll be zoomed out from the workbook, allowing you to see all of your data on one page. We\u2019ll cover how to get back to the normal view in a moment.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-691557 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xprint-screen.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.UcIIQaKwkc.png\" alt=\"Click &quot;Text&quot; and click &quot;Header &amp; Footer&quot;\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click anywhere within the \u201cHeader\u201d section and type in your text.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-691552 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xheader.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.GObkqJ4NZG.png\" alt=\"Typing a spreadsheet header in Excel\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To return to the default workbook view, click the \u201cNormal\u201d page layout icon at the bottom of the document.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-691556 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xnormal.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.-7A48M7HrH.png\" alt=\"Click the &quot;Normal&quot; page layout button in Excel\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you return to the \u201cNormal\u201d workbook view, you\u2019ll notice that your text doesn\u2019t <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ear. In Excel, these headers don\u2019t appear while you\u2019re working in the workbook, but they will appear once it\u2019s printed. If you\u2019re looking for a title line that always appears, keep reading.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Adding_an_Always-Visible_Top_Row\"><\/span>Adding an Always-Visible Top Row<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To add an always-visible title, you can place it in the top row of your spreadsheet.<\/p>\n<p>First, right-click anywhere inside cell A1 (the first cell at the top left of your spreadsheet), and choose \u201cInsert.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-691548 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xa1-title.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.AzwQ1rhrer.png\" alt=\"Selecting the A1 cell in Microsoft Excel\" width=\"1377\" height=\"637\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select \u201cEntire Row\u201d and click \u201cOK\u201d to add a row of free space.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-691550 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xentire-row.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.ipWTZh0wWr.png\" alt=\"Click &quot;Entire row&quot; and click &quot;OK&quot;\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Type the title for the spreadsheet anywhere in the new row. The exact cell you choose doesn\u2019t matter, as we\u2019ll be merging them in just a second.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-691548 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xa1-title.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.AzwQ1rhrer.png\" alt=\"Typing a header into the A1 cell\" width=\"1377\" height=\"637\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Highlight the section of your new row that you want to center your title in. In this case, we\u2019ll highlight from A1 to E1, centering our title within the top row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-691553 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xhighlight.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.7CaHsv2yH9.png\" alt=\"Selecting multiple cells in Excel\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click the \u201cHome\u201d header in the ribbon and click \u201cMerge &amp; Center.\u201d Your text should now be centered within the new row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-691555 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/09\/xmerge-center.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.X72BIoBlsc.png\" alt=\"Click &quot;Merge &amp; Center&quot; in Excel\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>That\u2019s it\u2014you can use these techniques to quickly add headers to your Excel spreadsheets in the future.<\/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>\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 noreferrer\">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 noreferrer\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/691547\/how-to-make-a-title-line-on-an-excel-spreadsheet\/\" target=\"_blank\" rel=\"noopener noreferrer\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Make a Title Line on an Excel Spreadsheet&#8221; There are several ways to add a customized title to a spreadsheet in Microsoft Excel. Titles aren\u2019t just for file names\u2014you can place one right above your spreadsheet data so viewers can understand it more easily. Adding a Header in Excel To add a header&#8230;<\/p>\n","protected":false},"author":1,"featured_media":87472,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/thumbcache\/2\/200\/aeb6f98ebfd272127bcaa63cac955e64\/wp-content\/uploads\/2019\/01\/office_excel_lede-1.png","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-87471","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\/87471","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=87471"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/87471\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/87472"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=87471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=87471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=87471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}