Select the target cell, press Ctrl + Shift + Up Arrow to navigate to the visible cell above, and then use Ctrl + D to copy its content.