Great, Bernie, that worked fine, thanks very much.

BrownieBodrum

"Bernie Deitrick" wrote:

Brownie,

Insert a new column A. The put the number 35 into cell A1, then in A2, use the formula

=MOD(ROW()-2,$A$1)

and copy down to the bottom of your used range.

Then filter on column A, to show values of 0.

Change the value in cell A1 to show different row counts (i.e., 10 to show every tenth row).

HTH,
Bernie
MS Excel MVP


"browniebodrum" wrote in message
...
How can I get Exel to display every (eg) 35th row only?