Drag Fill Formula Horizontally

Hugh McKinney

I am trying to find a way to drag fill formula horizontally so the formula updates the column name in the fomula as it is drag filled horizontally. Drag fill horizontally only copies the original formula across the cells... Am I missing something or is the drag fill function only posible if you drag fill vertically.

Thanks

Adam Overton

I don't know why this isn't a thing. You can copy the formula in the first column, and then select all those columns to the right and paste and get the correct relative formulas instead.