Hi Katherine
Use Find and Replace for this problem.
If the formula is the same all the way down the column, say A1+B1, A2+B2,
etc, just change the first one then drag the new formula down as far as
required.
HTH
Michael
"Katherine" wrote:
Hi,
I have a series of different sums in the same column which contain the
correct row numbers but not the correct column letter (they contain "E" when
I want them to say "C"; e.g. =SUM(E10:E13) instead of =SUM(C10:C13)). Rather
than going through them one by one manually, is there a quick way to change
all the sums in that column to say "C" with their respective row numbers?
Thank you,
Katherine
|