Why aren’t my formulas dragging down?

If you’re trying to fill down your formulas, and nothings happening, then there’s a small change you need to make to your Excel Options.


Open the Options menu, and go to Advanced. You’ll find within the ‘Editing Options’ section there is a tick box called ‘Enable fill handle and cell drag-and-drop’.



Leave a Reply

Your email address will not be published. Required fields are marked *