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

[vgr]

I have a table that looks like this

Apr-13	455
	45
	23
	4
May-13	5
	5
	5
	5
	35

<tbody>
</tbody>

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