What happens to your worksheet after selecting the Delete Sheet Rows option?

All of the data in the selected row$($s$)$ will be erased and the worksheet area occupied by the deleted row$($s$)$ will turn gray.

All of the data in the selected row$($s$)$ will be erased and the row$($s$)$ will now appear empty.

The selected row$($s$)$ will be deleted and the rows above will shift down.

The selected row$($s$)$ will be deleted and the rows below will shift up$.$