- Sep 22, 2006
I'm using Excel 2003, Windows XP. In an 8 row chart that I've created on my spreadsheet, all the IF formulas in the first row refer back to cell A1, the next row to A11, the next to A21, and so on. I want to copy and paste this chart again a few rows below the first one (for printing purposes) and have the formulas in the first row now refer to cell A2, the second to A12, the third row to A22, and so on. Is there any way to accomplish this without manually changing each formula?