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:

excel-multiplerowinsert-20180911-1

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:

excel-multiplerowinsert-20180911-2

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

excel-multiplerowinsert-20180911-3

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

excel-multiplerowinsert-20180911-4

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

excel-multiplerowinsert-20180911-5

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s