Insert multiple rows in Excel - it's that easy
If you want to insert several empty rows into an existing Excel spreadsheet, you can easily do this using the "Insert cells" command. In this practical tip, we will show you exactly how this works.
Insert multiple blank lines in Excel - Here's how
- Mark the desired line by clicking on the number on the front of the worksheet.
- Hold down the left mouse button and select as many lines as you want to insert.
- The marked lines are now highlighted in color.
- Now right-click in the marked area and select "Insert cells" from the context menu.
- The number of marked lines are now added at the top.
Pro tip: Insert lines even faster with a practical key combination
As soon as you have marked the lines as in the example, you can use the key combination [CTRL] + [+].