Inserting formulas into column with >10,000 rows

A

agbiggs

I have two very 'tall' columns of data (>10k rows) and I'd like to
insert a third column calculating the difference between the first two.
Ordinarily I'd just insert the formula into the top row and drag it
down, but with 10k rows this takes a very long time. Is there a better
way to do this than to drag down the formula? Thanks!

Andrew
 
A

Ardus Petus

Select B1
Press Ctrl-Down arrow (you get to the end of column B)
Press Right-arrow (select an empty cell)
Enter your formula + hit Rterurn
Press Ctrl-Shift-Up-arrow
Press F2 then Ctrl-Enter

Et voila!

HTH
 
G

Gord Dibben

Andrew

Hover the mouse pointer over the bottom right corner of the cell with the
formula(C1?)

When pointer turns to a black cross, double-click to copy formula down 10k rows.


Gord Dibben MS Excel MVP
 
Top