For this procedure to work, you must know, before hand, the cell reference
of the last cell in the range to copy to.

Enter formula in top left cell of proposed range.
Select that cell.
In the name box, enter bottom left cell of range to copy to.
Hold <Shift, and hit <Enter.

This only selects the proposed range, and leaves the focus in the cell
containing the formula.

Now, perform the copy to this range by:

While range is *still* selected,
Hit <F2
Then hold <Ctrl
And hit <Enter.


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"sjSQW" wrote in message
...
Thanks for that, but that method is just for selecting a range of cells, not
dragging to extend a series.

Have you got any other ideas?

"Jon Peltier" wrote:

Click the cell in the top left corner, scroll to the bottom right corner,
hold Shift and select this corner cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"sjSQW" wrote in message
...
In Excel, it is possible to drag a cell down (or across) to extend a
series
(e.g. a formula) by selecting the cell and using the square in the
bottom
right of the cell.

This is fine for relatively small numbers of cells. But is there a quick
way
of extending a series across a large number of cells without just being
very
patient?