Welcome!

Welcome! Below you will find our latest published articles.

  Quick Excel Tips: How to Put a Carriage Return in your Cells

This particular tips comes from the fact that I’ve been asked this question several times now in the last few days alone, so I thought it would be a good idea to post it here: How do you put a Carriage Return in-between lines of text in a single cell? In other words, how do you use the Enter key like you would in Microsoft Word?

The answer to this is simple: Use Alt + Enter. When typing in your cell and you want to create a blank line before the next line of text starts, hold down the Alt key and press Enter. This will insert a blank line (like in Word) instead of shifting the focus to the next cell.


Tags: , , , , , , , , ,

This entry was posted on Wednesday, September 27th, 2006 at 2:08 pm and is filed under Microsoft Excel, Microsoft Office Help. You can leave a response, or trackback from your own site.

2 Responses to “Quick Excel Tips: How to Put a Carriage Return in your Cells”

  1. Adam D Says:
    September 27th, 2006 at 6:35 pm

    Wow… great tip. Didn’t I teach you this trick when you were under my tutelage? Thank goodness we have such a great resource in your website Kev. (note: I’m being sarcastic)

  2. administrator Says:
    September 27th, 2006 at 10:37 pm

    Scathing! We can’t all be the Masters of Excel that you are adam =p.

Leave a Reply