How to Create a Single Cell Bulleted List in Excel


excel

 

You may know that you can enter multiple lines within a single cell by simply clicking Alt + Enter at the end of each line, which starts a new line for you.

With a little work you can use that tidbit to create a pseudo bulleted list!

 

  1. Click in the cell where you want the list to appear.
  2. Click the Insert tab.
  3. Click the Symbol button to open the Symbol dialog box.
  4. On the Symbol tab in the Symbol dialog box change the from option to ASCII (decimal).
  5. Enter 0149 in the character code box.
  6. Click Insert to place the bullet character in the cell.
  7. Click Close to close the Symbol dialog box.
  8. You will now have a bullet symbol in your cell. Highlight the symbol and press ctrl + c to copy the symbol to the clipboard.
  9. Type the text for your first bullet point and press alt + Enter at the end of the line to start a second line.
  10. Press ctrl + v to paste the bullet into the new line.
  11. Repeat steps #9 and #10 for the remaining bullet points.

Just repeat the steps above for each bullet point you would like to add to your list.

 

Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol’s Corner Office or follow Carol on FaceBook and Twitter.

There are 7 comments

Comments are closed.