Question Discussion & Solution

The Format Painter copies formatting from one place and applies it to another.
The Format Painter button on the standard toolbar in Excel 2003 and earlier version.
Home tab, in the Clipboard group, click Format Painter in 2007 and higher version.

The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.

When we want to scroll down the worksheet, and lock the heading rows in place, so it is always visible, we can use one of the Freeze Panes commands.

If we need to remove only the formatting done in a range, we must use From Edit menu choose Clear and then Formats.