I have countless spreadsheet reports that I need to convert to printable format. The issue is that one of the columns in each spreadsheet contains a large amount of text, which requires me to insert a row(s) below the cell and then merge the cells in order to make the text visible/printable. I have attached a sample report/spreadsheet for reference. Column "D" is the column at issue.
Is there a way to print all of the text in Column D without going through this process? If not, would it be possible to make a macro that would detect whether the text in Column D exceeds the maximum cell height and, if so, add and merge rows below it until all of the text is visible?
I greatly appreciate any help!
https://drive.google.com/file/d/0B5V...ew?usp=sharing
Bookmarks