Adding Formula to Cell with Data

  • Thread starter Thread starter GatorGirl
  • Start date Start date
G

GatorGirl

Column A has hard coded data. I need to add to the hard coded data figure
another cell. I do not want to insert a new column or change the format of
my worksheet. How can this be done without manually adjusting each cell?
 
What type of data in the cells?

If numbers and you want to add 10 to each, enter 10 in an empty cell.

Copy then select the range to change and Edit>Paste Special>Add>OK>Esc.

If something else and you don't want a helper column and you don't want to
adjust each cell then a macro would seem to be in order.

More details and we could tailor something.


Gord Dibben MS Excel MVP
 
Back
Top