Header and Footer in excel.pptx

header and footer

1. Header and Footer in excel 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.

2. Header and Footer in excel Go to the Insert tab > Text group and click the Header & Footer button. ... Now, you can type text, insert a picture, add a preset header or specific elements in any of the three Header boxes at the top of the page. ... When finished, click anywhere in the worksheet to leave the header area.

3. Find and Replace The Find and Replace feature of Excel looks for a data value and replaces it with another data value. This data value can be a text string, number, date or special character. The Find and Replace feature can search within a worksheet or workbook, by rows or columns, and within formulas, values or comments.

4. New Perspectives on Microsoft Excel 2010 6 Using the Conditional Formatting Rules Manager A conditional formatting rule specifies: Type of condition Type of formatting when that condition occurs Cell or range the formatting is applied to Use Conditional Formatting Rules Manager dialog box to edit existing conditional formatting rules

5. Using the Conditional Formatting Rules Manager New Perspectives on Microsoft Excel 2010 7

6. Using the Conditional Formatting Rules Manager New Perspectives on Microsoft Excel 2010 8

7. Using the Conditional Formatting Rules Manager New Perspectives on Microsoft Excel 2010 9