Creating a List

graphics/microsoft38.gif

To create a list in Excel, you can enter data on worksheet cells , just as you do on any other worksheet data, but the placement of the field names and list range must follow these rules: (1) Enter field names in a single row that is the first row in the list (2) Enter each record in a single row (3) Do not include any blank rows within the list range (4) Do not use more than one worksheet for a single list range. You can enter data directly in the list or in a data form, a dialog box in which you can view, change, add, or delete records in a list. Don't worry about entering records in any particular order; Excel tools can organize an existing list alphabetically , by date, or in almost any order you can imagine.

Create a List

graphics/one_icon.jpg

Open a blank worksheet, or use a worksheet that has enough empty columns and rows for your list.

graphics/tow_icon.jpg

Enter a label for each field in adjacent columns across the first row of the list.

graphics/three_icon.jpg

Enter field information for each record in its own row; start with the row directly below the field names.

graphics/foure_icon.jpg

Select the range of cells for the list.

graphics/five_icon.jpg

Click the Data menu, point to List, and then click Create List.

graphics/six_icon.jpg

Click OK.

graphics/10inf02.jpg

graphics/10inf03.jpg

Did You Know?

You can hide the border of inactive lists . Click a cell in the list, click the Data menu, point to List, and then click Hide Border Of Inactive Lists.

You can display a total row in a list . If your list contains numbers , click the Toggle Total Row button on the List toolbar to display a row at the bottom of the list with the word "Total" in the left-most cell and an appropriate Subtotal formula in the right-most cell.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net