How do I change formula in a row when the column had another formula already?
How do I change formula in a row when the column had another formula (from convert formula for the column)? I tried to change formula for just one row but the formula changed for the whole column. How can I restrict formula change to just the row I needed.
See sample file attached. Colum H is the total of Colum E, F ,G. But for row 4 to 10 , I would like to average the number in column E,F, G. I tried change formula in row 4 but the formula for entire column changed??
Best Answers

Hi @Lynna
Hope you are fine, when you convert the formula to the column formula you can't change this formula for one row.
to do that first you convert it to a column formula to fill all cells in the same column with the same formula then you can convert it again to the cell formula and you can change the formula for the specific row you want, but please note that you will not be able in future to turn it back to column formula because again the formula will be the same in all cells also any new row you will add you need to copy the formula for it manualy.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Hi @Lynna
Hope you are fine, when you rightclick on any cell in the column you convert it to column formula you can find this option i will attach a screenshot showing you where.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers

Hi @Lynna
Hope you are fine, when you convert the formula to the column formula you can't change this formula for one row.
to do that first you convert it to a column formula to fill all cells in the same column with the same formula then you can convert it again to the cell formula and you can change the formula for the specific row you want, but please note that you will not be able in future to turn it back to column formula because again the formula will be the same in all cells also any new row you will add you need to copy the formula for it manualy.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Thanks Bassam! Step 2... Where do I click to just convert to the cell formula ? I change the cell formula but the formula changed for the entire column.

Hi @Lynna
Hope you are fine, when you rightclick on any cell in the column you convert it to column formula you can find this option i will attach a screenshot showing you where.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
Check out the Formula Handbook template!