Select each nth row in Numbers
9,415
In a new column on the first row, enter the following formula:
=MOD(ROW(), 5)
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…].
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, and0
in the textbox.
Related videos on Youtube
Author by
Patrick McElhaney
Updated on September 17, 2022Comments
-
Patrick McElhaney almost 2 years
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
-
Patrick McElhaney over 14 yearsI 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.