Maximum row height-Is there a way to expand the row height beyond this limit?

I have an application where it is required for 40 to 50 lines to be in each row.
This is to use a certain macro that compiles data.

So I type a line of data, then press Alt-Enter, type the next line of data, press Alt-Enter, etc.

My problem is that previous users had less than 30 lines of data per row. Having 40 to 50, all the data can not be seen because there seems to be a maximum display height for an excel row.

I drag the bottom row border downward until it won't expand the row height any longer.

Is there a way to expand the row height beyond this limit?

All advice greatly appreciated. Thanks in advance!
kodiakbear

Originally Posted by kodiakbear

I have an application where it is required for 40 to 50 lines to be in each row.
This is to use a certain macro that compiles data.

So I type a line of data, then press Alt-Enter, type the next line of data, press Alt-Enter, etc.

My problem is that previous users had less than 30 lines of data per row. Having 40 to 50, all the data can not be seen because there seems to be a maximum display height for an excel row.

I drag the bottom row border downward until it won't expand the row height any longer.

Is there a way to expand the row height beyond this limit?

All advice greatly appreciated. Thanks in advance!
kodiakbear

Would it help if you were to increase the colmn width?

Does smaller Zoom View help ? I have 19" monitor and I can see more than 60 rows/lines with 70% zoom, and the text is still readable.

Increase the monitor resolution can help too.