Alternative to ctrl+D when there are multiple items that you want to fill down

[vgr]

I have a table that looks like this
[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]Apr-13[/TD]
[TD="class: xl66, width: 64, align: right"]455[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]45[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]23[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]May-13[/TD]
[TD="class: xl66, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]35[/TD]
[/TR]
</tbody>[/TABLE]
I need to fill out the blank cells with the respective year. If I select the entire area and hit ctrl-D, all the cells get the contents of the first one. I however want april and may to be filled out on their own with a shortcut. Do let me if you know of a way around this.

 

[Armando Montes]

Try:
http://www.contextures.com/xlDataEntry02.html

 

[NeonRedSharpie]

I usually use a helper column for things like this. Then I put in the formula:

=IF(A2="",B1,A2)

 

[vgr]

Awesome... Thanks a lot Armando

Try:
http://www.contextures.com/xlDataEntry02.html