diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)

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.

[Source]

Share This Story, Choose Your Platform!

Get Latest News

Subscribe to Digital News Hub

Get our daily newsletter about the latest news in the industry.
First Name
Last Name
Email address
Secure and Spam free...