In Excel 2007 how to give height auto to show all text inside cell by default like Google Spreadsheet?

Question

In Excel 2007 how to give height auto to show all text inside cell be default like Google Spreadsheet?

Answer 1

Your question is not really clear, but I suppose you're talking about "wrapping text"?

From here:

1. Select the cells you want to format.
2. On the Format menu, click Cells, and then click the Alignment tab.

3. Under Text control, select the Wrap text check box, and then click OK.

   Note: Data in the cell will wrap to fit the column width. When you change the column width, data wrapping adjusts automatically.

Edit: You can also apply this to a style (e.g. the 'normal' style, if you want it to really be the default for 'normal' cells, also for new documents) by right-clicking on the specific style and choose for Modify....