Under Tools | Options | Edit tab, click on Allow Cell Drag & Drop,
then OK.

Hope this helps.

Pete

On Dec 8, 10:33*pm, Snowcap wrote:
Trying to use "fill" function but doesn't work. Tried going into Excel
Options under formulas but not sure which one to check. Please help if you
know how to turn this function on.