“List”

In Excel 2003, we can store information as a list, but do not worry, most of what can be done using the “List” feature in Excel 2003, can also be done in previous versions of Excel.
The information we collect in a “List” is stored in columns in a database which are called “Fields”.
Each “Field” has a different type of information.
eg, FirstName, LastName, Address, City, State, Zip.
Each “Field” is called a “Record”.
To create a “List” in Excel, we click “Data” from the menu bar, select “List” and choose “Create List ”

We give the “Range” of titles in our “Fields”.

We select the “My list has headers” box and click on Ok

This creates our “List”, and adds a new row with a * character in which we can add a new “Record”.

In previous versions of Excel, to select the rows that we want to use as titles, click on “Data” from the menu bar, click “Filter” and select “AutoFilter”.

More about “AutoFilter” in lesson 16

Add and modify “Records”

Once the structure of the “List” is created, we can add “Records”.
We add the first “Record” to our “List” just below the titles.
In Excel 2003 it is the row with the * character.
Each piece of information that we enter in a “Record” must match the title.
for example. we give a name in the name “Field”.
Additional “Records” will be added in the next row in the “List”. We never store a row on our list.
We modify “Records” in the same way as we would change ordinary “Fields” in Excel.

“Insert” Rows and columns

We may also “Insert” rows or columns in our “List”.
To do this we right-click the child row (s), or the column (s) on the right and choose “Insert”.
Do not forget to provide the information in the rows, so that you do not have empty rows.

“Delete” Rows and columns

We can remove rows or columns by right-clicking on the letter of the column or row number.
And selecting “Delete” from the popup list.
This removes the entire column or row.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats