Ways to insert blank rows in an Excel worksheet

Source: Internet
Author: User
Tags delete key

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.