Excel – apply a formula to a very long column excel WITHOUT dragging

microsoft excel

I would like to apply the formula n/log(n) to a very large number of inputs in excel. specifically across a column with 10,000 numbers in it. What is the most efficient way to do this without dragging?

Best Answer

Assuming your column 1 has 10,000 numbers (columns A-NTP) and you want to paste a formula in row 2 to the range A2:NTP2:.

With your A2 formula selected, copy it. Press UP ARROW, then CTRL+SHIFT+RIGHT ARROW, then DOWN ARROW, then CTRL+SHIFT+LEFT ARROW, then paste.

enter image description here

Note: this assumes the columns from A to NTP have continuous data with no gaps