Can I fill non-adjacent cells with the fill feature? (example listed)

[vyrys]

Hi everyone,
this site is awesome. Thank you all for your input.... it is so helpful.

Something I can't seem to figure out, is how to enter data in non-adjacent cells using a fill command.

Here is what I am trying to do:
in the column, I am holding ctrl button to select every 10th cell down the sheet. I need to enter a date in every selected cell that is exactly 7 days apart, i.e., 11/7/08 then 11/14/08 then 11/21/08, etc.... but no other dates or data.

I have tried to figure out a way to do this other than manually, but am confounded.

Hope you can help me... my boss is waiting to see if I can pull it off.

Thanks!!!

 

[vyrys]

I am using excel 2007...
Where can I find the "center across selection"?

It wasn't listed in the help file either.... or not that I could find.

 

[Jonmo1]

Format - Cells - Allignment

Top Dropdown menu called Horizontal

 

[vyrys]

Thank you.
I did change the cells to 'center across selection' and the cells are filled properly by the macro now.

I really appreciate the help. My boss will love it.

Also, I will heed the warning about "the merged cells of death" for any future work


Thanks again!