Selecting every 3rd row in excel?

Question

Hi

I need some help in ms excel. I have a list of 4000 people's name and what i want to do select every third name and put the name in the mail list. The file is ms excel.

Is there a shortcut way of doing this. Can you please tell me how can I achieve this?

Thanks.

Answer 1

Hi, I think i can help you !



in a column adjacent to the mailing list..

type a in first row

type b in second row

type c in third row



drag this abc sequence till the 4000 th row

now go to data---->filter---->autofilter



select "c"



now all the c rows are filtered .... (i.e is third row)



select them all



press " alt + ; "



ctrl +c



paste....

the job is over maaaa.........



if u like it...... let me know

Answer 2

Hi, I'm not sure of how much of a shortcut this is but you could use the control key while you click on every third row to select rows that are not consecutive.

Answer 3

there is no short cut for doing that sry.