Fill blanks in column

[Greymud]

I have data in a column where A2 has a date, A10 has a date, and A23 has a date - the other cells are blank (except header in A1). I need to fill in the blanks the same as the full cell above.

Any assistance is appreciated.

 

[Joe4]

Take a look at the first option here: How to fill blank cells with value above / below / left / right in Excel?

 

[Greymud]

This is exactly what I needed!

Thanks!

 

[Joe4]

You are welcome!

I felt the same way when I first discovered this cool little trick. It often comes in very handy.