Row Height Auto-Fit not working
Posted by Amy Bowser on September 16, 2000 3:18 PM
I'm using Excel 97. For some reason, when I print the spreadsheet, the column with the longest amount of text gets cut off. It doesn't print the last line or two of text. I have turned on row auto-fit, but it doesn't make a difference.
Through testing, I figured out that if I add two alt-enter's to the end of the cell, it prints correctly. Since I never know which column will have the longest cell, I thought maybe I could add two new lines at the end of every cell in the 8 columns.
I tried to write a macro to add the new lines to each of the cells and then loop through the entire sheet until the EOF, but it actually records the value in each cell and replaces each cell with the wrong text plus the two new lines. How do I add just two new lines?
Or why is Excel doing this in the first place? I've checked all the format settings I can think of. What is the point of auto-fit if it doesn't work? This has happened on several spreadsheets in the last year. We're using Times Roman for the font, does that have something to do with it?
Thanks for your help!