Excel Formulas and Functions - Whitman College

Using AutoFormat. You can use Excel’s auto-formatting feature to apply shading and fonts in predetermined formats. Open the worksheet you want to format. (Note: if you have blank rows in the worksheet, you need to select the cells you want to format.) ... To make a cell reference absolute, type a $ before the column and row references to ... ................
................