Steps to insert 3 blank rows
Answers
Just use space bar :)
Nice and simple does the trick
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.
Insert multiple rows in Excel using the standard menu options
Excel - Insert row shortcuts to speed up pasting blanks
Use numerical keypad shortcut to add rows in Excel
Special shortcut to insert rows in Excel if there's data to the right of your table
Add empty rows between multiple data lines in Excel
Insert multiple rows in Excel using the standard menu options
Below you'll find the most obvious ways for pasting blank rows which is employing the Insert functionality.
Pick one or several rows where the blanks will appear. To do this, select the destination cells and use the Shift + Space shortcut to turn them into rows.
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.
Go to the Home tab in Excel and click on the Insert icon.
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.
Select the cells where the empty rows need to appear and press Shift + Space.
When you pick the correct number of rows, right-click within the selection and choose the Insert option from the menu list.
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.
Excel - Insert row shortcuts to speed up pasting blanks
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.
Select the necessary number of rows where the blank lines will appear by picking the corresponding cells and pressing Shift + Space. The current content will be moved down to make room for the new rows.
Then press Alt + I. Then, holding the Alt button press R.
Voila! You can see the new rows added below. Please keep reading - the most interesting details are ahead.
Use numerical keypad shortcut to add rows in Excel
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.
Select the range in Excel to insert a new row. To do this left-click on the row number button next to the fist cell of the selection and extend the range keeping the left mouse button pressed.
Now press Ctrl + Plus on the numerical pad.
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.