adjusting row height automatically

Copper Contributor

I have around 15000 rows in an excel file. When I adjust the height row height with select All > Cells>AutoFit or double-clicking row separator some rows remained to adjust the height with the text in it.. this unnecessarily increases the pages. How do I overcome this problem??

1 Reply

@ajitbmunj 

Unfortunately, Excel's AutoFit algorithm is not perfect (and moreover, the printed output may not exactly match what you see on the screen).

Sometimes it helps to widen columns slightly, but sadly, that is a matter of trial and error.