Select the range to get the formula
either via: Edit|goto, F5, or just typing the address in the NameBox (to the
left of the formula bar).

Type your formula for the activecell in that selection (usually the top
cell--unless you did something else)

But hit ctrl-enter instead of just enter.

The cells will be filled with the adjusted formula--just like dragging it down.

You can do this with just plain old constants, too.

Aoife101 wrote:

If you need to put a standard formula into a column with around 10000
rows, is there a quicker way of inputing the formula into each cell
rather than having to right click and drag your cursor down 10000 lines
or is that the quickest way????

Any handy tips would be great!!! Thanks

--
Aoife101
------------------------------------------------------------------------
Aoife101's Profile: http://www.excelforum.com/member.php...o&userid=35928
View this thread: http://www.excelforum.com/showthread...hreadid=563170

--

Dave Peterson