The auto fill options menu buttons enable us to give options for us to choose the filling cells on the fill operation. There is also a type of auto fill options that can help us to fills the destination area by just using the format given in the source area even though that the content is not filled.