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?

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

microsoft excel

## 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. PressUP ARROW, thenCTRL+SHIFT+RIGHT ARROW, thenDOWN ARROW, thenCTRL+SHIFT+LEFT ARROW, then paste._{Note: this assumes the columns from A to NTP have continuous data with no gaps}