Multi-Record Edit

To edit multiple records in a list:

1. Select them (see Rows (Records)), and click Edit in the Records group of the Home tab.

   The Multi Record Edit window is then displayed.

   

2. The window lists all the columns in the list. Click the Selected checkbox next to a column if it is to be edited and enter the required value in the Value field.

3. Repeat this for every column that is to edited. Check the Select all checkbox to check all Selected checkboxes.

4. Once all required columns have been selected and values entered for them, click OK. The window closes all the selected records are updated.

   For example, to set the description of every selected record to "Drum", check the Selected checkbox for the DESC column, and enter "Drum" in the Value field. When OK is clicked, the value in the DESC fields for every selected record is set to "Drum". Existing values are overwritten.

Copy First Record’s Data to Other Selected Records

To set values of the selected records to those of the first record selected in the list, check the Copy first record’s Data checkbox.

Note:
The "first record" does not necessarily mean the first (upper-most) record listed of those selected, it means the first record that was selected when the selection of multiple records was made.

The Value fields are then populated with the values of the first record.

Select columns to update with these values as described above, and click OK to apply these values to the other selected records.