SECTION 2
Lesson 2.2: Working with Records and Fields

   

 

 

As stated earlier, a record is a collection of fields in a row. If you feel that your records do not contain enough information, you can add additional fields. To add a field, you must first insert a new column into your list. To do this, right click on the column heading to the right of the spot where you want to insert a column. From the menu, choose Insert->Column.

 

 

Excel will insert a column just to the left of the column you right clicked on. The new column will be labelled column1 (or column2 or column3 and so on depending how many columns you insert).

 

You will probably want to change the heading to a more meaningful field name than Column1. To do this, just click the cell that contains the new column heading and edit it in the formula bar.

 

 

 

 

 A list before a column is added.

 

 

 

  

The same list after a column is added.