Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
What do you mean? You want all cells height to be automatically adjusted for what's in them? – Ivo Flipse Apr 13 '10 at 9:52

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....

share|improve this answer
but by default rows only shows first line of cell. i want to see all text bedefaul – metal gear solid Apr 7 '10 at 8:46
@metal: Just select all the cells in step 1 (ctrl-a). – fretje Apr 7 '10 at 9:18
@metal: I think I know what you mean now... updated my answer. – fretje Apr 7 '10 at 9:25

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .