Is it possible to put in cell A1 a formula like "=B1" and then drag that formula down to A2 and have the formula change to "=C1" and if I continue to drag down in column A it would continue to shift the formula horizontally to "=D1","=E1", etc. I find myself having to do this sort of thing a lot where in cell A1 I click auto sum and then reference the cell I want it to sum but instead of dragging the formula down I have to then hit auto sum again and then click the cell to the right of the previous cell I want to reference.
Bookmarks