Thread: Rows
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Rows

Why do you want to choose these rows is a question that has not yet been asked.

Perhaps you don't have to choose them to work with them.


Gord Dibben MS Excel MVP

On Fri, 7 Mar 2008 07:31:04 -0800, Deborah
wrote:

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