2. In the Format Cells dialog box, select the Shrink To Fit check box on the Alignment tab, and click OK. [via techrepublic.com; link removed as site no longer functions] ...

To set the Excel row height for a particular row, click a cell in that row, then click the "Home" on the ribbon menu. In the "Cells" submenu, click "Format." ...