On the view tab, in the workbook views group, click page layout, to switch to page layout view. Go to insert > header & footer. B) in the page setup dialog box that comes up, select header/footer tab. In the page setup dialog box, on the header/footer tab, click custom header or custom footer. At the top of the excel window, you’ll find the excel ribbon menu with many tabs. Click on the insert tab. Web on the page layout tab, in the page setup group, click the dialog box launcher next to page setup. To specify where in the. Web a) click on print titles under page layout. Click the worksheet where you want to add or change headers or footers.
Excel displays the worksheet in page layout view. To specify where in the. Web go to a specific worksheet, like sheet1. Excel displays the worksheet in page layout view. Within the insert tab, locate the text group. C) in the footer dialog box that comes up, to get footer of the. Web add or change headers or footers in page layout view. On the header & footer tab, in the header & footer elements group, click. Click on the insert tab. Web on the page layout tab, in the page setup group, click the dialog box launcher next to page setup. B) in the page setup dialog box that comes up, select header/footer tab.