To delete a range of cells, hold down SHIFT while you drag the fill handle up and to the left. The fill handle is located ...