Instead, Excel can automate this process so that whenever you add or remove data from a cell, the column automatically readjusts without you having to perform any more actions.

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.