Formula for the current row in Excel

Question

I want to create a formula that allows me to select the data for column E and the row I am currently on (eg 64). Is there a formula for the current row I am on so I can copy and paste it? I want to data to go into various columns so I can't just extend out the formula.

Thanks!

Harry

Answer 1

You could opt for R1C1 reference style (Options > Formulas > Working with formulas).