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.

Why dont you edit the formula using F2. A continuous range is referred as
below..

10 Colums x 5 rows

Range(A1:J5)

If this post helps click Yes
---------------
Jacob Skaria


"ManhattanRebel" wrote:

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.

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.

Jacob thank you, this will be a big help but I cant figure out where to
insert range information.. say my formula =1+2.. where do I insert range
information into formula to make it work?

"Jacob Skaria" wrote:

Why dont you edit the formula using F2. A continuous range is referred as
below..

10 Colums x 5 rows

Range(A1:J5)

If this post helps click Yes
---------------
Jacob Skaria


"ManhattanRebel" wrote:

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.

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.

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.