How to Create Lists in Excel

By Techwalla Computers Editor

Use a spreadsheet program like Excel to create lists. Create lists in rows or columns that you can manipulate with ease. The following directions will help you create lists in Excel. A list in Excel is a collection of data grouped together.

Things You'll Need

  • Computer
  • Microsoft Excel 2003 or newer

Step 1

Double-click your "Excel" icon or open Excel from the start menu.

Step 2

Type a title across the first row of your page. The title will appear across cells if you click and drag the line next to the right of the cell. Use a large font like 18 pt. and make it bold so it stand out from the rest of the text.

Step 3

Underline the title by selecting the title words and then clicking the "U" button on the toolbar at the top of the screen. Press "Enter" to skip a line.

Step 4

Type the words or numbers into the first cell of your screen under the title. Each square represents one cell.

Step 5

Divide up the list into columns or rows. Organize the data by using different colors or by using alphabetical order. Enter the information from top to bottom, left to right. You can use words and numbers. Use headings for each column or row.

Step 6

Select the range of cells you want in your list. Choose "Data" from the "Menu" bar at the top of the page.

Step 7

Choose "List" and then "Create List." The "Create List" dialogue box comes up. Confirm the range of the data by looking at the cells that are showing in the "List Dialogue" box. Click "Ok."

Step 8

Add new information to your list where the asterisk is at the bottom of the list on your screen. The asterisk will drop down to the next cell below, and you can keep adding to the list.

Tips & Warnings

  • Always double-check your data entry.