Let’s say you are working on an Excel worksheet and realize that you need to insert additional rows of data. Fortunately, Excel has a built-in feature that allows users to insert multiple rows. The process is the same no matter how many rows you want to insert.
Things to Remember: Inserting a row of data into your spreadsheet is relatively easy and does not require any training. To create a new row of data, you will need to know where you want the new data column to be placed. You will also need to know how many rows you want to insert.
Use the Insert Menu
- Select the rows where you want to insert the new rows.
- Then, click on the Insert icon in the Home tab.
- Now, it will insert blank rows in place of the rows you just selected.
Use the Keyboard Shortcut
- Click and Select the Row cells where you want to add the new rows.
- Then, press Ctrl + Shift + (= sign).
- Now, a pop will appear on your screen, enabling the “Entire Row” option and clicking ok.
- That’s it. Excel will add multiple rows of blank data in the selected location.
Using Mouse Shortcut
- Click and Select the Row where you want to add the new rows.
- Do right-click. Drop down list will open.
- Then, click on the insert option, and voila!
Use the Access Key
- Click and Select the Row cells where you want to add the new rows.
- Use Shift+Space and then this will select the entire rows.
- Now, use the keyboard shortcut:
- Press Alt+I
- Press Alt+R
- Then. it will Excel will add multiple rows of blank data in the selected location.