How do I add bullet points in Microsoft Excel?

If you have a numeric keypad on the right side of your keyboard, press ALT+7 for a bullet . Different fonts provide different symbols. If your font does not provide the bullet, try selecting a font such as Wingdings in the Symbol dialog box. Then enter character code 159.

How do I add bullet points?

Type* and a space before your text , and Word will make a bulleted list. To complete your list, press Enter until the bullets or numbering switch off.

What are the different types of bullet points?

Usually, a bullet point is represented by a centered dot (•), but there are different forms of bullets to pick from based on the writer's preference. For example, a diamond (♦), diamond cluster (❖), an arrow (➢), and square (■) are other popular bullet point types that can be used.

How do I add bullet points in sheets?

Place your cursor in the cell where you want to add a bullet point. Press and hold the 'Alt' key. While holding 'Alt', press the '7' key on your numeric keypad (ensure that Num Lock is on). Release both keys, and the bullet point will appear in the cell.

How do I add a list in an Excel cell?

Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, then select Data Validation. On the Settings tab, in the Allow box, select List . If it's OK for people to leave the cell empty, check the Ignore blank box.

What are the ways to bullet list?

Keep each item succinct for scannability (for example, 1 or 2 sentences each). Connect items appropriately. When using “and” or “or” at the end of each bullet point, use a comma and bold the “and”/”or” at the end of each bullet point . No more than 7 items without a break.

What are the 3 main types of bullets?

"round-nose" - The end of the bullet is blunted. "hollow-point" - There is a hole in the bullet that creates expansion when a target is struck, creating more damage. "jacketed" - The soft lead is surrounded by another metal, usually copper, that allows the bullet to penetrate a target more easily.

What are the 4 main parts of a bullet?

The basic components of ammunition are the case, primer, powder, and projectile(s) .

How do I add multiple bullet points in one cell in Excel?

If you'd like to insert a few bullets into the same cell, the fastest way is this: select the desired symbol, and click the Insert button several times. Put the cursor between the first and second symbols and hit Alt + Enter to move the second bullet to a new line .

How do I go to a new line in the same cell in Excel?

To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break . Double-click the cell in which you want to insert a line break. Click the location inside the selected cell where you want to break the line.

How do I add numbering in an Excel cell?

Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. But, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function .

10 Ways to Add Bullet Points in Microsoft Excel (2024)

Today I’ll show you how to add bullet points in Excel with steps and illustrative images so you can also do the same to highlight key points in your Excel workbook reports for clarity and enhanced readability.

Bullet points enhance the visual appeal of a document or presentation by adding structure and white space. Bullet points also help you to establish a hierarchy of information by indicating the main points and sub-points. However, there’s no simple user interface button on Excel that enables you to add such elements without guesswork. There’s one Bullets and Numbering group but that doesn’t work in normal circ*mstances.

In this quick Excel tutorial, you’ll explore how to insert bullet points in Excel using different tricks that you didn’t know until today. So, read until the end and make your Excel worksheets easier for readers to scan through and locate specific information quickly with Excel bullet points.

Excel Bullet Points Using Hotkeys

If you’re looking to learn how to put bullet points in Excel and you can pretty much remember anything you use once or twice, the keyboard shortcuts-based method is the best approach.

Here are the various hotkeys you can use while the worksheet is set to use any normal font like Arial, Calibri, etc.:

Alt + 7 for •
Alt + 9 for ○
Alt + 4 for ♦
Alt + 13 for ♪
Alt + 16 for ►
Alt + 26 for →
Alt + 254 for ■
Alt + 9+ 6 for ♠

10 Ways to Add Bullet Points in Microsoft Excel (1)

To add bullets, double-click on the target cell and press the Home key on the keyboard to go to the beginning of the text string or numerical values of the cell.

Now, press any of the above hotkey combinations to get your bullet point.

Repeat the steps for the rest of the cells in your worksheet.

Using the AutoCorrect Tool to Put Bullets in Excel

I personally like this method of inserting bullets when not using any automated methods mentioned later in this article. AutoCorrect allows you to replace a preconfigured letter or character with a bullet in Excel automatically.

10 Ways to Add Bullet Points in Microsoft Excel (2)

To configure your AutoCorrect tool to do so, bring up the Excel Options dialog by pressing Alt + F + T on your Excel software.

Click on the Proofing category in Excel Options and click on the AutoCorrect Options button in the right side menu.

10 Ways to Add Bullet Points in Microsoft Excel (3)

On the AutoCorrect dialog, enter a letter or character inside the Replace field. Then, enter the bullet type you want inside the With field. Here, you can use any of the previously explained keyboard shortcuts to insert a bullet of your choice. Don’t forget to click the Add button.

Now, click on the OK button twice to save the changes you’ve made.

10 Ways to Add Bullet Points in Microsoft Excel (4)

That’s it! If you type the configured letter, in this example it’s X, in any cell and press the Space bar, AutoCorrect shall change that to the configured bullet style.

