Using the tools and features in the Ribbon is probably how you’ll first learn to do things in Excel.
Similarly, there is an ‘Insert’ tool right in the Ribbon under the ‘Cells’ group of the ‘Home’ tab.
To insert multiple rows using this tool, select first where you would like to insert the rows.
You can do this in two ways:
- Select the cells in which rows you would like to insert the rows and press ‘Shift’ + ‘Space’ to select the rows where the cells are located
- Directly select the rows by clicking their respective column numbers
Then, make sure you’re on the ‘Home’ tab.
Click the ‘Insert’ icon found on the ‘Cells’ group.
After clicking the icon, you’ll immediately see the inserted rows on the worksheet.