Hide certain number of rows and view one row

[salmanisn]

hi all
i have a sheet with a large nuber of rows actuly it gives a data every second for some times 30 minutes or more i want to reduce the nimber of rows displayed
say to hide 30 rows and view the 31 ,then hide another 30 and view one and so on.
any idea
thanks in advance

[Alf]

Have you tried selecting the rows number in the leftmost column, right click and the select "Hide"?

Alf

[Palmetto]

Use a helper column and enter this formula, copied down the column.

=MOD(ROW(),31)=0

The formula will return TRUE or FALSE.

Set Auto-Filter on the helper column to show only TRUE values.