Select columns A and B.

F5SpecialBlanksOK.

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

You can then copy A and B and Paste Special(in place)ValuesOKEsc.


Gord Dibben MS Excel MVP

On Thu, 6 Jul 2006 05:51:02 -0700, Jerome
wrote:

Good day,

Could someone please help me with the following. I want to fill down
multiple cell contents within the same columns. There are over 12000 rows and
the columns vary from 2 or mo

A B
1 abc 123
2
3
4
5 def
6
7
8 ghi
9
10
11 jkl
12
13
14
15 mno
16
17
18
19 pqr

Thank you and best regards,

Jerome