How to Quickly Insert a Blank Row/Column into Every Two Adjacent Rows/Columns in Your Excel

In this article, we will introduce a method to quickly insert rows or columns into every two adjacent rows/columns quickly.

In the image below, now you are going to input rows into to every two adjacent rows in this range.

Instead of add rows one by one, you may also follow the methods below.

Insert Rows

1. Input the number “1” into cell D2 in this range.
2. Secondly, input number “2” into cell D3.
3. After that, select the two cells.
4. And then double click the fill handle on the right bottom of the range.

Therefore, you have filled the column with numbers.

5. In this step, input the number “1.5” into cell D14.
6. And then you need to input the number 2.5 into cell D15.
7. After that, select the two cells.
8. And then drag the fill handle downwards to get 12 numbers in this column.
9. Now put your cursor in the range.
10. Click the button “Sort & Filter” in your Excel.
11. And then choose the option “Filter” in the submenu.
12. Now click the small arrow in cell D1.
13. In the drop-down menu, choose the option “Sort Smallest to Largest”.
14. Next you can check the result of filter. Here delete column D in the target range.
15. Next click the button “Sort & Filter” in toolbar.
16. Now click this option “Filter” again in the list. Thus, you have inserted rows into every two adjacent rows for this range.

Insert Columns

Now if you are required to insert columns into every two adjacent columns, you can also use the sort feature.

1. Here input the corresponding numbers into the row 14.
2. Now click a cell in this range.
3. After that, click the “Sort & Filter” button in the toolbar.
4. Here select the option “Custom Sort” in the list.
5. In the “Sort” window, click the button “Options”.
6. Select the option “Sort left to right”.
7. Next click “OK”.
8. Now you will come back to “Sort” window. Set the row into Row 14. You may change according to your actual worksheet. And set “Values” in “Sort On” and set the order into “Smallest to Largest”.
9. After you have finished the setting, click “OK” in the window.

Thus, you have inserted columns into every two adjacent columns in the range.

10. Now delete the Row 14 in this range. And you have finished all the settings.

From the description in the above sentences, you can see that inserting rows or columns into every two adjacent rows/columns is very easy.

Excel Corruption will Delay Your Work

If you use Excel frequently and need to depend a lot on Excel to finish your work, you should take care of your Excel files. Once Excel corrupt, you have to spend a lot time to fix it. And this will delay your work. At this moment, a third party tool can help you. This tool can repair xls problem and other errors in Excel. With this tool at hand, you can easily retrieve all the data and information.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair doc problem and outlook repair software products. For more information visit www.datanumen.com