Caculated Columns

I have AutoComplete for Cell Values enabled. But when I finished calculating one cell, the formula I used didn't automatically expand to the rest of the column by itself. I have to use the fill handl...