Oct202010

How To Create A Bulleted List In A Excell Cell?

For those of you who like bulleted lists and are frustrated that you can’t insert one in a cell, there’s a way to insert bullet points in a cell to emulate such a thing. Here’s how you do it:

With your cell selected and in edit mode (reminder: press F2 to go into edit mode), position the cursor where you want a bullet point. Then press ALT+0149 to generate a bullet character. And, just to refresh your memory, to insert a new line in the cell you press ALT+Enter.

Hint If you’re doing this on a laptop, enable Num Lock so that you’ll have a numeric keypad to use. Otherwise, you’ll get frustrated by trying to enter the ALT+0149 key combination by using the number keys in the number row on the keypad. What happens is that the Open dialog box is displayed after I press the 4 in the key combination. It seems that pressing ALT+4 opens this dialog box, so for some reason the 0 and 1 appear to be ignored. My pain, your gain.

On most laptops, to enable Num Lock, you press SHIFT+Num Lock or Fn+Num Lock. If your laptop (typically a smaller model, such as a netbook) doesn’t have a Num Lock key.

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he's engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.