Entering Text in Cells

No workbook worthy of the name stays empty for long. You can type any sort of text you want directly into a cell, whether the text is a label identifying the data in a row or column or an explanation reminding you and your colleagues of any limitations on the data to be entered into a cell. Most text entered into Excel workbooks is short enough to fit on one line, but if you want to have the text in a cell appear on two or more lines and break at a specific location, you can easily insert a line break.

Enter Text as One Line

  1. Click the cell into which you want to enter text.

  2. Type the text you want to appear.

  3. Press Enter.

    Tip ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.