Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How to apply formula to several rows in Excel?
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?
5 Answers
- daanzigLv 41 decade agoFavorite Answer
highlight the last row and grab bottom corner to drag and extend to the next row...Thats it
- Lisa ALv 71 decade ago
Copy and paste the formula into the other cells. Excel will change the reference for you.
- Anonymous5 years ago
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.
- 1 decade ago
Simply highlight the rows and do Edit, Find, Replace where you would "Find" the letter "X" and replace it with the letter "Y".
- How do you think about the answers? You can sign in to vote the answer.
