What happens when you delete a selected cell range with the default option of shifting cells up?

What happens when you delete a selected cell range with the default option of shifting cells up?

• A. Shifts cells left
• B. Inserts a blank row
• C. Shifts cells up
• D. Clears contents only

Answer: (C)

When you delete a selected range and keep the default option, the remaining cells are moved to fill the gap by shifting them upward. This means data below the deleted cells in each column moves up to occupy the space, and the bottom cells in those columns become blank to make room. If the deletion covers multiple columns, each column’s data shifts up independently. This is different from shifting left, inserting blank space, or simply clearing contents without moving other data.

When you delete a selected range and keep the default option, the remaining cells are moved to fill the gap by shifting them upward. This means data below the deleted cells in each column moves up to occupy the space, and the bottom cells in those columns become blank to make room. If the deletion covers multiple columns, each column’s data shifts up independently. This is different from shifting left, inserting blank space, or simply clearing contents without moving other data.