Add, edit, or delete data

If you can't add, edit, or delete data in a PivotTable list, it means one of the following:

Add data

  1. Click a cell in the blank row marked with an asterisk (*).
  2. Type the data you want in the first field, and then press TAB to move to the next field.
  3. Do one of the following:

Edit data

  1. Click the cell that you want to edit.
  2. Type the new value.
  3. Do one of the following:

Delete data

Notes