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!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s