Copying formulas

  • Thread starter Thread starter Liam T
  • Start date Start date
L

Liam T

Hi,
I want to copy a formula down a column into cells which
alraedy have a value. I don't want the formula to populate
blank cells in the column. Is there some way I can do this
without having to (1)only copy the formula to the cells I
want populated or (2) copying the formula to all cells and
then going back to delete the formula from the cells that
I want to keep blank.
Thanks
 
Hi

You could use Data / Filter / Autofilter to show non-blanks. Then fill down
your formula.
 
If the 'value' in the cells you want to change is a constant then:
Select th entire region
Goto (press F5)/Special/constants/OK
Now the relevant cells will be selected
Type the new formula (in the now active cell, make the formula logic relative to the active cell) and confirm with Ctrl + Return
If the old cell contents were formula then chose 'formulas' instead of 'constants after pressing F5
HTH
 
Back
Top