Expanding a formula from a cell to a range

  • Thread starter Thread starter ManhattanRebel
  • Start date Start date
M

ManhattanRebel

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
 
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.
 
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?
 
Thank you that is exactly what I need to know.

T. Valko said:
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.
 
Back
Top