G
Guest
I'm trying to copy a group of calculations (say A1 to A10) to another
location in the same workbook (say D11 to D20) while having the cells
referred to by the calculations stay the same.
For ex., I want the calculation 'B1+C1' in cell 'A1' to still refer to 'B1'
& 'C1' when it is moved to 'D11' (usually the calc would refer to cells 'B11'
& 'C11'). Can I do this without having to use $'X'$'#' ?. Is there a
keyboard shortcut?
Thanks
location in the same workbook (say D11 to D20) while having the cells
referred to by the calculations stay the same.
For ex., I want the calculation 'B1+C1' in cell 'A1' to still refer to 'B1'
& 'C1' when it is moved to 'D11' (usually the calc would refer to cells 'B11'
& 'C11'). Can I do this without having to use $'X'$'#' ?. Is there a
keyboard shortcut?
Thanks