How to fill in range of blank rows wth data fr last row previos ra
 

Dear all,

I wish to know how could I fill in range of blank rows with the data of the
last row of the previous range. Eg. A1 contains APPLE, A2-A6 is blank A7
contains ORANGE A8-A12 is blank, A13 contains CHERRY and A14-A20 is blank. I
wish to fill is A2-A6 with APPLE, A8-A12 with ORANGE, and A14-A20 with
CHERRY. How can I do that?

Thank you very much in advance for your kind help.

How to fill in range of blank rows wth data fr last row previos ra
 

See this:

http://contextures.com/xlDataEntry02.html

--
Biff
Microsoft Excel MVP


"Shinta Chen" <Shinta wrote in message
...
Dear all,

I wish to know how could I fill in range of blank rows with the data of
the
last row of the previous range. Eg. A1 contains APPLE, A2-A6 is blank A7
contains ORANGE A8-A12 is blank, A13 contains CHERRY and A14-A20 is blank.
I
wish to fill is A2-A6 with APPLE, A8-A12 with ORANGE, and A14-A20 with
CHERRY. How can I do that?

Thank you very much in advance for your kind help.