‘You can’t Change Part of an array’ When Sorting or Editing/Deleting Cell in Excel

Microsoft Excel Tips and Tricks

In this Microsoft Excel video tutorial I demonstrate how to deal with the ‘You can’t change part or an array’ error message. You may encounter this error message when you are attempting to sort data or when you are trying to edit or delete a cell.

Credit Chester Tugwell