Changing a Formula

[Skip]

In my workshhet I add three columns. I would like to delete one of the
columns in a new worksheet. And add only two of the three.
I know I can delete a colum, but in the formula all three cloumns
remain. Is there a way I can delete that column from the formula ,
without editing each formula one by one?
Thanks

[davesexcel]

if you highlite the range for the formula, type in the formula once, then hit Ctrl Enter, this will enter the formula in all the highlited cells and will reference accordingly