The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My work

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,842 other followers

Start a New Line Inside a Spreadsheet Cell in Excel | Excel Semi-Pro

Posted by jpluimers on 2012/03/16

Unlike most tools where you use Shift-Enter to add a line break character (ASCII 10: line feed), Excel is different:

Sometimes it’s necessary to have more than one line inside a worksheet cell, which is easily done with a line break.

Add a new line by holding down the Alt key while you press enter. It’s the keyboard shortcut Alt+Enter. In Excel 2008 and 2011 for Mac use Cmd+Option+Enter.

–jeroen

via: Start a New Line Inside a Spreadsheet Cell in Excel | Excel Semi-Pro.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: