I have a spreadsheet I created to manage my pipeline of transactions. I'd
like to create a cell in that spread sheet that contains the contact name it
goes with the transaction. Is there a way to link that cell to the actual
contact record?

If so, my intent would be to click the contact name inside this Excel
spreadsheet and it automatically open up the contact' s record so that I can
enter history and notes etc.