Thus, it is difficult to ascertain the values contained in your. When scrolling down, the headers disappear. Customize the header information in the dialog box that appears.Īlternatively, you can also manually insert a header or footer by clicking at the blank area at the top or bottom of the page while your are viewing from Layout -> Page Layout mode. Assuming you have numerous rows of data in excel. Click the Home tab to apply formatting to the text (font, bold, underline, or color).
Type the desired text in the appropriate box.Ħ. Choose where you want the text to be, left, center or right aligned.ĥ. Click in the area marked Click to add header or Click to add footer.Ĥ. Headers and footers can be located on the left, middle or center of the page. Often page numbers, dates, categories are included. In Excel, you can place a header and footer upon your worksheet to add extra information and assist with sorting. Select the position in the header section or footer section, and click. This method works for Excel 2007, 2010, and 2011 for Mac. Click Insert > Header & Footer to activate the Header & Footer Tools. With newer versions of Excel, it is much simpler to add a header and/or footer to your worksheet. Previous versions of Excel required you to utilize a dialog box to add or modify the header and footer.
