Inserting multiple rows in Excel may be one of the numerous tasks you come across daily. In today's article, I hope to inspire shortcut-oriented users by showing some really quick ways to add new rows in Excel. You'll also see how to solve this task using standard menus and Ribbon buttons and how to add empty rows between multiple data lines.
If you work in Excel actively, you know that most of the tables are constantly changing. Very often, they get modified when you add new details and as a result insert multiple empty rows for them. If you add rows below or above certain data in your spreadsheets every now and then, the standard Insert command looks like the most evident solution. However if pasting blank lines is your day-to-day or even hour-to-hour routine in Excel, insert-row shortcuts are by far more effective.
This article will be useful both for the shortcut people and for users who prefer standard Excel options located on the Ribbon and within different menu lists. You will find several solutions how to insert new rows in Excel with shortcuts and learn how to add blank rows between existing lines with data.
Below you'll find the most obvious ways for pasting blank rows which is employing the Insert functionality.
Tip. You can also select entire lines using the row number buttons. You'll see the number of the highlighted rows next to the last button.
You will see your table in Excel with the rows inserted below the necessary line.
You can get the same result if you use the Insert menu option. Please see the steps below.
Tip. If your cells contain any formatting, use the Insert Options icon to match the format.
Again, you'll see multiple rows inserted in your table in Excel. Now you can enter the necessary details to get your report ready.
Tip. If you need to remove rows with irrelevant data, you'll find some effective solutions here: How to delete rows in Excel based on a cell value.
If you think that the ways described above are fast enough, check out the below options to see what is really quick. I'll share how to insert new rows in Excel with keyboard shortcuts.
The first shortcut I'd like to cover is the one repeating the Ribbon option Insert Sheet Rows.
Voila! You can see the new rows added below. Please keep reading - the most interesting details are ahead.
Even if you don't enter large amounts of numeric data, you can still benefit from using the number pad. The Excel insert row shortcut I show below will work only if you press the Plus key on the numerical keypad.
If you prefer to use the main keyboard, you can get the same results if you use the Ctrl + Shift + Plus on the main pad.
Tip. If you need to add numerous rows at a time, like one or two hundred, take the advantage of the F4 button. It repeats your last action. For example, if you want to insert 100 empty rows, select a range with 10 rows, use the shortcut you like to insert the blanks and then just press F4 ten times.
Ctrl + Plus hotkey is fast and reliable, but if you have data to the right of your main table like on the screenshot below, it may insert blanks where you wouldn't like them to be and break the structure.
If that's your case, in this part you'll find a solution for inserting multiple new rows in your Excel table and keeping the structure of the data next to your list as is.
You will see the Create Table dialog box that will help you select the necessary range.
That's how your data look like after being formatted as Excel Table:
Tip. You can achieve the same result if you select the necessary range and press Ctrl + Plus on the numerical keypad.
As you can see, new rows didn't appear between the rows to the right:
Suppose you have a report in Excel and need to insert a blank line between each of the existing rows in your table. There are two ways to solve this task - the first will work for relatively small lists and the second - for bigger ones.
If your spreadsheet is not so large, look at the steps below:
The second option will suite better if you have a big data table.
Now you can delete the helper column.
Tip. If you like operating Excel from you keyboard, this tutorial may come in handy: 30 most useful Excel keyboard shortcuts.
That's it! You learned several shortcuts to insert multiple rows in Excel. Now you know all the fastest ways for adding blank rows to your data. I'll readily answer any questions you may have. Feel free to post your query below. Be happy and excel in Excel!
Table of contents