How to insert multiple rows in excel

Configurare noua (How To)

Situatie

Someone needs to add multiple rows in Excel.

Solutie

1.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.
Use Shift + Space shortcut to select entire 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.
Select entire lines using the row number buttons

2.Go to the Home tab in Excel and click on the Insert icon.
Click on the Insert icon to add multiple rows in Excel

You will see your table in Excel with the rows inserted below the necessary line.
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.
1.Select the cells where the empty rows need to appear and press Shift + Space.
2.When you pick the correct number of rows, right-click within the selection and choose the Insert option from the menu list.
Choose the Insert option from the menu list

Tip. If your cells contain any formatting, use the Insert Options icon to match the format.
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 solutie

Permanent

Voteaza

(10 din 18 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?