Print Titles in Excel Print titles is used to print rows and columns on every page, making the printed document easier to read. Below are the steps to do this. 1. Click Page Layout and then click Print Titles. 2. In the dialog box, if you want the second row to be printed on each … Read more
Insert Page Numbers in Excel To insert page numbers in Excel, follow the steps below. 1. Click View tab -> Page Layout. 2. Click on the “Click to Add Footer” area at the bottom of the sheet. 3. On the Design tab, click Page Number. Note: Excel adds a Page variable in the footer so … Read more
Header and Footer in Excel In this lesson, you will learn how to add header and footer information at the top and bottom of each printed page, respectively. To insert a header, follow the steps below. 1. Click the Page Layout on the View tab. 2. Click Add header and then, from the Design tab, … Read more
