Fill in blank cells with line above

[gleakos]

I need to fill in the blank cells with the information from the cell above
until the next cell is not null. For example:
Column A
Bill
blank
blank
Bob
I need the blanks to read as Bill. Is there a function or something I can
use.

 

[T. Valko]

Watch this short video:

http://www.contextures.com/xlVideos01.html#FillBlanks

 

[Gord Dibben]

Select the column then F5>Special>Blanks>OK

Type an = sign in active blank cell then point or arrow up to cell above.

Hit CTRL + ENTER

Copy>Paste Special>Values>OK>Esc


Gord Dibben MS Excel MVP

 

[ATHAR]

Hi Gord Dibben,
Good Work dear

Thanks
===============================

 

[Fat Jack Utah]

I did this, but must be missing something.. It kept blanks highlighted blue
but only copied to the cell below.. it did not fill all blanks with the data
above as shown in video.

 

[Fat Jack Utah]

Thanks.. the CNTRL ENTER is what was missing from the prior reply.. Thanks
again

 

[Dave Peterson]

Watch the video again. It is there.

Thanks.. the CNTRL ENTER is what was missing from the prior reply.. Thanks
again

 

[Don Guillett]

try this idea from a posting of mine today.

Sub copydn()
mc = 2 'column B
For i = 1 To cells(rows.count,mc).end(xlup).row
If Cells(i + 1, mc) = "" Then
Cells(i + 1, mc) = Cells(i, mc)
End If
Next i
End Sub