auto fill the blank with value
 

how can i auto fill the blankcell with a value till the next blank..den auto
fill again with another values..mean in this case i wan the value "A" to fill
up all the blank cell below it and stop on top of the value"B" den auto fill
with "b" values to nxt blank n cont...

eg..

col a col b
A 1
2
3
B 2
3
C 4

auto fill the blank with value
 

Say your list is from A2 to A100 with some values and some blanks.
First highlight the range a2 to A100
Then Edit/Goto/Special blanks.
Then enter the following formula
=if(A1<A2,A2,A1) and hit control-Enter
(Control Enter merely fills the formula in all selected cells)

"violet" wrote:

how can i auto fill the blankcell with a value till the next blank..den auto
fill again with another values..mean in this case i wan the value "A" to fill
up all the blank cell below it and stop on top of the value"B" den auto fill
with "b" values to nxt blank n cont...

eg..

col a col b
A 1
2
3
B 2
3
C 4