The Wiert Corner – irregular stream of stuff

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

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

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

    Join 1,860 other subscribers
«
»

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.

This entry was posted on 2012/03/16 at 06:00 and is filed under Excel, Keyboards and Keyboard Shortcuts, Office, Office 2000, Office 2003, Office 2007, Office 2010, Office 2013, Office 2016, Power User. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

«
»