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

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