Excel copy 3 row named range down 1 row and make the new cells the new named range

use below activity on your excel, you don’t have to select target.

to go to last row, shortcut is Ctrl+down, probably “Up” arrow might take you to penulitmate row.

check this example for reference