You can edit multiple records at the same time using the list editor. If you want to update a single field on multiple records to have the same value, the list editor is the quickest method.

Before you begin

Role required: none

Procedure

  1. Select the records that you want to edit by performing one of the following actions.
    • To select multiple consecutive fields, hold Shift and drag in the desired fields, or select a cell and then press Shift + Up Arrow or Shift + Down Arrow.
    • To select multiple non-consecutive fields, hold Ctrl and click on each desired field individually (On Mac, use Cmd and select instead).
  2. Open the list editor by double-clicking (or clicking, depending on setup) in an empty area of the field.
    The number of selected rows that you’re editing is indicated. If any rows can’t be edited due to security constraints, that is indicated.
    Figure 1. Selected fields are highlighted in blue
    Selected fields
  3. Enter the appropriate values and select Save.