I recall using an Excel workbook where I worked a couple of years ago in which the column width was fixed and the row height automatically increased as needed. I have been unable to figure out how to do that in spreadsheets I make. Any ideas? I am using Excel 2007.

On the Home Ribbon, click the Wrap Text icon in the Alignment sections. You can do this on individual cells or a group of selected cells.