When I try to drag down a formula a little box called "Auto Fill Options" pops up. Ever time the "copy cells" is automatically selected. This was not the case a few days ago.
What I want to do is "Fill Formatting Only." What do I need to do to make excel always "fill formatting" instead of copy cells.
Thanks!
Bookmarks