Instructions for adding alternate blank lines on Microsoft Excel

Microsoft Excel is a familiar tool for everyone who does office work, especially for those who regularly handle large amounts of data, statistics tables, etc. In the process of performing operations with Excel You will need tricks to handle data tables such as adding an alternate blank line to Excel.

So how to insert an alternate white line into the table data, statistics on Excel? If you do not know how to do it, follow the article below of Network Administrator.

To be able to add alternating white lines in Excel, we will use the Sort feature in Excel .

Step 1:

Open Excel file to add alternating white lines in the content. First, add the last column of the sequence number table from 1 to the end and repeat in the lines without the data below.

Instructions for adding alternate blank lines on Microsoft Excel Picture 1

To work faster, enter the number 1 then press and hold Ctrl and drag the right corner and drag downwards.

Instructions for adding alternate blank lines on Microsoft Excel Picture 2

Step 2:

Next, at the line of the order number added below, right-click and choose Sort and select Custom Sort .

Instructions for adding alternate blank lines on Microsoft Excel Picture 3

Step 3:

The Warning Warning small window appears. We click the Sort button right below. Note , check the Expand the selection section.

Instructions for adding alternate blank lines on Microsoft Excel Picture 4

Step 4:

In the New Sort view , remove the My data has header area .

Continuing Sort by we select Column E. The order will leave Smallest to Largest from the smallest to the largest. Then click OK .

Instructions for adding alternate blank lines on Microsoft Excel Picture 5

The end result will appear to add an alternate white line in the Excel table content as shown below. We just need to delete the sequence number in column E and finish.

Instructions for adding alternate blank lines on Microsoft Excel Picture 6

Note , if you want to add 2 or 3 white lines to the table, you also need to create a sequence number from 1 to the line you want to insert, then if you want to insert 2 or 3 lines, repeat the corresponding number.

As shown below, I will create 2 alternating white lines in the table, I will create 2 more columns from 1 to 3.

Instructions for adding alternate blank lines on Microsoft Excel Picture 7

Then, perform the same steps as above and give the result as shown below.

Instructions for adding alternate blank lines on Microsoft Excel Picture 8

So you can add one or two white lines arbitrarily into the data table already. How to insert a blank line or more than 2 white lines in Excel differs from adding only the numbered column from 1 to the line to insert.

Refer to the following articles:

1. You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!

1. Summary of expensive shortcuts in Microsoft Excel

1. These are the most basic functions in Excel that you need to understand

I wish you all success!