KEY COMMAND FOR BULLETS MICROSOFT HOW TO

Microsoft Excel is primarily about numbers. But it is also used to work with text data such as to-do lists, bulletin boards, workflows, and the like.

In this case presenting information in a right way is really important. And the best you can do to make your lists or steps easier to read is to use bullet points. The bad news is Excel does not provide a built-in feature for bulleted lists like most word processors including Microsoft Word do. In fact, there are at least 8 different ways, and this tutorial covers them all! But that doesn't mean there is no way to insert bullet points in Excel.

Insert bullet points in Excel with keyboard shortcuts.

Type bullet points into cells using special fonts.

Create a custom format for bullet points.

KEY COMMAND FOR BULLETS MICROSOFT HOW TO

How to insert bullet points in Excel using keyboard shortcuts The quickest way to put a bullet symbol into a cell is this: select the cell and press one of the following combinations using the numeric keypad on your keyboard. Alt + 7 or Alt + 0149 to insert a solid bullet.Īpart 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: To repeat bullet points in non-adjacent cells, select a cell with the bullet symbol and press Ctrl + C to copy it, then select another cell(s) where you want to have the bullets and press Ctrl + V to paste the copied symbol. If you are using a laptop that does not have a number pad, you can turn on Num Lock to emulate a numeric keypad.Īs the result, you will have the entire bullet list in a single cell like shown in the screenshot below: To add multiple bullet points to the same cell, insert the first bullet, hit Alt + Enter to make a line break, and then press one of the above key combinations again to insert a second bullet.

Key command for bullets microsoft