Quickest way to input formulas?

A

Aoife101

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

Any handy tips would be great!!! Thank
 
K

Ken Johnson

Hi Aoife,

If the formula's column is immediately adjacent a column with data that
reaches down that far then double clicking when the cursor changes to
the finer filldown cursor will fill down the same number of rows as the
data in the adjacent column.

If the above condition doesn't apply then select the top cell with the
formula then go
Edit|Go to... type the address of the last cell for the formula into
the Reference box, then hold down the Shift key while you click
OK|Control + D|Control + Up Arrow to return to top of sheet.

Ken Johnson
 
D

Dave Peterson

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.
 
Top