I have an excel sheet that I update every week. Each week a new column is added to the sheet, and each row has a formula that tallies up the total over these columns
for example in the Y column I have:
For row 7 formula is =SUM(D7:X7)
For row 8 formula is =SUM(D8:X8)
so on , so forth
I have 50 rows that I have to update the formula if i add another column. So if last week the formula was in Column Y, this week its in Column Z so the new formula looks like
=SUM(D7:Y7)
=SUM(D8:Y8)
How do I do this more efficiently, by just changing one row's formula and apply it to the other rows?
2006-12-08 05:37:24 · 5 answers · asked by arus.geo 7 in Computers & Internet ➔ Software
highlight the last row and grab bottom corner to drag and extend to the next row...Thats it
2006-12-08 05:40:04 · answer #1 · answered by daanzig 4 · 0⤊ 0⤋
Copy and paste the formula into the other cells. Excel will change the reference for you.
2006-12-08 05:39:38 · answer #2 · answered by Lisa A 7 · 0⤊ 0⤋
The simplest way to disable row/column insertion or deletion is to protect the workbook. If you need others to edit ranges still, go Tool>Protection>Allow Users To Edit Ranges before you protect the book.
2016-05-23 06:59:46 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Simply highlight the rows and do Edit, Find, Replace where you would "Find" the letter "X" and replace it with the letter "Y".
2006-12-08 05:49:04 · answer #4 · answered by Sunny_1_ 3 · 0⤊ 0⤋
just copy and paste the formula it automatically changes it.
2006-12-08 05:39:04 · answer #5 · answered by chedderapples 4 · 0⤊ 0⤋