How do I export a row of data which includes a large amount of text in
most cells into a single page report.

Ideally I would like to be able to select the row number and simply
print the report using the data from that row

My first reaction is that MS-Word's "Mail merge" feature may be useful for
this report.

In Word, use
Tools Letters and mailings Mail merge
An Excel file can be the data source for Mail merge.

Despite its name, Mail merge can be used to produce documents other than
letters.