If you type the same letter in a word or phrase, without spaces, AutoCorrect won’t change it to bullets.

Import Bullet Points in Excel From Word

You you can export your Excel worksheet’s text strings to a Word file. Format the content with bullets and import the content back to the spreadsheet.

10 Ways to Add Bullet Points in Microsoft Excel (5)

When copying content from Excel to Word, use the Ctrl + Alt + V keys to bring up the Paste Special dialog. There, choose Unformatted Text.

10 Ways to Add Bullet Points in Microsoft Excel (6)

Now, highlight content in Word and click on the Bullets command inside the Paragraph commands block of the Word Home tab. This should format the text strings to a bulleted list.

10 Ways to Add Bullet Points in Microsoft Excel (7)

Copy the content from the Word document and paste it on the destination cell range by pressing Ctrl + V.

10 Ways to Add Bullet Points in Microsoft Excel (8)

You can also press Ctrl + Shift + V to get miniature bullets.

Excel Bullet Points Using Symbol Tool

This is the only direct user interface command that allows you to put bullet points in Excel manually by clicking certain options.

10 Ways to Add Bullet Points in Microsoft Excel (9)

Access the target cell where you want the bullet in edit mode and go to the beginning of the text string.

Press Alt + N + U to bring up the Symbol dialog box.

Enter the value 2022 inside the Character code field to select the standard Bullet instantly.

10 Ways to Add Bullet Points in Microsoft Excel (10)

Click the Insert button to get your bullet in the cell.

Bullet Points in Excel Using a Formula

Suppose, you’ve got a column filled with text strings to which you’d like to add bullets in every cell.

10 Ways to Add Bullet Points in Microsoft Excel (11)

Go to an adjacent empty cell of the first cell of your target column. Enter the following formula inside the cell and hit Enter:

=CHAR(149)&" "&B2

Don’t forget to adjust the formula according to your own dataset.

You should see that Excel has added the bullet you wanted.

10 Ways to Add Bullet Points in Microsoft Excel (12)

Now, drag the fill handle down the column to add bullets to the rest of the text strings of the source column.

You can now delete or hide the source column.

Add Bullet Points in Excel Using Format Cells

You can configure a cell range or all the cells in the entire worksheet to insert a bullet when you enter a value or text string using the Format Cells tool.

10 Ways to Add Bullet Points in Microsoft Excel (13)

So, highlight the cell range where you’d like to automatically enter bullets. Now, press Ctrl + 1 to bring up the Format Cells dialog.

Click the Number tab and choose the Custom category in the left-side navigation panel.

Inside the Type field, enter this cell number code: ● @. Click OK to save the formatting.

10 Ways to Add Bullet Points in Microsoft Excel (14)

Now, you can start typing anything in these cells and Excel shall add the bullet at the beginning of the text string or numerical value.

Insert Bullets in Excel Using SmartArt

SmartArt lets you add preconfigured objects to your Excel worksheet to visually explain processes, hierarchies, relationships, pyramids, and more. The List object of Excel SmartArt allows you to create structured bulleted lists.

Open your Excel workbook and navigate to the worksheet where you want to insert the SmartArt with bullets.

10 Ways to Add Bullet Points in Microsoft Excel (15)

Click on the Insert tab in the Excel ribbon at the top of the window.

In the Illustrations group, click on SmartArt. The Choose a SmartArt Graphic dialog box shall show up.

In the Choose a SmartArt Graphic dialog box, select the category of SmartArt that best fits your needs. For bulleted lists, you can choose a SmartArt layout under the List category.

10 Ways to Add Bullet Points in Microsoft Excel (16)

Browse through the available SmartArt layouts and select the one that you want to use for your bulleted list. Click on it to highlight it. I’ve chosen the Square Accent List layout.

Click the OK button to insert the selected SmartArt into your worksheet.

10 Ways to Add Bullet Points in Microsoft Excel (17)

A placeholder for your SmartArt graphic will appear in the worksheet. Click inside the text pane of the SmartArt graphic to start typing your bulleted list. The text pane is on the left side of the object.

10 Ways to Add Bullet Points in Microsoft Excel (18)

Type your first bulleted item and press Enter to move to the next line and create a new bullet point. Repeat this process for each item in your bulleted list.

To add additional levels of bullet points (sub-bullets), press the Tab key on your keyboard before typing the text for the bullet point. This will indent the text and create a sub-bullet point.

10 Ways to Add Bullet Points in Microsoft Excel (19)

You can customize the appearance of your SmartArt graphic by using the options in the SmartArt Design tab using commands inside the blocks like Layouts, SmartArt Styles, and Reset.

Create Excel Bullet Points in a Text Box

If you find the bulleted lists created by the SmartArt objects a bit large and different, you should try the Text Box-based method.

10 Ways to Add Bullet Points in Microsoft Excel (20)

On your worksheet, go to the Insert tab and click on the Text Box button of the Text commands block. Doing so shall activate the Text Box creation cursor.

