copy paste content

[thodexcell]

Good morning everyone I hope you doing fine and wishes for a good week.

Is there any excell function of a cell that gives the content of the previous one ?

Like wr doing copy paste again and again in each subsequent cell ?

Not Cell A2 =Cell A1

 

[thodexcell]

I want the result to be static-solid conent .... not function or something else ... is there any way ?

 

[Peter_SSs]

So, copy EX11, select all the cells where you want that value to appear then Paste Special.. -> Values