The Best Ways to Make & Format Lists in Excel

Download Article

Add bullets, numbers, or drop-down menus to cells with our guide

Written by Nicole Levine, MFA

Last Updated: April 12, 2024 Fact Checked

Download Article

Bulleted or Numbered Lists

|

Pasting a List from Another App

|

Drop-Down Lists

|

Video

If you're wondering how to create a multiple-line list in a single cell in Microsoft Excel, you've come to the right place. Whether you want a cell to contain a bulleted list with line breaks, a numbered list, or a drop-down list, inserting a list is easy once you know where to look. This wikiHow will teach you three helpful ways to insert any type of list to one cell in Excel.

Method 1

Method 1 of 3:

Creating a Bulleted or Numbered List

Download Article

If you want to create a bullet or numerical list in a single cell with each item on its own line, start by double-clicking the cell into which you want to type the list. ^{[1]
X
Research source}
2
Insert a bullet point (optional). If you want to preface each list item with a bullet rather than a number or other character, you can use a key shortcut to insert the bullet symbol. Here's how:
- Mac: Press Option + 8 .
- Windows:
  - If you have a numeric keypad on the side of your keyboard, hold down the Alt key while pressing 7 on the keypad. ^{[2]
    X
    Trustworthy Source
    Microsoft Support
    Technical support and product information from Microsoft.
    Go to source}
  - If not, click the Insert menu, select Symbol , type 2022 into the "Character code" box at the bottom, and then click Insert .
  - If 2022 didn't bring up a bullet point, select the Wingdings font instead, and then enter 159 as the character code. You can then click Insert to add the bullet point.
Advertisement
3
Type your first list item. Don't press Enter or Return after typing.
- If you want your list to be numbered, preface the first list item with 1. or 1) .
This adds a line break so you can start typing on the next line of the same cell. ^{[3]
X
Trustworthy Source
Microsoft Support
Technical support and product information from Microsoft.
Go to source}
To continue your list, just enter another bullet point on the second line, type the list item, and press Alt + Enter or Control + Option + Return to open a new line. ^{[4]
X
Research source} When you're finished, you can click anywhere else on your sheet to exit the cell.

Method 2

Method 2 of 3:

Pasting a List from Another App

Download Article

1
Create your list in another app. If you're trying to paste a bullet list (or other type of list) into a single cell rather than have it spread across multiple cells, there's a trick to pasting the list. Start by creating your list in an app like Word, TextEdit, or Notepad.
- If you create a bulleted list in Word , the bullets will copy over to your cell when pasted into Excel. Bullets may not copy from other apps.
To do this, just highlight the list, right-click the highlighted area, and then select Copy .
Double-clicking the cell before pasting makes it so the list items will all appear in the same cell.
The context menu will expand.
The icon has a clipboard and a black rectangle. This pastes the list into the cell you double-clicked. Each list item will appear on its own line within the same cell.

Method 3

Method 3 of 3:

Creating a Drop-Down List

Download Article

If you want to be able to click a cell to view and select from a drop-down list, you can create a list with Excel's data validation tool. ^{[5]
X
Trustworthy Source
Microsoft Support
Technical support and product information from Microsoft.
Go to source}
2
Create a new worksheet in the workbook. You can do this by clicking the + next to the existing workbook sheets at the bottom of Excel. This worksheet is where you'll enter the items that you want to appear in your drop-down list.
- After you create the list on a separate sheet and add it to a table, you'll be able to create a drop-down list containing the list data in any cell you want.
3
Type each list item into a single column. Enter every possible list choice into its own separate cell. The items you type will all be available in the drop-down list.
- If you plan to make a lot of drop-down menus and want to use this same sheet to create all of them, add a header to the top of the list. For example, if you're making a list of cities, you could type City into the first cell. This header won't actually appear on the drop-down list you create—it's just for organization on this sheet that contains list data.
Include the header at the top of the list when highlighting. This opens the Create Table dialog.
5
Choose a header option and click OK . If you added a header to the top of your list, check the box next to "My table has headers." If not, make sure there is no checkmark there before clicking OK .
- Now that your list is in a table, you can make changes to it after creating your drop-down list, and your drop-down list will update automatically.
This will keep your list organized once you add it to your sheet. To do this, just click the arrow next to your header cell and select Sort A to Z .
This can be any cell on any worksheet in the workbook.
This is the cell where the list will appear, so give it a name that indicates the type of option you should choose from that list. For example, if you made a list of cities, you could type City here.
Make sure the cell is selected before doing this. If you don't see Data Validation in the toolbar, click the icon in the "Data Tools" section that has two black rectangles with a green checkmark and a red circle with a line through it. This opens the Data Validation window.
Additional options will expand.
This minimizes the Data Validation window so you can select your list data.
Click back over to the tab that has your list data and drag the mouse cursor over just the list items . Pressing Enter or Return will add the range to the "Source" field.
The selected cell now has a drop-down list. If you need to add or remove items from the list, you can simply make those changes on your new worksheet and they'll automatically propagate to the list.