Inserting multiple blank lines in an Excel spreadsheet

This is a really simple tip that I wish I had known about sooner, instead of copy and pasting blank rows for an Excel spreadsheet. Instead of just inserting a single blank row, you can easily insert multiple blank rows by highlighting the number of rows you need. Here’s how…

Here’s an example Excel spreadsheet with 15 rows of data:

In order to insert a blank row, I highlight the row I want the inserted row to appear above, and right-click on the highlighted row. That gives me the dropdown menu to select Insert:

Now I have my blank row, but what if I want five blank rows… or more?

This time, I highlight five rows and right-click to get the Insert option:

Voila! I have five blank rows now! Much faster than adding one at a time!