Forum Discussion
Formula Help
Hello! First time posting here. While I have used excel and love using it, I cannot figure out this formula/what the best route would be. At this time, I want if one cell shows this text, fill i...
WHAT I UNDERSTOOD
You want to set a formula after which if you change text in a particular cell, it should reflect in a big range.
for this just apply the formula
suppose the text you want to be copied is at C3 then it should be =$c$3 in all the cells where you want to copy the text of c3. Now whatever you put in c3, it'll be copied to all the cells.
it'll make the location absolute and you can copy it to as many cells as you want.
you can refer here for more valuable information gyankosh.net/msexcel