You can also copy a formula to a non-adjacent cell. To do that, select the cell containing the formula that you want to copy.