I am a teacher and am working with reports for grading. Is there a method for having the field and border adjust to maximum length of contents?

In Excel If I have a row, it will adjust to the maximum height of any one cell in the row. I am using a 3 cell row layout and need it size to largest of the 3 cells in the row and to draw borders around each cell.

Thanks,

Michael Perry :)

Read up on the Sliding/Printing feature.

Tried that. No luck.

I have a set of fields in a 2 row and 4 column set up with the fields drawn for 2 lines. With sliding on, I can add as many lines as I want, but it does not seem to force the next row of cells lower on the page.

______________________________________

| text 1 | text 2 | text 3 | text 4 |

| text 1a| text 2a| text 3a| text 4a|

______________________________________

Am I missing something?

Michael

Edited November 9, 200718 yr by Guest

Please help check my logic.

In sliding objects -- it will shrink the field size to fit the text in the field. I was hoping that there is a way to expand the text based on the info in the cell.

To use this I will have to set the fields as large as possible stretching over multiple pages. Then I will have to look at the record to check the look of the printed page.

Thanks,

Michael