Is there a Formula Fill Command (besides the little box in the bottom corner of cell)?

[stebro1]

Hello All,

I'm looking for a quick and easy way to fill a formula in cell A1 through the next 1500 rows. So instead of dragging all the way down to row 1500 can I somehow use a fill command to populate my formula in range A1:A1500?

Thank you.

[Bernie Deitrick]

Fill in your formula in A1, and press Enter. Then press Ctrl-G, type A1:A1500 in the Reference box, click OK, then press F2, and finish with Ctrl-Enter.

Or use a macro: this will copy the activecell to match the column to the right:

Please Login or Register  to view this content.

[ChemistB]

Or instead of using the GoTo window (CNTRL G), just type your range into the Name box (where you normally see the Cell reference (i.e. A1).

If you have data in either column to left or right of the formula you are entering, you can double click on the fill to auto fill all the way down to the end of the data.

[Ron Coderre]

Maybe something like this:

• Press F5
...Type: A1:A1500...Press: ENTER
(That range will be selected, with A1 as the active cell)
• Enter your formula in cell A1
Example:
=TODAY()-ROW()
...Hold down CTRL and press ENTER (instead of just pressing ENTER)
That formula will be entered in each selected cell, incrementing the row number.

Is that something you can work with?