See all How-To Articles

How to Create a Bulleted List in Excel & Google Sheets

This tutorial will demonstrate how to create a bulleted list in Excel and Google Sheets.

 

Bullet intro

 

There are several ways that bulleted lists can be created in Excel. This article will introduce you to a few methods.

Creating a Bulleted List With a Shortcut Key

1. Select the cell you wish to start creating your bulleted list in, and then while holding down the ALT key on the keyboard, on your numeric keypad, type 0149.

 

Bullet alt

 

2. Press the SPACE bar to put a space between the bullet and the text and type in the text required.

 

Bullet Text

 

3. Press the ENTER key to enter the bullet and text into the cell and move down to the next cell.

4. Repeat the process for each item in the list.

 

Bullet List

 

Create a Bulleted List Using Format Cells

1. Type the list required into Excel.

 

Bullet NoBullets

 

2. Highlight the cells required (1) and then, in the Ribbon, select Home > Number > Number Format (2).

 

Bullet Number Format

 

3. Select Custom from the list, and then type ALT+0149 on the numeric keypad and then “@” into the text box.

 

Bullet CustomFormat

 

4. Click OK.

 

Bullet Bullet Custom Number

 

Creating a Bulleted List in a Separate Column

1. Type only the text for the bulleted list, making sure that there is an empty column to the left of it.

 

Bullet Empty Column

 

2. Click in the blank cell to the left of the first item in the list and then, in the Ribbon, select Insert > Symbols > Symbol.

 

Bullet Number Insert Symbol

 

3. In the Symbols tab, in the Font box, (1) select Wingdings and (2) scroll down to find an appropriate bullet for the list.

 

Bullet Symbols Wingdings

 

4. Click Insert to insert the symbol into the selected cell and press ENTER.

 

Bullet Symbols Bullet

 

5. Drag the fill handle in the bottom right hand corner of the cell down to copy the bullet down to the remaining cells in the list (or copy-paste the bullet into the cells).

 

Bullet Symbols Bullet Copy

 

How to Create a Bulleted List in Google Sheets

Creating bulleted lists in Google Sheets is similar to creating them in Excel.

Creating a Bulleted List With a Shortcut Key

1. In the cell where the first bullet is required, hold down ALT on the keyboard and on the numeric keypad, type 0149; then type in the text required.

 

Bullet GS AltKey

 

2. Repeat this for the entire list.

 

Bullet GS BulletedList

 

Create a Bulleted List in a Separate Column

1. Type the text for the bulleted list and make sure that there is an empty column to the left of it.

 

Bullet GS BlankColumn

 

2. In the empty cell, hold down ALT on the keyboard and on the numeric keypad, type 0149 and press ENTER.

 

Bullet GS AltBulletedList

 

3. Drag the fill handle to copy the bullet down the rest of the list.

 

Bullet GS DragHandle

 

Custom formatting is not available to create bulleted lists in Google Sheets.