Thread: Rows
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Rows

Here is a very simple method using AutoFilter. In an un-used column, enter:
=IF(MOD(ROW(),17)=0,"X","") and copy down

The column will be blank except for rows 17, 34, etc....

Apply Autofilter to this column to hide the other rows.
--
Gary''s Student - gsnu200772


"Deborah" wrote:

I have a worksheet with 716 rows and I need to chose every 17th row. I am
very new to excel please help me...