Excel to PDF and keep formatting!

Mostly I’m talking about Row Heights.

This excel file is letter summaries. (I have five or eight such gules to do.) I have only two rows - date, and as stated, a summary of the letter.

I have tried export, I have tried print to PDF, I have tried save as PDF. None of the options keep my formatting.

Some summaries are one, two, or three lines, some summaries are as many as 10, 11, or 12 lines.

The column is formatted for wrap text.

In the first file I’m working with it’s about 33 pages.

On my screen each line looks exactly as I want it to look. Uniform space above and below the letter summary. Which means almost no space, I don’t need any space above and below. My rows are separated with top and bottom borders.

No matter what I do, when I turn the file into a PDF, it adds a lot of space above and below the text on the letter summary. This often results in a large portion of the page sometimes remaining empty.

I have tried outputting with the default formatting, - meaning I undid wrap text, set the row to adjust to the default height of my font, then re-clicked wrap text so that the height of the row was now determined by how many rows of text in the cell. (I’m sorry if this sounds confusing I’m trying to be very clear. ) Looked great but still had poor formatting when it reached PDF with lots of space in each cell below and above the words of the summary.

So I tried tried manually adjusting row heights so that there is very little space above and below the words.

Same output.

All my googling tells me this is a common occurrence. I am doing this for a client family archives. It needs to look good as a PDF when printed or when viewed on a monitor. The amount of space it’s giving me is a terrible look and not clean or consistent in any way.

This might not be the route to go to get the look I need. Can anybody help me with some advice to turn this clean Excel sheet into a clean looking PDF with appropriate formatting?