CODEWITHSUNDEEP
excelexcel-formula
vrbilgi
vrbilgi

Reputation: 5793

generic forumula to calculate based on row number

For some reason I am calculating result of (A1/B1)*60....(A./B.)*60....up to (An/Bn)*60 This calculation starts for A1 B1 postion to An Bn and result I want to store in C1 to Cn.

Currently I am adding my formula in coloum C. As the number n is big I want to reduce my effort by doing some quick hack.

Any advice.

Upvotes: 0

Views: 1853

Answers (1)

BonyT
BonyT

Reputation: 10940

1) add formula to C1

2) Select C1 with the mouse and copy it

3) without clicking on the spreadsheet cells, scroll down the sheet until you get to the last row you want the formula in.

4) hold down shift and click Cn cell

5) paste

Upvotes: 2

Related Questions