I have an excel table with varying lines of text per row. The rows and cells are all formatted identically and all set to auto-height.
This issue I'm having is that some rows are displaying with text tight to the top and bottom borders while others have a varying amount of blank space above and below the text. I can find no reason for this inconsistency.
The issue is then compounded as whenever I print (either to paper or pdf) the rows with blank space display fine, but the rows in which text is tight to the border loose some of the top and bottom lines.
I have tried:
- Format painting.
- Manually setting row heights then returning to auto.
- Copying cells.
- Inserting new rows.
- Copying entire table to a new worksheet.
I can find no reason for the inconsistency. Can anyone give any suggestions?
Many thanks in advance,