Excel highlight every other row automatiucally code#

Other popular features: Merge Cells without Losing Data | Grid Focus (reading layout) | Advanced Combine Rows | Insert QR Code | Make up a Number. Select the data range either by click-dragging through it or by identifying the top-leftmost cell and bottom-rightmost cell. Ĭombine worksheets: Combine worksheets from workbooks into one worksheet | Combine all same name worksheets into one. Super Lookup: Lookup Across Multiple Sheets | Multi-condition Lookup | One-to-many Lookup | LOOKUP from Right to Left. įormula Helper: Over 40 practical formulas, including Calculate age based on birthday | Add years/month/days/weeks to date | Count total words. Ĭhart Tools: 50+ chart types with examples, including Gantt Chart | Bubble Chart | Waterfall Chart | Bullet Chart. Īdvanced Drop-down List: Colored Drop-down List | Multi-select Drop-down List | Drop-down List with Check Boxes. Text Tools: 12 Text Tools with more than 50 options, including Add Text | Remove Characters | Extract Text | Remove Leading Zeros.

Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. With VBA code, you can only select one row with specified intervals, if you need to select two, three or other rows with specified intervals, the Kutools for Excel can help you solve this problem easily and conveniently. You can change the interval as you need in the second KutoolsforExcel dialog. Click OK, and the every third row has been selected. Save your time using keyboard shortcuts Use the Alt + O + D shortcut to open the conditional formatting rules manager window. To quickly highlight every alternate row in Excel, follow the steps below: 1. Click OK, and in this case, I input 3 in the another pop out dialog as the interval row. We shade every other row in the B3: D13 range in this example. And a dialog pops up for you to select a range.

Set OutRng = Application.Union(OutRng, rng)ģ.Then click button to run the code. In the resulting dialog, click the Use a Formula to Determine Which Cells to Format option. XInterval = Application.InputBox('Enter row interval', xTitleId, Type:=1)įor i = 1 To Step xInterval + 1 On the Home tab, click the Conditional Formatting dropdown (Styles group) and choose New Rule. Set InputRng = Application.InputBox('Range :', xTitleId, InputRng.Address, Type:=8) Highlight the range that you want to select every other or nth row.Ģ.Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and input the following code into the Module: Sub EveryOtherRow() With VBA code, I can finish it as follows:ġ. In this example, I will select one row with two intervals. Select every other or nth row with Kutools for Excel You can select them manually, but if there are hundreds of rows, this method is not a good choice. When we use a worksheet, sometimes, we need to select the every other or nth row of the sheet for formatting, deleting or copying purpose.

Excel highlight every other row automatiucally how to#

How to select every other or nth row in Excel?