• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Creating a List

Getting started is easy. In fact, Excel may have already offered you the opportunity to use the List Manager.

To start a list:

1.
Simply start entering your information into your Excel document. You may be presented with a query guessing that you're creating a list (Figure 10.1), along with an offer to invoke the List Manager. Click Yes to skip the List Wizard steps below.

Figure 10.1. When it appears that a list is being created, Excel offers the List Manager.


or

Click the cell where you want the list to begin, and choose Insert > List to bring up the List Wizard (Figure 10.2).

Figure 10.2. Chose Insert > List to bring up the List Wizard.


2.
In Step 1 of the List Wizard, tell Excel whether you want to start with a new list, an existing spreadsheet, or an external file (Figure 10.3). You can also tell it whether you want to open the list into a new worksheet or an existing one, and you can pick a particular starting cell. Click Next when you're ready.

Figure 10.3. In the List Wizard, specify where the data is coming from and where you want to insert it.


3.
In Step 2 of the List Wizard (Figure 10.4), type in the name of each column for your list in order, and choose the data types from the pull-down list. Click Add after specifying each column. When you're finished, click Next.

Figure 10.4. Specify column names and data types


4.
In Step 3 of the List Wizard (Figure 10.5), give your list a name, and indicate whether you want Excel to add a totals row for you. Here you may also choose an AutoFormat style. When you're done, click Finish.

Figure 10.5. Name the list, and choose a totals row or Autoformat style if you wish.


The list appears where you specified, inside a special list frame (Figure 10.6).

Figure 10.6. The list appears in the document in a list frame.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint