How to Add Bullet Points in Excel |
There are several workarounds you can use to achieve this effect. Below, I’ll guide you through a couple of methods to add bullet points in Excel:
Method 1: Using ALT Codes
One way to insert bullet points in Excel is by using ALT codes. Here’s how you can do it:
Place your cursor in the cell how to add bullet points in excel where you want to insert the bullet point.
Press and hold the ALT key on your keyboard.
While holding down ALT, type the bullet point symbol’s ALT code, which is 0149.
Release the ALT key.
The bullet point symbol (•) should now appear in the selected cell. You can repeat these steps for each cell where you want to add bullet points.
Method 2: Copying and Pasting
Another method to add bullet points in Excel is by copying and pasting them from other programs like Word or PowerPoint. Here’s how:
Open a program like Word or PowerPoint where you can easily insert bullet points.
Type the text and format it with bullet points as desired.
Select the text containing the bullet points.
Press Ctrl + C on your keyboard to copy the text.
Now, switch to Excel and navigate to the cell where you want to insert the bullet points.
Press Ctrl + V on your keyboard to paste the text.
The text with bullet points should appear in the selected cell in Excel. You can adjust the cell size and alignment as needed.
Method 3: Using Custom Number Formats
You can also create custom number formats in Excel to display bullet points. Here’s how:
Select the cell or range of cells where you want to add bullet points.
Right-click on the selected cells and choose “Format Cells” from the context menu.
In the Format Cells dialog box, go to the Number tab.
Select “Custom” from the Category list.
In the Type box, enter three double quotation marks (“”) followed by a space and the text you want to display as a bullet point. For example, enter “”” •”” (without the quotes) to display a bullet point followed by a space.
Click OK to apply the custom number format.
The selected cells should now display bullet points using the custom format you specified.
Комментировать | « Пред. запись — К дневнику — След. запись » | Страницы: [1] [Новые] |