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). 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:
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.
0 kommentar(er)
