Excel: Alt+Enter

Courtesy of: Richard Stokes, Network 1 Sales Consultant

Have you ever needed to insert more than one line of text inside of a single cell in Excel? There is an easy way to do this.

First, double-click the cell in which you want to insert a line break. Then, place the cursor where you want the line break. Press “Alt+Enter” to insert the line break. A new line of text within the same cell will appear. Now, you can continue to write in the same cell and whatever you type will be placed on the next line.

This can be useful when you have multiple parts of a text string that you want to show on separate lines. For example, let’s say you have an address in an Excel spreadsheet. Simply use “Alt+Enter” to insert line breaks where you want them, and you will now be able to show each part of the address on a separate line.

Richard Stokes: As the Director of Sales for Network 1, Richard identifies “future” clients that can benefit from the support of an experienced, outsourced IT team. He helps clients and prospects find technology solutions they need to achieve better productivity and efficiency so they can focus on making money and growing their businesses.

Network 1 designs, builds and supports the IT you need to run your business more securely, productively and successfully. Whether you want to outsource all of your IT needs to a reliable, responsive, service-oriented company, or need to supplement the work of your internal IT staff, we will carefully evaluate where you are now, discuss where you want to go and implement and support a plan to get you there with as little interruption as possible.

Leave a Comment

Related Posts