This thread is a duplicate of
https://www.msofficeforums.com/excel...-absolute.html - which was answered well before you posted this one.
Kindly don't ask the same question in multiple threads. Thread closed. You may continue the discussion in your other thread.