Wednesday, July 22, 2009

New Lines within Excel Cells

In MS Office, (Word for example), you can use the Shift + Enter to create a new line without breaking the paragraph or a cell in a table. In Excel this doesn't work as it takes you to the next cell.

To Achieve this goal in Excel:
  1. Type something within a cell to the point where you need a line break.
  2. Without exiting the cell, type: Alt + Enter.
    This will position the mouse in the next line within the cell.

No comments:

Post a Comment

Enter your comment here