Hello redb-

Select the cells containing your "=BB30" formulae. Go to the Edit Bar and
change the row ref to =BB35 and hold the Ctrl key while you press Enter.

HTH |:)

"redb" wrote:

In column A, I have a number of formulae that refer to other cells on the
worksheet. For example, in A1, the formula is = BB30, A2=BD30, A3=BG30, etc.
In these formulae, the columns are all different, but the row number is
always the same.

However, I need to update the formulae to reflect a new row, so that
A1=BB31, A2=BD31, A3=BG31. The old column references will stay the same, and
the row references will all be the same number. Is there a way to do this
quickly and easily for a large number of formulae?

Thanks!