Inserting formulas into column with >10,000 rows

  • Thread starter Thread starter agbiggs
  • Start date Start date
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Cell with IF Formula 0
Macro to insert a line when a value changes in a range 1
Macro to fill down automatically the number of rows in a spreadsheet 1
Inserting a Copied Row inside a table 6
Recalculate formula 2
adding rows into the table 1
Inserting rows into sheet that contains a formula 2
need to have SUM formula update on row add/delete/move - Excel 2003 14

Back
Top