hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    In MS Excel 365, which of the following statements related to deleting rows in an Excel sheet is correct?
    Question



    In MS Excel 365, which of the following statements related to deleting rows in an Excel sheet is correct?

    A.

    If you want to delete multiple rows at once, simply select the rows by clicking and dragging over the row numbers, and then press ‘Ctrl’ and ‘space’.

    B.

    If you want to delete multiple rows at once, simply select the rows by clicking and dragging over the row numbers, and then press ‘Ctrl’ and ‘-’.

    C.

    If you want to delete multiple rows at once, simply select the rows by clicking and dragging over the row numbers, and then press ‘Ctrl’ and ‘+’.

    D.

    If you want to delete multiple rows at once, simply select the rows by clicking and dragging over the row numbers, and then press ‘Ctrl’ and ‘Enter’.

    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.

    Free Tests

    Free
    Must Attempt

    SSC CGL T-I Similar Paper (Held on 12 Sep 2025 S2)

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon200 Marks
    • timerIcon60 Mins
    languageIcon English
    Free
    Must Attempt

    SSC CGL T-I GA Section Test 01

    languageIcon English
    • pdpQsnIcon25 Questions
    • pdpsheetsIcon50 Marks
    • timerIcon15 Mins
    languageIcon English
    Free
    Must Attempt

    SSC CGL T-I Full Mock Test 1 (Exam Level)

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon200 Marks
    • timerIcon60 Mins
    languageIcon English
    test-prime-package

    Access ‘Delhi Police Constable’ Mock Tests with

    • 60000+ Mocks and Previous Year Papers
    • Unlimited Re-Attempts
    • Personalised Report Card
    • 500% Refund on Final Selection
    • Largest Community
    students-icon
    383k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow