Enter the address of the cell area to paste the content into the Name Box on the Fomular bar as :
Press Enter to paste content into the upper cell area
Do not move to another cell after typing
Press Ctrl + Enter keys after typing to not move the cursor to the next cell
Or go to Tools - Options menu.Click the Edit tab.Deselect the Move selection after Enter Direction item.