Click on the worksheet and draw the Text Box by dragging the cursor to the lower right corner.

10 Ways to Add Bullet Points in Microsoft Excel (21)

Now, copy and paste the cell contents into the Text Box. Use the Enter key to put a new text string in the next line.

10 Ways to Add Bullet Points in Microsoft Excel (22)

Highlight the whole content inside the Text Box and right-click.

10 Ways to Add Bullet Points in Microsoft Excel (23)

On the right-click context menu, hover the cursor over the Bullets menu and choose the bullet style you want by clicking any from the list.

10 Ways to Add Bullet Points in Microsoft Excel (24)

Excel shall create the bulleted list you need inside the Text Box.

Add Bullet Points in Excel Using VBA Programming

If you want to learn how to insert bullet points in Excel automatically in one or two clicks, you must try Excel VBA macro. VBA allows you to create macros that in turn allow you to transform un-bulleted lists to bulleted lists in Excel.

You can use the following VBA script to automate bulleted lists-making in Excel:

10 Ways to Add Bullet Points in Microsoft Excel (25)

Sub AddBullets() Dim rng As Range Dim cell As Range Dim userInput As Range ' Prompt the user to select the target cell range On Error Resume Next Set userInput = Application.InputBox("Select the target cell range:", Type:=8) On Error GoTo 0 ' Check if user canceled the input box or didn't select any range If userInput Is Nothing Then MsgBox "Operation canceled. No range selected.", vbExclamation Exit Sub End If ' Loop through each cell in the selected range For Each cell In userInput ' Add a solid round bullet to the beginning of the cell value cell.Value = ChrW(&H25CF) & " " & cell.Value Next cellEnd Sub

You can go through the steps mentioned in the following article to create a VBA macro using this script:

📒 Read More: How To Use The VBA Code You Find Online

You can use the above script as is. There’s no need to customize any part of this script since this is an interactive VBA macro. It automatically adjusts to your dataset.

10 Ways to Add Bullet Points in Microsoft Excel (26)

When you execute the macro, you’ll see a dialog box so you can select a cell range you want to transform.

10 Ways to Add Bullet Points in Microsoft Excel (27)

Then, the script scans through the selected cell ranges and replaces the existing content with bulleted lists of the same content.

⚠️ Warning: Create a backup copy of your Excel worksheet before performing this method because you won’t be able to use the Excel undo feature to revert to the previous state after you run a VBA script.

Excel Bullet Points Using Office Scripts

If you use Office Scripts to automate various tasks in your Excel workbook, you can use the same to add bullet points in Excel. Office Scripts enables you to easily share the code with colleagues and other collaborators so they can also use the same automation with minimum customizations.

Find below a simple Office Script that allows you to create a command button to apply bulleted list formatting to highlighted datasets in the active worksheet:

function main(workbook: ExcelScript.Workbook) { // Get the currently selected range. let selectedRange = workbook.getSelectedRange(); // Get the worksheet. let worksheet = selectedRange.getWorksheet(); // Get the values of the selected range. let data = selectedRange.getValues(); // Define the bullet. let bullet = "• "; // Loop through each cell in the selected range. for (let i = 0; i < data.length; i++) { // Get the current cell value. let cellValue = data[i][0]; // Add the bullet to the cell value. let bulletedCellValue = bullet + cellValue; // Replace the cell value with the bulleted cell value. // Note: The getCell method uses zero-based indexing for both row and column numbers. worksheet.getCell(selectedRange.getRowIndex() + i, selectedRange.getColumnIndex()).setValue(bulletedCellValue); }}

10 Ways to Add Bullet Points in Microsoft Excel (28)

Want to try out the script? It’s pretty easy! Go to the Automate tab on your Excel desktop or web app. Then, click the New Script button to bring up the Code Editor console on the right-side border of Excel.

Copy and paste the above script inside the Code Editor console. Then, click the Save script button to save the Office Script for future use.

Now, highlight the target dataset that you want to transform into a bulleted list.

10 Ways to Add Bullet Points in Microsoft Excel (29)

Hit the Run button on the Code Editor console to execute the code.

Excel shall add bullets to each highlighted cell at the beginning of the text strings or numerical values.

📝 Note: This method is only relevant for you if you’ve been using Excel for the Microsoft 365 desktop app or Excel for the web app with a valid Microsoft 365 Business Standard or better subscription. If you don’t see the Automate tab in Excel, it’s either due to the subscription you’re using or the organization’s IT admin has disabled Office Scripts.

Conclusions

There you go! You’ve learned all the tried and tested methods to add bullet points in Excel in easy steps. You can try the manual methods using hotkeys, AutoCorrect, Symbol tool, Format Cells dialog, and Excel functions. These are suitable if you can remember the steps and only need to add bullets occasionally.

However, if you’re working on projects where you often need to convert text strings to bulleted lists, you can use automated methods involving Excel VBA and Office Scripts.

If the article helped or you’d like to suggest a better method, do comment below!