# Excel spread sheet : related to formula copying

 PF Gold P: 5,458 There is a simple copy paste for that. Write the formula in the first cell. Note that there is a little black dot in the lower right corner of the cell where the cursor is. Aim the mouse on that and the pointer changes to a small cross. Now drag the mouse over all the cells where you want the formula copied. Note that the relative geometry of the copies stay in tact. so if you drag the formula =a6*a7 one to the right and one down, the copy will read =b7*b8 etc If you want absolute geometry, you put a $before the row or column that should remain pointing to the same column ($b6) or row (b$6) or both ($b$6) if the copy needs to look at the single cell only.  P: 93 Excel spread sheet : related to formula copying Andre, thanks for the reply. Here neither I need neither the absolute addressing nor the relative addressing. Basically in the new table (except the first row and the first column) every other cell is to be replaced by the product of corresponding cell in the original table, the first cell of the corresponding row and the first cell of the corresponding column in which this cell sits. So it changes with each cell but NOT in the relative fashion.  P: 93 Thank you, very much, Andre. I got it now and it is working. I was thinking that we can use$ in singly like $A37. Now I realised we could used like A$37 too.