Copy down - special to fill only the blank cells

[Guest]

I have seen the following where I want to copy down specially ONLY INTO THE
BLANK SPACES, but don't remember how to do this. Any ideas is greatly
appreciated. The example below best demonstrates the need.

ORIGINAL (example of the cells, separated by spaces)
A C Y I U
D E R P
X
T B

When I do the special copy down, I want it to look like the following:
A C Y I U
A D E R I P
A X E R I P
T X B R I P
T X B R I P

Essentially, what I saw a long time ago, was a 3-4 step process where my
friend:
1. Selected all the cells
2. Somehow did something to deselect the populated cells and only have the
blank cells
3. Fill down from the line above

Any help is appreciated! I know this can be done without macros.

Thanks!

 

[Dave Peterson]

Debra Dalgleish has some techniques at:
http://www.contextures.com/xlDataEntry02.html

 

[Guest]

Thanks Dave! You are a savior! This is it!

Debra Dalgleish has some techniques at:
http://www.contextures.com/xlDataEntry02.html

 

[Gord Dibben]

Mike

Select all rows except for the top row.

F5>Special>Blanks>OK

In active cell enter = sign then point to cell above and hit CTRL + ENTER

When happy with results, copy>paste special(in place)>Values>OK>Esc.


Gord Dibben Excel MVP