Ways to insert blank rows in an Excel worksheet

ways to insert blank rows in an Excel worksheet

1, enter the number "1" and "2" in the beginning cell of a column outside the data area of the worksheet, as shown in Figure 1. Select the 2 cells at the same time, position the mouse pointer over the lower-right corner of the marquee, and when the mouse pointer changes to a cross-cursor shape, drag the mouse to fill the other cells in the column, as shown in Figure 2.

Figure 1 Input data

Figure 2 Populating the data

2, in the next 2 cells in the column, enter the number "1.2" and "2.2" respectively, as shown in Figure 3. The data is then padded down using the same method as the step (1), as shown in Figure 4.

Figure 3 Entering a number

Figure 4 Padding data down

3, on the Start tab, in the Edit group, click the Sort and Filter button to select the Ascending option in the Open Drop-down list, as shown in Figure 5.

Figure 5 Selecting the "Ascending" option

4. The worksheet will be sorted in ascending order with the column data as the primary keyword, as shown in Figure 6. Select the column and press the DELETE key to delete the data, and the table will be inserted in a blank row, as shown in Figure 7.

Figure 6 data in ascending order by primary keyword

Figure 7 inserting blank rows in a table

Attention

If you have a few rows of data in your worksheet, you can also use the following method to insert blank rows. Hold down the CTRL key to select the odd rows in the worksheet, and on the Start tab, in the Cells group, click the Down Triangle button on the Insert button, and select the Insert blank worksheet Row command in the Open Drop-down list. Similarly, you can insert blank columns in a similar way.