Posts Tagged 'sort and filter'

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 Input the number “1” into cell D2 in this range. Secondly, input number “2” into cell D3. After that, select the two cells. And then double click the fill handle on the...

Read more »