D
Deborah
I have a worksheet with 716 rows and I need to chose every 17th row. I am
very new to excel please help me...
very new to excel please help me...
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Coderre
You already have an active thread open
on that question(with the subject "Filter").
Posting duplicate questions just causes confusion and annoyance.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
on that question(with the subject "Filter").
Posting duplicate questions just causes confusion and annoyance.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
G
Gary''s Student
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.
=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.
D
Deborah
I apologize for that. I didn't make myself clear that I am very unfamiliar
and the response I got I could not understand. Again I apogize for any
confusion I caused you.
and the response I got I could not understand. Again I apogize for any
confusion I caused you.
D
Deborah
Thank you I hope I was not a bother or annoyance to you as the other person
posted.
posted.
G
Gord Dibben
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
Perhaps you don't have to choose them to work with them.
Gord Dibben MS Excel MVP