AutoExpanding Row Height to fit the text

[coley925]

Hi. I have a file that is sent to me once a month that I have to print out for work. The size varies from 200-300 rows, and each row has to be expanded to fit the text. The problem I am having is automaticly expanding the rows to fit the text. With the text wrap feature on, it will automaticly expand the row height to fit the text up to 102. The only way to expand the row height any more is to do it manually. This is very time consuming when the file is up to 300 rows and EACH one has to be expanded manually because each row varies in size depending on the information. It can take HOURS to get the file print ready. Please help me in figuring this out. I can't continue to manually do this every month!!

[rwhopt]

I'm not sure if this will do it but here are 2 suggestions.
Option 1. After getting it into Excel and the first 100 rows have expanded, highlight the remaining non-expanded cells and click the wrap function again.
Option 2. after getting it into Excel and your first 100 rows are expanded, copy the next 100 non-expanded cells (cells 100-200)and paste them into Sheet 2 of your Excel with expanded cells. Next copy your next 100 cells (cells 200-300 from Sheet 1) and paste them into Sheet 3 like you did on Sheet 2. Then go back to Sheet 1, highlight the cells you copy & pasted on Sheet 2 & 3 and delete them off Sheet 1. This may be a work-around.
Good Luck
RW