Quick Trick: Instantly Delete Cells

Directions: Select one or more cells and while holding ctrl, press the “-” key. Then choose how you would like the cells to shift. 

Example: Since John was fired, we wanted to delete his sales and shift all the cells to the left.

Bonus! The Total column updated the calculation now that John’s sales are gone.