I have a spreadsheet with a column of formulas. These formulas have some variations from row to row but they all end with "$9880". I want to add a relative reference "+e6" to these formulas. The trick is I want the relative reference to start at E6 but then on the next row it needs to be E7, then E8 and so on. Is there a way to do some kind of replace function that would be similar to 'find and replace' that would accomplish this? Thanks for your help. Joe ->

Assuming the formulas are in consecutive cells in a column, put in the E6 in the cell where it belongs and then place the cursor over the dot at the lower right corner of the cell and double-click when it turns to a cross. That should autofill all the cells woth the proper formula. If nothing happens with the double-click, you can single-click and drag to get the same result.