- Feb 11, 2006
Hello all! I have searched here and elsewhere, and can not find a solution to what seems like a very simple problem. I have a formula in a cell, and need to drag it across the row and have it increment. The formula is =A1, and when I drag it across the row I want it to show =A2, =A3, =A4, etc. When I try to just drag it, I get =B1, =C1, =D1, etc. Anyone have a simple solution to this? Or a tool that can do this (ASAP, ExTools, etc.)? Thanks for any suggestions!