filling formulas down a lot of rows

  • Thread starter Thread starter ncf
  • Start date Start date
N

ncf

I am trying to get a shortcut to filling a formula down
600 rows. Is there any way to do it short of physically
dragging it by the handle or physically highlighting and
filling down in all the rows you want it to go down?
Thanks.
 
Have you tried using the keyboard? Just copy it with CTRL-C, then hold shift
and hold down PageDown until you get to 600 or near abouts, then release all
keys, and press CTRL-V. Then arrow key up or something else to unselect the
range.

Another thing you can do is select where you want the formulas to be (all
cells that will contain the formula), press = to begin the formula, type it
in, then press CTRL enter and it will be distributed along that range.
 
I was trying to save time by not highlighting all 600
rows. I know that when you fill down in a series, you can
specify where you want to stop. I was wondering if it
could be done with a function that is being spread down
600 rows.
 
Hmm. I value efficiency myself, but copying formulas down is not something
I'd ever thought took too long.

You can write an easy/intermediate macro which upon running would;
1) pop up a box asking you how many rows you want to copy from current
location.
2) copy into memory the current cell
3) select a range the size you inputed in the box (like
ActiveCell.Offset(RowsToPaste, 0).Select)
4) paste


Good luck.
 
Put the formula in the first cell and then hover the mouse over the bottom right
of the cell (The little cross bit) and then double click.
 
Thanks. My students are going to State contest next week
and the test is always very, very long and involved, and
is only 30 minutes in duration. I'm trying to find ways
to shorten some of the types of problems that appear
frequently in the state tests (fill the formula down 1066
rows, etc.) It doesn't take too long, but when you have
lots to do, that could make the difference in finishing
and not finishing the test. Thanks again.
 
Sorry, I don't know what you mean by double click on it.
How will it know how many rows I want it to go down
(unless I highlight them or spread them physically by
hand using the bottom right cross, which I would like to
avoid). I wanted something like the FILL, SERIES
capability which tells Excel how far down you want to go
before you stop.
 
Did you try this??

If you have 10,000 cell sof data in Col A and you put a formula in the first
cell in Col B and then double click where I said to, then it will fill down
automatically whilst there is data in the column next to it.
 
Thank you. The key was that there must be something in
that first column already. That was the part I didn't
understand. Thanks so much.
 
Back
Top