Copy same formula into other columns

[neeraj2050]

Greetings!!

I am having formulas into few columns but those formulas are not freeze

I have to copy the same formula from those columns to other columns. But while doing so cells reference get changes as those are not freeze.

Any suggestion

Regards
Neeraj Kumar Agarwal

 

[Ramesh]

Hello Neeraj,

Refer to the following URL to get an understanding on Cell referencing in formula's that helps in addressing this issue:

https://www.gcflearnfree.org/excel2016/relative-and-absolute-cell-references/1/

Thanks,
Ramesh

 

[neeraj2050]

@Ramesh: Thanks!! But shared link did not serve the purpose. I know about cell referencing. Request you to please see my query once again

 

[Ramesh]

Only other suggestion i can give here is, copy the formula using formula bar and edit the destination cell and paste it..

If the above still does not answer your query, you can help me with the screenshot or sample file where this issue can be noticed..

 

[neeraj2050]

Into attached file, formula is into A to D column. And same formula is from F to I column.

Data remains into A to D and same formula I have to copy into F to I column
I cannot freeze it with $.

 

[Ramesh]

see if this helps..

 

[neeraj2050]

I cannot apply freeze "$". I know the procedure to freeze
But I cannot use "$" to freeze cells

 

[Deepak]

Two alternatives!

First : - Copy paste the formula & select Link Cells


Second :- VBA

 

[NARAYANK991]

Hi ,

Can you explain why you are doing this ?

There may be other ways to get what you want , without have to take your approach of copying the formulae.

Narayan