FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Click the worksheet where you want to choose header and footer options. On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. Click the left, center, or right header or footer text box at the top or the bottom of the worksheet page.

Detailed explanation-2: -On the status bar, click the Page Layout View button. Select the header or footer text you want to change. On the Home tab in the Font group, set the formatting options that you want to apply to the header / footer. When you’re done, click the Normal view button on the status bar.

Detailed explanation-3: -Headers and footers display only in Page Layout view and on printed pages. Select the worksheet you want to add a header or footer to. Click the Insert tab, and click Header & Footer. This displays the worksheet in Page Layout view.