💻 Software

Select each nth row in Excel

Fresh5 days ago

Mar 15, 2026176518 views

Confidence Score0%

Problem

I have an Excel spreadsheet with thousands of rows. I want to select every 7th row from that spreadsheet. (By "select," I mean delete all of the other rows, or copy the selected rows into a new worksheet.) What's the easiest way to do that in Excel 2003? See also: Select each nth row in Numbers

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: Select each nth row in Excel

Low Risk

Insert a column In first row insert formula =MOD(ROW(),7) Copy down Copy/paste special/values Data/Filter out the ones you want (0 or 6, probably) Delete the rest of the rows Remove filter Delete column

Awaiting Verification

Be the first to verify this fix

Select each nth row in Excel

Problem

1 Fix

Fix for: Select each nth row in Excel

Environment