Question

In Excel 2007, what is the keyboard shortcut to delete a selected row ?

• A. Shift + D
• B. Ctrl + -
• C. Alt + R
• D. Shift + Alt + X

Answer 1

Answer:

B. Ctrl + -

Excel Row Deletion Shortcut

• In Microsoft Excel 2007, the primary keyboard shortcut for deleting a selected row is Ctrl + - (Control key plus the minus key).
• This shortcut offers a quick way to remove entire rows from a spreadsheet without using the mouse.
• To use this shortcut:
  1. First, select the entire row or specific cells within the row you wish to delete.
  2. Then, press and hold the Ctrl key and press the - (minus sign) key.
  3. A dialog box titled 'Delete' will appear, offering options such as 'Shift cells up', 'Shift cells left', 'Entire row', and 'Entire column'.
  4. Select 'Entire row' from the options and click 'OK' or press Enter to confirm the deletion.
• Alternatively, after selecting the row, you can right-click on the selected row header and choose 'Delete...' from the context menu, which also brings up the 'Delete' dialog box.
• It's important to note that shortcut keys can sometimes vary slightly between different versions of Excel or depending on keyboard layouts, but Ctrl + - is the standard for row deletion in Excel 2007 and many subsequent versions.
• Understanding these shortcuts can significantly improve efficiency when working with large datasets in Excel.

Related Excel Functions

• Ctrl + D: Fills down the content of the top cell in a selected range to the cells below.
• Ctrl + R: Fills right the content of the leftmost cell in a selected range to the cells to the right.
• Ctrl + Shift + =: Inserts the SUM formula for the selected range.
• Ctrl + 1: Opens the 'Format Cells' dialog box, allowing extensive customization of cell appearance.