Forum Discussion

AmmaAb's avatar
AmmaAb
Copper Contributor
Oct 28, 2022

Excel Worksheet

Hi 

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

excel
office 365

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 28, 2022

    AmmaAb 

    Select File > Options > Advanced.

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