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.

How would I add space inside a cell in Excel?

I'm using MS 2007 as shown here:

alt text

share|improve this question
    
Do you want to fix the size of the cell or use word wrap? –  Tog Dec 2 '10 at 11:49
    
something like a word wrap? so that the next sentence will go to the next space –  tintincutes Dec 2 '10 at 11:59
    
can you use the word wrap in one cell? –  tintincutes Dec 2 '10 at 12:02

3 Answers 3

up vote 5 down vote accepted

If you want text to appear on multiple lines in a cell, you can format the cell so that text wraps automatically, or you can enter a manual line break.

  1. Wrap text automatically

    • Select the cells you want to format.
    • On the Format menu, click Cells, and then click the Alignment tab.
    • 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.

  2. Enter a line break

    • To start a new line of text at a specific point in a cell, click where you want to break the line, and then press ALT+ENTER.

    Note: If all wrapped text is not visible, it may be because the row is set to a specific height. To allow the row to adjust automatically and show all wrapped text, point to Row on the Format menu, and then click AutoFit.

Source: MS Office Excel Help and How to - Wrap text in a cell

share|improve this answer
    
@Mepher:thanks for this. I will try this one. –  tintincutes Dec 2 '10 at 12:43
    
I needed the 2) I think this works now. Thanks –  tintincutes Dec 2 '10 at 12:50
    
You're welcome. –  Mehper C. Palavuzlar Dec 2 '10 at 12:51

Seems that the question content doesn't reflect the title very correctly.

If you need a line break then do like Mehper C. Palavuzlar's answer.

If you need to add spaces at the beginning of the cell then the easiest way is adding an ' (apostrophe) before. This also applies if you need to begin the cell will =, + or -, or format any number/data type as string

For example:

  Input: '    abc123
Display: "    abc123"
  Input: '0001234
Display: 0001234
  Input: '=A1/B5
Display: "=A1/B5"
  Input: '-B2-8
Display: "-B2-8"

If you need to add spaces in the middle or at the end of the string then this may not be a real question

share|improve this answer

Easy peasy.

  1. Highlight all the rows you want to increase the size before &/or after the text.

  2. Click on "Home" on toolbar.

  3. Below "Alignment Tab and to left of the "abc" button, you will see three icon boxes each one having three lines. They will vertically align your text top, centre, or bottom. To increase the space between the text and the top and bottom of its cell, click the middle (centre) box.

  4. Then go to extreme right and click on "Format" and click on "Row Height.

  5. Increase row height to the extra size you want. You are done. To increase only the space between text and top line, click on the icon to the immediate left of the "abc" button.

share|improve this answer

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.