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’.

 

EnableFillHandle

Leave a Reply

Your e-mail address will not be published. Required fields are marked *