Creating a bulleted list in Excel is not as easy as it is in Word. There is no bullet button on the ribbon in Excel. What if you want to add a bulleted list to a spreadsheet?
Today we will show seven ways to create a bulleted list in Excel.
The easiest way to create a bulleted list is to use a keyboard shortcut 35 Everyday Microsoft Excel Keyboard Shortcuts for Windows and Mac 35 Everyday Microsoft Excel Keyboard Shortcuts for Windows and Mac Keyboard Shortcuts they can save you a lot of time. Use these Microsoft Excel shortcuts to speed up work with spreadsheets on Windows and Mac. Read More to enter a bullet character in a cell.
Select the cell you want to type a bullet into and press Alt + 7 or Alt + 0149 for a solid bullet or Alt + 9 For a hollow bullet. When typing numbers in these shortcuts, you must use the number pad on your keyboard.
If you are using a laptop without a numpad, you may be able to turn on Num lock to emulate a numeric keypad. Not all laptops have Num lock wrench. If yours has one, it's probably on one of the function keys. You can press Shift + Num Lock or Fn + Num Lock . So the numbers for the “number pad” will be on some of the letter and number keys on the right side of the keyboard.
If you don't have access to a numeric keypad, don't worry. The next section shows you how to enter bullets into cells without using the numeric keypad.
If you don't have a physical or emulated numeric keypad on your keyboard, or if you forget the keyboard shortcuts for bullets, you can use the Symbol dialog.
About the Insert tab, go to Symbols> Symbol in the Symbols section. If your Excel window is big enough, you can click Symbol button on the Symbols section directly, without clicking on the Symbols button first.
The default font Calibri is automatically selected in the Font dropdown list, but you can select a different font.
Select the symbol you want to use for your bullets and click Insert . Then click Close .
If you're having trouble finding a bullet icon among other symbols, we've provided some bullet symbols you can use in the image below. About the Symbol dialog box, first select Unicode (hexadecimal) from the from the dropdown list. Then, type one of the codes shown in the image below in the Character code box.
Type one or two (or more) spaces after the bullet in the cell.
Then copy and paste the bullets into the other cells and add your text.
To quickly fill other cells in the same column with bullets, enter a bullet in the first cell and then use the Fill Handle to automatically copy and paste the bullet into the other cells.
If you need to create a long bulleted list, you can use a custom number format to make it faster to add bullets to your list items.
If you don't have a numeric keypad, first insert a bullet into a cell you're not using, and then copy it.
Select the cells you want to add bullets to. They can be empty or already have text. Then right click on the selected cells and select Format Cells , or press Ctrl + 1 .
About the Number tab, select Custom under Category .
In the Type box, paste the bullet you copied, or use one of the keyboard shortcuts we show you to write a bullet. Then type a space or two (or more) and the @ character.
Click OK . The new type is automatically applied to the selected cells.
Now when you want to add bullets to cells, select the cells you want to add them to. Then press Ctrl + 1 to open the Format Cells dialog, select Custom under Category about the Number and select the new Type you created.
To enter a bulleted list in a single cell, double-click the cell and use a keyboard shortcut or the Symbol key Dialog box to insert a bullet. Type the number of spaces you want and then the text you want for the first point.
press Alt + Enter to go to the next line in the cell. Then enter another bullet, one or more spaces, and the text for your second point.
Repeat for each bullet point, pressing Alt + Enter at the end of each line. Then press Enter when you have finished creating the list.
If you created a bulleted list in Microsoft Word How to format and manage lists in Microsoft Word How to format and manage lists in Microsoft Word No matter how many bulleted or numbered lists you've created with Microsoft Word in your life so far, I bet you'll learn something new! of this guide! Or did we miss something? Read More We'll help you get (more) familiar and productive with this versatile office suite. Read More to copy it.
To insert the entire list into a single cell, double-click the cell and press Ctrl + V . There may be no spaces between the bullets and the text on each line, but you can fix this by placing your cursor where you want and adding spaces.
To insert each list item into separate cells, select the cell where you want to insert the first item and press Ctrl + V .
You may have to adjust the spacing in each cell.
To add bullets to multiple cells at once, you can also use a function Tips for working with text and text functions in Excel Tips for working with text and text functions in Excel Let's look at several ways to work with text in Excel spreadsheets . Learn about several different Excel text functions and see how they can save you time. Read more . The CHAR function takes a character code and displays the character that corresponds to that code in the cell. We are going to work with codes in Windows. (Character codes on a Mac will differ, but the use of the CHAR function is the same.)
To enter a solid bullet character into multiple cells in Excel for Windows, select the cells and click Formula bar. Type the following function and press Ctrl + Enter :
= CHAR (149)
All selected cells are filled with the solid bullet character.
When you use this method, you'll need to place the text for each bulleted item in the column to the right of the bullets, like we did in the image below.
You can create a bulleted list in a column by using the CHAR function in a formula. This method is useful if you already have a list of items in another column without bullets.
Select the cell to contain the first item with the bullet character. Then, enter the following formula, replacing “C3 ” with the cell reference for the first element in the other column.
= CHAR (149) & "" & C3This formula concatenates a solid bullet character, a space, and the value of the referenced cell (C3 in our case). You can enter more than one space between the quotes if you wish.
To copy the formula to the rest of the cells where you want the list to appear, select the cell where you just entered the formula. Then drag the AutoFill box in the lower right corner of the cell down over the cells you want to fill.
When you release the mouse button, the formula is copied to those cells with the appropriate cell references for each row.
With formulas, you can't remove the items from the other column, because they are still referenced in the formulas. But we'll solve that by converting the formulas to values.
To convert the formulas to values, select the cells that contain the formulas and press Ctrl + C to copy them.
Click the lower half of the Paste button on the Clipboard House section tongue. Then click the first button under Paste Values .
Excel replaces the formulas in the cells with the concatenated values.
Windows includes some special fonts that are just symbols, like Wingdings and Webdings. Wingdings has some symbols that make nice bullets.
To insert a bullet character into cells using a symbol font, first select the cells. Then, in the Source section on the House tab, change the font to Wings .
Select the first cell you want to enter a bullet into and type a lowercase “L” (l) to enter a large solid bullet, a “w” to enter a small solid bullet, or one of the other letters shown in the following image to enter other bullet styles. Do the same for the other cells you changed to the Wingdings font.
To use this method, you must put the bullet characters in their own cells in the column to the left of your list items because of the symbol font you're using in the cells with the bullets. Then change the width of the column containing the bullets to the width of the bullets.
You can choose from more bulleted symbols by using the CHAR function with the Wingdings font. The image below shows the values of the CHAR function for various types of bulleted characters.
When using the CHAR function with the Wingdings font, you must first enter the CHAR function in a non-symbol font, and then change the cell(s) font to Wingdings.
That is all! You can also create other types of lists in Excel 3 Types of Excel Lists to Ease Data Entry 3 Types of Excel Lists to Ease Data Entry Do you need a list based on spreadsheet data? Here's how to add custom, dropdown, and checklists to your worksheets and the free Excel list templates you can download. Read More