Select every nth cell in a column

[eozkired]

Hello, this is my first post.

I have a excel file that people fill in vaca, holiday, etc, and I would like to be able to select every nth (usually 5th) cell in a column so I can paste in repeating events. I've seen how to select whole columns/rows, but not how to do that at the cell level. Thanks in advance for your help.

[Bernie Deitrick]

There are a number of ways to do that.

For example, in a cell in row 2, enter the formula

=MOD(ROW()-2,5)+1

and copy that cell down to match your entries.

Then apply a filter to that column, and choose a number that matches the rows where you want to enter a value. That will hide 4 out of each 5 rows. Then select all the cells in the column where you want to enter your value, type the value, and use Ctrl-Enter instead of just Enter. That will fill all the selected cells with that value. Then remove the filter and you're done.

Or - if you want to enter the same 5 things in repeat, simply enter them into a group of 5 cells, select those 5 cells, copy them, then select cells in multiples of 5 and paste.