Note: use the Format Painter to quickly copy the bullet point format to other cells. Excel automatically adds the bullet points! You can now create a bulleted list by simply typing the list items. In the Type box, press Alt + Numpad 7 to insert a bullet point (or copy/paste a bullet point), enter a space and type Click OK.ġ1. Right click, and then click Format Cells.ĩ. To insert multiple bullet points in a single cell, press Alt + Enter to start a new line in an Excel cell.Ĭreate a custom number format and inserting a bulleted list in Excel will be a piece of cake.ħ. Keyboard Shortcut: Alt + 7 (number must be from your number pad) 2.
#Shortcut for bullet points in excel code#
Select a font from the drop-down list, type 2022 in the Character code box and click Insert.ĥ. I have mainly been inserting bullet points inside text box objects within my 'Instructions' pages (tabs), but I will list out some ways you can insert bullet points directly into your spreadsheet as well. On the Insert tab, in the Symbols group, click Symbol.Ĥ. If you don’t have a number pad on the right side of your keyboard, execute step 3 and step 4.ģ. To insert a hollow round bullet point, press Alt + Numpad 9. To insert a filled round bullet point, press Alt + Numpad 7.Ģ. If you have a number pad on the right side of your keyboard, execute step 1 or step 2.ġ. You can use a keyboard shortcut, insert a symbol or create a custom number format. This page illustrates three ways to insert bullet points in Excel.
#Shortcut for bullet points in excel serial numbers#
If your font does not provide the bullet, try selecting a font such as Wingdings in the Symbol dialog box. In Excel, most of the time we use serial numbers but when you are working on lists the best way is to use bullet point.
Different fonts provide different symbols.If you have a numeric keypad on the right side of your keyboard, press ALT+7 for a bullet.If you need another bullet on a new line underneath, type ALT+ENTER and repeat the process. At the bottom of the dialog box, type 2022 in the Character code box. Select a blank cell, and then on the Insert tab, click Symbol. But it is also used to work with text data such as to-do lists, bulletin boards, workflows, and the like. Microsoft Excel is primarily about numbers.