You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"ManhattanRebel" wrote in message
...
Thank you that is exactly what I need to know.

"T. Valko" wrote:

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.