Excel Worksheet

New Contributor


I was wondering if anyone could help me with this. You see how you can copy formulas by selecting and then dragging to the next cell, for some reason I am not able to do that. My excel sheet is acting weird...how do I bring it back to normal please

Thank you for the help

2 Replies


Select File > Options > Advanced.

In the 'Editing options' section, make sure that 'Enable fill handle and cell drag-and-drop' is ticked.

@Hans Vogelaar Thank you very much it is working now...