Excel Insert Carriage Return or Bullet Points in a Cell

//

This post is a quick tip about how to insert a carriage return and bullet points into an Excel cell.

How to add a carriage return in a cell in Excel

In Excel to insert a carriage return in a cell click into the cell, type the first line, press Alt-Enter, then type the next line.

There are different ways to do this depending on what you’re trying to do exactly which I found in this article: http://www.officearticles.com/excel/carriage_return_within_a_cell_in_microsoft_excel.htm

How to add bullet points into a cell in Excel

To enter bullet points in a cell you need to use Alt+0149 from the number pad (hold down the alt key then press 0, 1, 4 then 9 – separately, not together) for each bullet.

Once you release the Alt the bullet will appear.

Leave a Comment