I have a 31,000 line spreadsheet, that will become a printed book. Based on the current column width (which has to stay the same for printing purposes) there are many lines that are only one line of text, and others that wrap to multiple lines. For some reason, for lines that are only one line (no wrapping needed) excel creates slightly larger padding below the text (even after auto fit), which creates a strange visual break (as if it's a new paragraph) and also makes the document longer than it needs to be because of the extra spacing. I'd like to get rid of that extra padding, but havn't found any solutions out there. I wondered if I could have a macro go through and adjust the column height to a specific height for any cells that contain fewer than a 90 characters (most of the one-line cells are under 100 characters, so I chose 90 to be safe). Any help would be enormously appreciated!