What is the keyboard shortcut to add a new row above a given row in Microsoft Excel ........

computer GK (NABARD) MS Office

What is the keyboard shortcut to add a new row above a given row in Microsoft Excel?

This questions was previously asked in

Nabard grade-A,Previous year Memory Based Paper (2022)

Alt + C + I

Shift + I + R

Alt + I + R

Shift + Spacebar

Alt + F11

- Option 1: Alt + C + I

- Incorrect. This does not correspond to any relevant Excel shortcut for adding rows.

- Option 2: Shift + I + R

- Incorrect. This combination does not function for inserting rows in Excel.

- Option 3: Alt + I + R

- Correct! This is the right keyboard shortcut in older versions of Excel to insert a new row above the selected cell.

- Option 4: Shift + Spacebar

- Useful for selecting the entire row, but not for inserting a new row.

- Option 5: Alt + F11

- This opens the VBA Editor, unrelated to adding rows.

Submit Error