How to "Fill Down" Until Infinity?

  • Thread starter Thread starter Julie P.
  • Start date Start date
J

Julie P.

Hi, is there anyway to have a formula which I have in a cell in the second
row of a worksheet to fill down the entire column of that worksheet, until
infinity? Right now, I have to highlight a portion of the column, and then
fill down. Then when this runs out, I have to do it again, which is
annoying.

Thanks!
 
Hi Julie

In the address box on your worksheet (located to the left of the formula
bar), type A2:C65536 (amend the range as necessary) to select that range.
Then select "Edit>Fill>Down"

--
XL2002
Regards

William

(e-mail address removed)

| Hi, is there anyway to have a formula which I have in a cell in the second
| row of a worksheet to fill down the entire column of that worksheet, until
| infinity? Right now, I have to highlight a portion of the column, and then
| fill down. Then when this runs out, I have to do it again, which is
| annoying.
|
| Thanks!
|
|
 
Another way:

Select your range first. (say A2:A9999)

Then write your formula for the activecell, but instead of hitting enter, hit
ctrl-enter. The selection will fill with that formula--and excel will even
adjust it just like you dragged it down.
 
William said:
Hi Julie

In the address box on your worksheet (located to the left of the formula
bar), type A2:C65536 (amend the range as necessary) to select that range.
Then select "Edit>Fill>Down"
Click to expand...


Hi William, Thanks. I tried it, but it didn't work. The only thing that
happened was that my formula was erased.
 
Dave Peterson said:
Another way:

Select your range first. (say A2:A9999)

Then write your formula for the activecell, but instead of hitting enter, hit
ctrl-enter. The selection will fill with that formula--and excel will even
adjust it just like you dragged it down.
Click to expand...

Hi Dave. Thanks. The problems with this is I already have the formula
entered in the cell. So I can't hit control+enter.

I actually tried this though, and somehow screwed it up. I copied the cell,
then entered the range, and then went to paste the formula in the formula
bar, but somehow I messed the formula up (it was adding new cells to the
formula), so I had to stop, and hit "undo".
 
It's impossible, with your formula in A2 and when you select A2:A65536 and
follow
the instructions if will work (of course you can short cut and use Ctrl + D
to do the same)
You must have done something else
Btw, do you really need 65536 rows for this?

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
You should really test things in a test sheet, once you have realized it
will work you can implement it.
If you already have a formula in A2, do the selection with A2 as the active
cell (only cell in the selection not high lighted)
press F2 and then enter with ctrl + enter works fine for me. Believe me when
I tell you, the suggestion you have received
will work, you just have to follow the directions (make sure A2 is the
active cell)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Peo Sjoblom said:
It's impossible, with your formula in A2 and when you select A2:A65536 and
follow
the instructions if will work (of course you can short cut and use Ctrl + D
to do the same)
You must have done something else
Click to expand...

Hi, what I did was enter my formula in D1. Then in the box to the left of
the formula bar (the formula bar is the one where the equal sign is,
right?), I entered "D1:D10", without the quotes. Then I went to edit > fill,
but the "fill down" option was grayed out, so I couldn't select it.
Btw, do you really need 65536 rows for this?
Click to expand...

No, someone else suggested that. I just need to do about 5000 cells, but I
prefer not to have to scroll down so far.
 
Peo Sjoblom said:
You should really test things in a test sheet, once you have realized it
will work you can implement it.
If you already have a formula in A2,
Click to expand...


do the selection with A2 as the active
cell (only cell in the selection not high lighted)
Click to expand...

Thanks Peo! Sorry to sound like a dork, but I do not know how to do the
above. I want to avoid having to highlight the entire cell range, since it
takes too long for me to scroll down about 5000 cells.
 
After you enter the range in the Name Box, press the Enter key
That will select the range that you entered in the Name Box

Then, click in the Formula Bar, and press Ctrl+Enter
 
Ok, follow this:

With the formula in A2,
in the name box type A2:A5000,
press enter to select and A2 will automatically be the active cell,
now press ctrl + D

Or with formula in D1, type D1:D5000, press enter,
D1 is automatically active now press ctrl + D

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Julie,

Select the cell containing the formula.
Press Ctrl Shift Down.
Press F2 (Edit mode).
Press Ctrl Enter.
 
Debra Dalgleish said:
After you enter the range in the Name Box, press the Enter key
That will select the range that you entered in the Name Box

Then, click in the Formula Bar, and press Ctrl+Enter
Click to expand...

yep it worked! Thanks so much Debra. Before, I hadn't been hitting "enter".
 
Peo Sjoblom said:
Ok, follow this:

With the formula in A2,
in the name box type A2:A5000,
press enter to select and A2 will automatically be the active cell,
now press ctrl + D

Or with formula in D1, type D1:D5000, press enter,
D1 is automatically active now press ctrl + D
Click to expand...


Hi Peo. thank you, and sorry for replying so late. You are right. As you and
Debra stated, I have to hit "enter" after you type the range.

Julie
 
Earl Kiosterud said:
Julie,

Select the cell containing the formula.
Press Ctrl Shift Down.
Press F2 (Edit mode).
Press Ctrl Enter.
Click to expand...


yet another way to do this. :) I guess I am learning a lot here. Thanks
Earl.

Julie
 
Back
Top