Can you use bullets in excel

To save yourself some time, enter in the character code box to skip to the bullet. Bullets are great for keeping your information organized, especially if you have a lot of text in your spreadsheet.

Kasper Langmann , Co-founder of Spreadsheeto. Table of Contents. Double-click into a cell to start editing directly in that cell. Then, create a script with these lines:! Numpad0 Now, whenever you press Alt and a number, your computer will interpret it as Alt and the number pad version of that number.

Click Insert , then close the Symbol menu. Apart from these standard bullets, you can also do some fancy bullet points in Excel like these ones:. Once a bullet symbol is inserted into a cell, you can drag the fill handle to copy it to adjacent cells :. As the result, you will have the entire bullet list in a single cell like shown in the screenshot below:. If you don't have a number pad or forget a key combination, here's another quick easy way to insert bullet in Excel:.

If you have difficulties finding a bullet icon among other symbols, type one of the following codes in the Character code box:. For example, that's how you can quickly find and insert a small filled bullet point:. In case you have already created a bulleted list in Microsoft Word or another word processer program, you can easily transfer it to Excel from there.

Then, do one of the following:. In situations when you want to insert bullets into multiple cells at a time, the CHAR function may prove helpful. This method comes in especially handy when you already have some items in another column and you want to quickly create a bulleted list with those items.

To have it done, concatenate a bullet symbol, space character, and cell value. Now, drag the formula up to the last cell with data, and your bulleted list is ready:. In Microsoft Excel, there are a couple of fonts with nice bullet symbols, e. Wingdings and Webdings.

But the real beauty of this method is that it lets you type a bullet character straight into a cell. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback.