@ Mikedk64
Are you actually deleting the cells or clearing the contents ?
ie: the delete key clears the contents whereas right clicking gives option to clear contents or delete which then asks about shifting cells.