Correct option is B
In MS Excel 365, to delete multiple rows at once:
1. Select the rows by clicking and dragging over the row numbers.
2. Use the shortcut Ctrl + - (minus key) to delete the selected rows. This action deletes the selected rows and shifts the remaining rows upward.
Important Key Points:
1. Ctrl + -: Deletes selected rows or columns.
2. Select rows by dragging over their numbers in the row header on the left.
3. Deleted rows cause the rows below to shift upward automatically.
Knowledge Booster:
· Ctrl + Space: Selects the entire column of the active cell.
· Ctrl + + (Plus): Inserts new rows or columns, not deletes.
· Ctrl + Enter: Used to fill the selected cells with the current entry, not for deleting rows.