#Create drop down list in excel 2011 mac how to
#Create drop down list in excel 2011 mac free

You can watch me talk through the three options in my two-minute video:ģ) Use custom cell formatting to insert Excel bulletĮxcel gives you the option of changing the Number format for each cell.

But on the downside it’s slower than just typing ALT + 7. Excel shows you a map of all the available characters and you can page up and down to find a suitable character.Īs I said before, using a special font allows you to create fancy bullets because you can pick from a huge range of characters.

Insert a symbol via the Excel menu or ribbon – In Excel 2010 you click on the Insert Menu, find the Symbols group, click on Symbol to insert a symbol, then select the font and symbol of your choice.

Refer to the picture above for some starter ideas.

Use the CHAR() function – To access all 256 characters in the Wingdings font, you can type in the formula =CHAR(nnn) where nnn is the character number you want to insert.

On standard keyboards you’ve got around 100 keys, but every font set has 256 characters so about half of these can’t be typed straight from your keyboard. This only works if you can type the character using your keyboard. For example if you type lowercase letter “l” you get a round bullet point symbol.

Type the character straight in – Change the font to Wingdings, and type the matching letter to add a bullet character.

So let’s say we want to add a bullet using the Wingdings font. As you can see from the picture below, there are a lot of good bullet point symbols in Wingdings which is why I suggest using Wingdings for bullet points: Wingdings) and then type in a character to use as the bullet. You must first pick a font with lots of symbols in it (e.g. Method number 2 allows you to get quite fancy with your bullets.

#Create drop down list in excel 2011 mac free

It’s free and easy to sign up, and you’ll be able to read my content hot off the press! If you’re interested in receiving updates about future Excel tips from Launch Excel, take this chance to sign up for my RSS feed by clicking on the orange RSS icon to the right. Here’s a one minute video showing this in action: If you’re using a laptop you will need to turn on the number keypad feature because this tip doesn’t work with the row of numbers above your alphabet keys. ALT + 7 is my personal favorite for adding a round bullet in Excel.You hold down the ALT key and then type one of the following numbers using the number keypad (that’s the one on the right hand side of the keyboard). This is the simplest and fastest way of adding bullet points in Excel. If you know of other ways that I didn’t mention, please share in the comments.ġ) In-cell bullet points in Excel with the ALT key Add a bullet with custom cell number formatting.Type a bullet using special fonts (like Wingdings).Type a bullet using ALT key combinations.We’ll look at 5 different ways to add bullet points in Excel, starting with the fastest and ending with the most creative. I discovered five different ways to add bullets in Excel and I’ll show you them in depth. So I decided to set out and find new ways to create bullet points in Excel.

#Create drop down list in excel 2011 mac how to

Would you like to know how to insert a bullet point in Excel? For a long time I thought there was only one way to do this – type a lower-case letter “l” in the font Wingdings to insert a round bullet point character.īut now I know that Excel is such a versatile bit of software, there’s always more than one way to do something with Excel.