4 Ways to Select Every Other Row in Excel | Alternate Rows | Copy, Paste, Separate, Highlight

In this Excel video tutorial, we gonna see 4 easy Ways to Select Every Other Row in Excel or to Select Alternate Rows in Excel. You can use a date set, a blank sheet, a table etc.

In the first method, we will manually select the range corresponding to the row in our table using the CTRL shortcut key to be able to select several rows at the same time, at once.

In the second method, we will click on the left on the numbers referring to each of the rows, because this way we can select the entire row in the Excel sheet. We can use the control button to select multiple rows at once.

However, these two processes can take a long time as they are done manually, so to save time and automate tasks in Excel we can use a helper column or use a VBA code, Visual Basic for Applications.

The third method is to use a help column with the alternating sequence that we need, for example, select every other row, so we can use the sequence A, B, A, B etc., but if you want to select one row every three, you can use the sequence A, B, C, A, B, C, etc. Now, with the sequence created you can filter your table and then select only the criteria you need, the row option you need.

The fourth and final method is using a VBA code to automate tasks. You don't need to worry, as we don't need to learn how to create a code in Excel with VBA, you can simply copy and paste the code below, but we have to be mindful as some details may change, as explained in the video, such as, the row where you want to start and also the name of your worksheet.


⭐ CODE:

Sub SelectEveryOtherRow()
Dim ws As Worksheet
Dim rng As Range
Dim cell As Range
Dim lastRow As Long
Dim selectedRange As Range
Dim i As Long

' Set your worksheet and range
Set ws = ThisWorkbook.Sheets("Sheet1") ' Change Sheet1 to your sheet name
lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row ' Change "A" to the column you want to check for the last row
Set rng = ws.Range("A1:A" & lastRow) ' Change "A1" to your starting cell and "A" to your column

' Loop through each row
For i = 1 To lastRow Step 2
If selectedRange Is Nothing Then
Set selectedRange = rng.Cells(i, 1)
Else
Set selectedRange = Union(selectedRange, rng.Cells(i, 1))
End If
Next i

' Select the range
If Not selectedRange Is Nothing Then selectedRange.EntireRow.Select
End Sub

⭐

#JopaExcel #Dashboard #Excel