Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an iWork Numbers spreadsheet with thousands of rows. How can I select every 5th row from that spreadsheet?

See also: Select each nth row in Excel

share|improve this question
up vote 1 down vote accepted
  1. In a new column on the first row, enter the following formula:

    =MOD(ROW(), 5)
  2. Copy that cell to every row in the column. It should output the remainder of each row number divided by 5 [1,2,3,4,0,1,2,3,4,0,1…].

  3. Click the Sort & Filter button (or select Table › Show Sort & Filter Panel from the menu).

    In the Sort & Filter Panel, check the box next to "Show Rows that Match the Following." Then select the new column that contains the formula in the first dropdown, is in the second, and 0 in the textbox.

share|improve this answer
This answer was inspired by tpierzina's answer to the same question in Excel.… – Patrick McElhaney Nov 12 '09 at 14:47
Only because VBA macros don't work, otherwise you so would have picked my answer. Right? Right? :-) – user3463 Nov 12 '09 at 14:48
I need to explain it to someone who isn't a super user. I figured macros are a little out of reach. I asked this question after figuring out how to do it in Numbers for the sake of curiosity. – Patrick McElhaney Nov 12 '09 at 14:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.