How To Copy Data In Alternate Rows Selected In Excel

In this tutorial, learn how to copy data in alternate rows in Excel. You can insert your required data in the alternate rows on selected columns.

Step-by-step Process to Copy Data In Alternate Rows Selected In Excel

There are few simple steps which you have to follow to copy data to alternate cells.

1: Copy and paste code to the starting cell

First of all, you have to copy the code =MOD(ROW(A1),2)=0 to the starting cell in Excel. When you paste the code to the cell, you will get a ‘FALSE’ text showing in the copied cell.

Copy and paste =MOD(ROW(A1),2)=0 to the starting cell

This is the code which creates an alternate different text when copied in the next step. It shows cell A1 inside the code when you check it. However, it does not mean that you only can copy it to the column A. You can copy the code to any cell of your excel sheet where you want to put data.

In the above example, the code is copied to column C and display ‘FALSE’ text.

2: Copy this cell to the end of the Required Cell
After you copy the code to the cell, you have to drag and copy the code to the end required cell. The end cell is the limit cell to which you want to put alternate data.

The copied code shows the alternate ‘TRUE’ and ‘FALSE’ text to alternate rows of a column. See the below image showing the content after you copy the code.

Copy this cell to the end of the Required Cell

You can use the ‘TRUE’ alternate cell or ‘FALSE’ alternate cells as per your requirements. However, these steps using the ‘TRUE’ alternate rows to create alternate results easily in Excel.

3: Go to the start Cell and click Filter given under Data>>Filter
There are alternate text starts appearing where you have to add filter option. To add a filter, you have to click the filter button given under the Data menu tab. This can be used to filter the required data from the given content.

The below image shows the place where you have to visit and click the filter option.

Go to the start Cell and click Filter given under Data Filter

You can also use another method of selecting the filter option using only a keyboard shortcut. You have to visit the required place and press the keyboard button shortcut ‘ctrl’ + ‘shift’ + ‘L’. This will add a filter in the selected cell given in the above image.

4: Click Filter dropdown and click only ‘TRUE’ checkbox in the filter dropdown
You have to click the filter dropdown given as in the below image. The dropdown contains the various content options to select. In these options, you have to select only the ‘TRUE’ option and unselect other options.

Only the ‘TRUE’ text content starts to appear in the content. See the image below to check the content after selection.

Click Filter dropdown and click only TRUE checkbox in the filter dropdown

However, you can also select ‘FALSE’ option from the filter dropdown as per your requirement.

5: Go to first TRUE and enter Alternate data to copy
If you want to add the record to the ‘TRUE’ cells, you have to paste your required data in the first ‘TRUE’ text showing cell. However, you can also use the ‘FALSE’ text cells to add data. This is the data content which you have to copy to the alternate selected rows.

Go to first TRUE and enter the data to copy

In the above example, we have chosen to ‘TRUE’ cells to add the data. See the above image to add your own data.

6: copy paste the same data to other TRUE cells
You have pasted the data to the start cell. Now, copy the pasted data to all the ‘TRUE’ text cells. This adds the data to all the required cell. All you have to do is to remove the ‘FALSE’ showing cells in the next step.

copy paste the same data to other TRUE cells

The above image showing the pasted data to all the required cells. You can change the data and copy paste other data as per your requirement.

7: Click Filter dropdown and click only ‘FALSE’
Now, you have to just remove the ‘FALSE’ cells and your alternate data is ready to display in Excel. To delete the ‘FALSE’ text cell, you have to first open the filter dropdown option. In the dropdown, select the checkbox for ‘FALSE’. This display only the ‘FALSE’ cells as given in the image below.

Click Filter dropdown and click only FALSE

8: Last step – Select and Delete all FALSE cells
In the last step, you have to just select all the ‘FALSE’ cells and delete them. After the deletion, you will get only the required data in the required place in Excel.

Final step - Select and Delete all FALSE cells

Final Output

The below image showing the output contains the data in the alternate cells. You can add as many alternate data in the Excel sheet using this method.

Final output alternate cell data

Hope, you like this post of how to copy data to the alternate rows in Excel. If you have any query regarding the tutorial, please comment below.

Also tell me, which method you are using to add your data to the alternate rows of Excel sheet.

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.