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.

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

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

Step 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 that 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 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.

Step 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.

Step 3: Go to the Start Cell and Click Filter Given Under Data>>Filter

There are alternate text starts appearing where you have to add a 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.

Step 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 the ‘FALSE’ option from the filter dropdown as per your requirement.

Step 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 the cell. However, you can also use the ‘FALSE’ text cells to add data. This is the data content that 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 ‘TRUE’ cells to add the data. See the above image to add your own data.

Step 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 cells. 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 and paste other data as per your requirement.

Step 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 displays only the ‘FALSE’ cells as given in the image below.

Click Filter dropdown and click only FALSE

Step 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: Copy Data In Alternate Rows

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

I hope you like this post of how to copy data to the alternate rows in Excel.

You May Also Like to Read