Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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.

screenshot

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.