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.
bassam.khalil2009@gmail.com
☑️ 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 right-click 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.
bassam.khalil2009@gmail.com
☑️ 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.
bassam.khalil2009@gmail.com
☑️ 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 right-click 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.
bassam.khalil2009@gmail.com
☑️ 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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!