Questions

microsoft excel paramveer 2

Tags:
+
0 Votes
Locked

microsoft excel paramveer 2

Captain Paramveer
In Excel, if I copy a cell containing a formula down the column to copy to adjustment rows, i need formula increase sequentially for example if a1 = 5, a1 =2, a3= 4 and then i use coloum no. m4 =a1 i.e. 5 but when i copy m4 paste it on m6 the result is m6=a3 i.e. 4 but i need m6=a2 how can i copy formula