AutoFill Above in empty cells

**excelgrrl** · 12-15-2009, 06:15 PM

I have seen many posts on how to find the next empty cell and then copy the data down, however; I am trying to do almost the opposite.

I need to be able to click on a cell and have that cell's data copied above it until there isn't another empty cell.

I will attach a small portion of my worksheet for viewing.

Column A has account numbers and Column B has the brand of product. Unfortunately when I imported this data into excel from our software program it lists all the brands and then the account number is listed on the last row of brands.

**rwgrietveld** · 12-15-2009, 06:26 PM

Put this in D2 and drag down (double click the cell handler)

Please Login or Register  to view this content.

Now Column D needs to be copy Paste special value to column A.

Finally delete column D

**Huron** · 12-15-2009, 06:37 PM

A quick way to do it is to highlight A1 to A716 then Ctrl + G (or Edit - Go To ) - Special - Blanks. This will highlight only the blank cells in the selected area and the active cell will be the first one A63. Type =A64 then Ctrl + Enter and this will fill up the missing values. Then select the whole column, Copy and Paste Special - Values