How to copy a range of cells in Excel that takes data from another sheet so that the addresses do not change?

Question

excel

There are cells with getting data from another sheet =('sheet1'!B26)*D6 I copy it next, it turns out =('sheet1'!H26)*J6 and you have to change the letters in each cell to B and D, but it is necessary that everything remains as in beginning =('sheet1'!B26)*D6
is necessary for the specifics of the work and will greatly forgive my life))
I tried to copy and paste only the contents - it does not help ...

Answer 1

=('лист1'!$B$26)*$D$6
You can write with your hands or press F4
You can write separately: a dollar next to a number - the line does not change, a dollar next to a letter - the
Google column does not change: relative and mixed addressing