#Shortcut for bullet points in excel how to

Or, click the Bullets and Numbering command, to see more options. Next, select the bullet style that you want - there are a few options to choose from. In Excel 2007, the Bullet command is on the popup formatting toolbar, just above the right-click menu. To add bullets to your text boxes in Excel 2010 or later, right-click on the text, and click Bullets, in the popup menu. Last week, Bob Ryan sent me a Student Budget workbook, and he had the instructions in formatted textboxes, including bullet points. In a textbox, there are a few more formatting options, including a Bullets command. If you’re adding notes for the people who will use the file, you can put the text in a textbox that will float over the worksheet, instead of entering your notes in the cells.

There is another way to add bullets to an Excel worksheet. In the list shown below, there is no bullet in cell A5, because cell B5 is empty. Type something in cell B4, and the bullet appears. When you press Enter, no bullet will appear in the cell, because cell B4 is empty. For example, type this formula in cell A4: Using a formula gives you more flexibility - you can make a rule for when the bullet should appear. When you press Enter, a bullet will appear in the cell, just like the one from the keyboard shortcut. You can add bullets with a formula too - just use the CHAR function, and refer to either of the numbers that we used in the shortcut keys above.įor example, in cell A4, type this formula: =CHAR(7) If you’re using a laptop that doesn’t have a separate keypad for numbers, you can use the special keys to activate the “number keypad” section of the keyboard.Īfter you type the bullet shortcut, you can format the cell to Align Right, so the bullet is close to the text in the adjacent column. NOTE - This shortcut only works if you type the numbers on the Number keypad – it doesn’t work if you use the numbers at the top of the keyboard (above the letters).

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.

#Shortcut for bullet points in excel how to

Even though they’re not built in, keep reading, to see how to add bullets in Excel.įortunately, you can add a bullet to a cell with either of the following keyboard shortcuts: This page illustrates three ways to insert bullet points in Excel. Bullets are a handy feature when you’re making a list, so it would be nice to use them occasionally, in our Excel files. There’s no built-in feature for bullets in Excel, like there is in a Word document.