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 GD PYP (Held on 4 Feb 2025 S1)

    languageIcon English
    • pdpQsnIcon80 Questions
    • pdpsheetsIcon160 Marks
    • timerIcon60 Mins
    languageIcon English
    Free
    Must Attempt

    Hindi Section Test 1

    languageIcon English
    • pdpQsnIcon20 Questions
    • pdpsheetsIcon40 Marks
    • timerIcon12 Mins
    languageIcon English
    Free
    Must Attempt

    SSC GD Constable Full Mock Test 1

    languageIcon English
    • pdpQsnIcon80 Questions
    • pdpsheetsIcon160 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
    353k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow