Especially when you have hidden rows/columns, this pastes into the visible cells, based on tabs and new lines.

AHK-Excel-Paste.ahk

#z::
	KeyWait, LWin
	KeyWait, RWin
	Clip0 = %ClipBoardAll%        ; Save formatted text for later
	ExcelBound = %Clipboard%
	Loop, parse, ExcelBound, `r`n
	{
		if A_LoopField = 
			continue
		nonemptyline := A_LoopField
		Loop, parse, nonemptyline, `t
		{
			Clipboard = %A_LoopField%
			Sleep 50
			Send ^v
			Send {tab}            ; Type TAB once per tab found
		}
		Send {enter}              ; Type ENTER once per Windows-style new line.
	}
	Sleep 50
	ClipBoard = %Clip0%           ; Restore original ClipBoard
	VarSetCapacity(Clip0, 0)      ; Free memory
Return