In the name box, that "box" immediately above column A and at the far left
of the formula bar, type in the range then hit ENTER. For example, type
A1:B100 then hit ENTER.

The top left cell will be the active cell. The active cell is the one cell
in the selected range that is not shaded.

Type in your formula then, instead of hitting ENTER like you normally would,
hold down the CTRL key then hit ENTER.

--
Biff
Microsoft Excel MVP


"ManhattanRebel" wrote in message
...
I have a formula in a cell and would like to apply it to a large range of
cells. Is there a easy way to do this? The area is too large to click and
drag.