Thread: Rows
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deborah Deborah is offline
external usenet poster
 
Posts: 35
Default Rows

Thank you I hope I was not a bother or annoyance to you as the other person
posted.

"Gary''s Student" wrote:

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...